02-09-2011
This read behaviour appears to be POSIX compliant though:
SYNOPSIS read [-r] var...
read synopsis
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
what is the problem with this comparison in ksh script:
if " ]
it gives syntx error (3 Replies)
Discussion started by: gfhgfnhhn
3 Replies
2. UNIX for Dummies Questions & Answers
I have:
datafile contains 1234567890
>wc -c datafile | awk '{print $1}'
>11
The program
#!/bin/ksh
let n = (wc -c datafile | awk '{print $1}')
echo $n
I expect n to be 11 but it gives error message. What is wrong with this statement?
Thanks! (3 Replies)
Discussion started by: bobo
3 Replies
3. Shell Programming and Scripting
I understand this question probably poses some child like stupidity, but I can't get this if statement to work for love or money.
#!/bin/ksh
echo "Input either 1 or 2"
read Num
if ; then
echo "Message 1"
if ; then
echo "Message 2"
else
echo "false"
fi
$ ksh decisions
Input either 1... (6 Replies)
Discussion started by: Hazmeister
6 Replies
4. Shell Programming and Scripting
Hi,
I need to compare two variables using if condition and i am not sure if am right or wrong. My code is like :
if
then
echo "new file"
else
echo "old file and remove it"
fi
where both variables contain time : filetime contains the time when a file... (2 Replies)
Discussion started by: manmeet
2 Replies
5. Shell Programming and Scripting
I am trying to write a ksh script using the case statement to select certain directories to remove. The directories that I am looking for are in the following format 2008-10-10. I want to exclude all other files/directories that contain anything other the 4 digit year,a dash, 2 digit month, a... (2 Replies)
Discussion started by: dgilc
2 Replies
6. UNIX for Dummies Questions & Answers
im trying to write an until statement which dont go onto the next stage until the user inputs a certain phrase. It is then stored in an array. Ive come up with this code so far but its not working and i dont know why.
read in1
until
do
echo "Incorrect, try again"
... (2 Replies)
Discussion started by: strasner
2 Replies
7. Shell Programming and Scripting
Hi guys,
im new to UNIX so bear with me.
would it be possible for me to create an if statement where i can have a key being entered and something happening after that. (bad explanation)
eg. If user enters letter 'q' then
close window or exit puTTy
Thanks in advance (1 Reply)
Discussion started by: robbrad
1 Replies
8. Shell Programming and Scripting
Hi.
With the help of this group I have created a shell script to find the factorial of a number.
OK. Then I got wild.;) I tried to put in a check to make sure the entry is a number.
read num
If )) then
echo "This is not a valid number. Try again."
fi
while (( $var <= $num)) more... (5 Replies)
Discussion started by: Ccccc
5 Replies
9. Shell Programming and Scripting
How can I search get if to pinpoint 1 word in a line and have it do something for me?
example:
KEY1="<< Response ... Total of 2 >> Sun Jun 19 15:30:18 2011 Tx Power Level is 27.7 Bm ~ "
if ];
then command;
else error;
fi
Thats just a quick sample. I want my if statement to se the... (5 Replies)
Discussion started by: 82280zx
5 Replies
10. Shell Programming and Scripting
Hi
I tried the below code where it is working properly
#!/bin/ksh
set -x
date1_data=abc.txt
date2_data=bcd.txt
if diff $date1_data $date2_data >/dev/null ; then
echo "Equal"
else
echo "Not Equal"
fi
Then I tried like below where i want to use only if fi not else part
... (3 Replies)
Discussion started by: smile689
3 Replies
LEARN ABOUT PHP
sqlsrv_cancel
SQLSRV_CANCEL(3) SQLSRV_CANCEL(3)
sqlsrv_cancel - Cancels a statement
SYNOPSIS
bool sqlsrv_cancel (resource $stmt)
DESCRIPTION
Cancels a statement. Any results associated with the statement that have not been consumed are deleted. After sqlsrv_cancel(3) has been
called, the specified statement can be re-executed if it was created with sqlsrv_prepare(3). Calling sqlsrv_cancel(3) is not necessary if
all the results associated with the statement have been consumed.
PARAMETERS
o $stmt
- The statement resource to be cancelled.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_cancel(3) example
<?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 = "SELECT Sales FROM Table_1";
$stmt = sqlsrv_prepare( $conn, $sql);
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
if( sqlsrv_execute( $stmt ) === false) {
die( print_r( sqlsrv_errors(), true));
}
$salesTotal = 0;
$count = 0;
while( ($row = sqlsrv_fetch_array( $stmt)) && $salesTotal <=100000)
{
$qty = $row[0];
$price = $row[1];
$salesTotal += ( $price * $qty);
$count++;
}
echo "$count sales accounted for the first $$salesTotal in revenue.<br />";
// Cancel the pending results. The statement can be reused.
sqlsrv_cancel( $stmt);
?>
NOTES
The main difference between sqlsrv_cancel(3) and sqlsrv_free_stmt(3) is that a statement resource cancelled with sqlsrv_cancel(3) can be
re-executed if it was created with sqlsrv_prepare(3). A statement resource cancelled with sqlsrv_free_statement(3) cannot be re-executed.
SEE ALSO
sqlsrv_free_stmt(3), sqlsrv_prepare(3).
PHP Documentation Group SQLSRV_CANCEL(3)