02-09-2006
i was missing then after the elif statement.
thanks for that. i read over it so many times and didnt see it
10 More Discussions You Might Find Interesting
1. Programming
I compiled C program under SUN OS sparcv9 ...I had a problem related to SIGBUS which has been resolved by adding an option to the CC compiler which is memory alignement option ..-memalign=1i as I remmber ...after running the program I got the below error please let me KNow more details what should... (2 Replies)
Discussion started by: atiato
2 Replies
2. Shell Programming and Scripting
Hi,
I tried to execute the following code but it showed the output
mobile number : 35353425
corr plan id : 13-may-2008
corr target : 551
active_dt : 23414
no ident : IDD
action name: A
To get the subscriber number for the given mobile number and check if it is active and not... (1 Reply)
Discussion started by: geekforu
1 Replies
3. UNIX Desktop Questions & Answers
Hi All
I've used UNIX in the past experimenting with commands through terminal but thats about it. Im now currently teaching myself "C".
Using a book from the library, the first chapter asks you run and compile your program from a command-line prompt. As you will see the program is very simple,... (4 Replies)
Discussion started by: camzio
4 Replies
4. Shell Programming and Scripting
hi can anyone pls look into this....shell script...
Pls find the error below:
> sh -n tmp
tmp: syntax error at line 28: `(' unexpected
isql -Usa -S$1 -P`grep $1 dbpassword|cut -d ":" -f3` -w2000 -b<<!
set nocount on
declare @i int
declare @dbname char(6)
declare @tmp int
if... (10 Replies)
Discussion started by: rajashekar.y
10 Replies
5. UNIX for Dummies Questions & Answers
Hi
I am having a shell script load_data.sh which calls /home/users/project/.profile. When am executing the script, am getting below error:
$sh -x bin/load_data.sh null
+ . /home/users/project/.profile
bin/load_data.sh: syntax error at line 8: `(' unexpected
The line which is throwing... (1 Reply)
Discussion started by: brijesh.dixit
1 Replies
6. Shell Programming and Scripting
what is wrong with the below script:
---------------------------------------------------------------------------------
#!/bin/bash
echo "Setting JrePath..."
grep -w "export JrePath" /etc/profile
Export_Status=$?
if
echo "JrePath declared"
elif
echo "JrePath not declared"
echo... (2 Replies)
Discussion started by: proactiveaditya
2 Replies
7. Shell Programming and Scripting
Masters, i iam writing a script (dont have much experience in the process of learning) which handles file copy to multiple servers and users for deployment purpose. Below is the snippet.
When ever i run i get syntax error but it works fine on another machine. Please help me out.
if
then... (10 Replies)
Discussion started by: ameyrk
10 Replies
8. Shell Programming and Scripting
Solaris 10
This is my script:
#!/bin/bash
#Script to print number of users and print list of them
NO=`awk < /etc/passwd -F: '{ print $1 }' | wc -l`
echo There are $NO users on system.
echo "Do you want me to list them? (y or n):"
read YORN
if ]
awk < /etc/passwd -F: '{ print $1 }'... (5 Replies)
Discussion started by: kaustubh
5 Replies
9. Shell Programming and Scripting
Hi,
I am getting an wired error.... the script is running fine when i run it manually... but the same when i try to run in nohup mode, i am getting error
if
Error:
syntax error at line 24: `(' unexpected
The above if is the 24th line!!! I dont understand the error... (4 Replies)
Discussion started by: Nithz
4 Replies
10. Programming
Below query is not working for me. Please help me on this
DATA EXCLUDE STATEMENT: TABLE:\"LIKE \'%\_HISTORY\'\", TABLE:\"LIKE \'%\_HIST\'\", TABLE:\"in \(select tname from tab where REGEXP_LIKE(TNAME,\'\_H$\'\))\", TABLE:\"LIKE \'%\_LOG\'\", TABLE:\"LIKE \'DW\_%\'\", TABLE:\"LIKE... (1 Reply)
Discussion started by: princy
1 Replies
LEARN ABOUT PHP
sqlsrv_execute
SQLSRV_EXECUTE(3) SQLSRV_EXECUTE(3)
sqlsrv_execute - Executes a statement prepared withsqlsrv_prepare(3)
SYNOPSIS
bool sqlsrv_execute (resource $stmt)
DESCRIPTION
Executes a statement prepared with sqlsrv_prepare(3). This function is ideal for executing a prepared statement multiple times with dif-
ferent parameter values.
PARAMETERS
o $stmt
- A statement resource returned by sqlsrv_prepare(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_execute(3) example
This example demonstrates how to prepare a statement with sqlsrv_prepare(3) and re-execute it multiple times (with different param-
eter values) using sqlsrv_execute(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "UPDATE Table_1
SET OrderQty = ?
WHERE SalesOrderID = ?";
// Initialize parameters and prepare the statement.
// Variables $qty and $id are bound to the statement, $stmt.
$qty = 0; $id = 0;
$stmt = sqlsrv_prepare( $conn, $sql, array( &$qty, &$id));
if( !$stmt ) {
die( print_r( sqlsrv_errors(), true));
}
// Set up the SalesOrderDetailID and OrderQty information.
// This array maps the order ID to order quantity in key=>value pairs.
$orders = array( 1=>10, 2=>20, 3=>30);
// Execute the statement for each order.
foreach( $orders as $id => $qty) {
// Because $id and $qty are bound to $stmt1, their updated
// values are used with each execution of the statement.
if( sqlsrv_execute( $stmt ) === false ) {
die( print_r( sqlsrv_errors(), true));
}
}
?>
NOTES
When you prepare a statement that uses variables as parameters, the variables are bound to the statement. This means that if you update
the values of the variables, the next time you execute the statement it will run with updated parameter values. For statements that you
plan to execute only once, use sqlsrv_query(3).
SEE ALSO
sqlsrv_prepare(3), sqlsrv_query(3).
PHP Documentation Group SQLSRV_EXECUTE(3)