This can get long and dull, but I often use this kind of thing for basic menu-type stuff:
Code:
clear
function main {
echo "Please choose:
1. Do Something
2. Do something else
3. Exit"
while true; do
read SELECT
case "$SELECT" in
1) SELECT=func_Something;;
2) SELECT=func_Something_else;;
3) SELECT=exit;;
*) echo Invalid selection.; continue
esac
break
done
}
function func_Something {
echo "In $0
Please choose:
1. Do Something More
2. Do something More else
3. Exit"
while true; do
read SELECT
case "$SELECT" in
1) SELECT=func_SomethingMore;;
2) SELECT=func_Something_More_else;;
3) SELECT=exit;;
*) echo Invalid selection.; continue
esac
break
done
}
function func_Something_else {
echo "in $0
Doing something else"
return 1
}
# ... write a function for each possible value of $SELECT...
main
while test $? -eq 0; do
$SELECT
done
HELLO ALL,
URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE.
FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY
and the CITY column records will be: Newyork
washington
... (1 Reply)
Hi all,
i have a data array as followes.
ARRAY=DFSG345GGG
ARRAY=234FDFG090
ARRAY=VDFVGBGHH
so on..........
i need all english letters to be change to lower case. So i am expecting to see
ARRAY=dfsg345ggg
ARRAY=234fdfg090
ARRAY=vdfvgbghh
so on........
If i have to copy this data in... (8 Replies)
Hi
I want to make string substitution ignoring case for search but respecting case for subtitute. Ex changing all occurences of "original" in a file to "substitute":
original becomes substitute
Origninal becomes Substitute
ORIGINAL becomes SUBSTITUTE
I know this a little special but it's not... (1 Reply)
Is there a command that can switch a character variable from UPPER case to lower case?
like
foreach AC ( ABC BCD PLL QIO)
set ac `COMMAND($AC)`
...
end
Thanks a lot! (3 Replies)
Hello Unix Gurus :
It would be really appreciative if can find a solution for this .
I have records in a file .
I need to Capitalize the records based on condition .
For Example i tried the following Command
COMMAND -->
fgrep "2000YUYU" /export/home/oracle/TST/data.dat | tr '' ''... (12 Replies)
please let me know if the below code could be written efficiently inside single awk
case "$INP" in
ksh)
cat catalog | awk 'BEGIN {FS=",";} { print $2 } END {}'
;;
pset)
cat catalog | awk 'BEGIN {FS=",";} { print $3 } END {}'
;;
dml)
cat catalog | awk 'BEGIN {FS=",";} {... (2 Replies)
Hi all,
I am trying to find a way to change first letter in a word from lower case to upper case. It should be done for each first word in text or in paragraph, and also for each word after punctuation like
. ; : ! ?I found the following command
sed -i 's/\s*./\U&\E/g' $@ filenamebut... (7 Replies)
Hi Experts,
Need your guidance for case statement. I tried many way but no success yet.Now my existing code is doing something like below. Each Line of the input file contains one test case.#!/bin/bash
FILE=$1
while read LINE; do
do COMMAND
done < $FILE
Now I want to modify the code... (6 Replies)
Discussion started by: pradyumnajpn10
6 Replies
LEARN ABOUT PHP
fbsql_num_rows
FBSQL_NUM_ROWS(3) 1 FBSQL_NUM_ROWS(3)fbsql_num_rows - Get number of rows in resultSYNOPSIS
int fbsql_num_rows (resource $result)
DESCRIPTION
Gets the number of rows in the given $result set.
This function is only valid for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE query, use
fbsql_affected_rows(3).
PARAMETERS
o $
result -A result identifier returned by fbsql_query(3) or fbsql_db_query(3).
RETURN VALUES
Returns the number of rows returned by the last SELECT statement.
EXAMPLES
Example #1
fbsql_num_rows(3) example
<?php
$link = fbsql_connect("localhost", "username", "password");
fbsql_select_db("database", $link);
$result = fbsql_query("SELECT * FROM table1;", $link);
$num_rows = fbsql_num_rows($result);
echo "$num_rows Rows
";
?>
SEE ALSO fbsql_affected_rows(3), fbsql_connect(3), fbsql_select_db(3), fbsql_query(3).
PHP Documentation Group FBSQL_NUM_ROWS(3)