03-13-2013
@franzpizzo: if LOWER is less or equal 0, and test is alpha, it will be considered "in range"!
This User Gave Thanks to RudiC For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
If I want to read user input and want to validate if it is a numeric number in some range of 1-100 what would be the best way?
Sabina (5 Replies)
Discussion started by: sabina
5 Replies
2. Shell Programming and Scripting
Okay, well this is more or less my first attempt at writing a shell script.
Anyways, here's my code:
cd ${PATH}
if
then
rm ${FILE}
./anotherScript
else
exit 1
fi
exit 1
Anyways, it's a pretty simple script that is supposed to search for the... (4 Replies)
Discussion started by: cbo0485
4 Replies
3. UNIX for Dummies Questions & Answers
Can you use an if statement after an else?
example
if
then
echo "word"
else
if
then
echo "word" (1 Reply)
Discussion started by: skooly5
1 Replies
4. UNIX for Dummies Questions & Answers
Hey guys,
I'm trying to setup a case statement that checks a value against 5 separate ranges of numbers.
Here are the things I've tried with no success.
case "$AGE" in
"<10") echo "You're in this decade.";;
"") echo "You're in this decade.";;
"") echo "You're in... (5 Replies)
Discussion started by: fufaso
5 Replies
5. Shell Programming and Scripting
Hello all,
I'm trying to automate an if statement in my Perl script. The script opens an input file for reading, checks each line in the file for a particular substring, and if it finds the substring, writes it to an output file.
There are approximately 200 different input files. Each has... (3 Replies)
Discussion started by: Galt
3 Replies
6. Shell Programming and Scripting
How do I test multiple words in a string test like below:
if ]
then
print "You entered $TBS name.\n"
else
print "You entered an incorrect response.\n"
fi
This test does not work. I have tried different syntax versions. How does this work? And is there a better way to do it?
... (10 Replies)
Discussion started by: djehresmann
10 Replies
7. Shell Programming and Scripting
Hello,
We have to configure servers with a range of IPs which is in itself a subject for another script assistance request -but- we have run into quite a few IP ranges with routing problems lately.
I've been trying to figure out the best way to test a range of IPs, I mean, manually it's not... (4 Replies)
Discussion started by: boxgoboom
4 Replies
8. Shell Programming and Scripting
Hello,
I am trying to build a test statement but I can't make it work
I want to rearrange some fields, so if my "$cfg" variable contains a string ending with .log (*.log) I want to move it in another field.
Any help will be much appreciated!
Thank you
Shell:sh
if
then
log="${cfg}"... (9 Replies)
Discussion started by: drbiloukos
9 Replies
9. Shell Programming and Scripting
Hi All.
I have a file that has an ID Number field....some of the ID Numbers are actual SSNs. ...does anyone know the range that SSNs may be...this is what I have found so far poking around SSN info sites....
greater than 001-01-0000 and less than 770-00-0000. Does anyone know this to be... (1 Reply)
Discussion started by: lyoncc
1 Replies
10. Shell Programming and Scripting
Is there a way to create a loop that will output number starting from 0.1 to 10.0
0.1
0.2
0.3
0.4
0.5
..
...
10.0
This is what i tried.
for i in {1..50}; do printf -v i '%02d' $i ; echo "$i"; done
That will print
01
02
03
..
..
50 (9 Replies)
Discussion started by: vietrice
9 Replies
EXECUTE(7) SQL Commands EXECUTE(7)
NAME
EXECUTE - execute a prepared statement
SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ]
DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the pre-
pared statement must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
their parameters; the name of a prepared statement must be unique within a database session.
For more information on the creation and usage of prepared statements, see PREPARE [prepare(7)].
PARAMETERS
name The name of the prepared statement to execute.
parameter
The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the
data type of this parameter, as was determined when the prepared statement was created.
OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.
EXAMPLES
Examples are given in the Examples [prepare(7)] section of the PREPARE [prepare(7)] documentation.
COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
somewhat different syntax.
SEE ALSO
DEALLOCATE [deallocate(7)], PREPARE [prepare(7)]
SQL - Language Statements 2010-05-14 EXECUTE(7)