03-29-2001
thanks ppl.....
I had noticed that this morning about j....when i got a complier error..but soon...got it....
But the promblem is that..that only alters the way it goes to standard out....i need to take it back into a variable and the strcat this to another varaible..and then use embbedded SQL statements to get it back into the Ingres database.....doh!!!!
any other ways.....
Why not itoa........?????????
please...
(
Mojo
10 More Discussions You Might Find Interesting
1. Programming
Which function should I use to convert an Integer to a String or Char format ?
Thanx (2 Replies)
Discussion started by: psilva
2 Replies
2. UNIX for Dummies Questions & Answers
Hi all,
is there an easy way to convert integer to string in bash?
I have numbers like 1, 2, ..., 112, ...
and I would like to get
001 002 003 004 ...
Thank you,
Sarah (4 Replies)
Discussion started by: f_o_555
4 Replies
3. Shell Programming and Scripting
How to convert string into an integer or number
For example :
% set tim = `date`
% echo $tim
Tue Feb 22 16:25:08 IST 2011
here How to increment time by 10 hrs
like 16+10 , here 16 is a string in date cmd. .. how to convert 16 to an integer and added to a another nimber ?
Thanks... (3 Replies)
Discussion started by: sbhamidi
3 Replies
4. Shell Programming and Scripting
I read 3 variables from from Inputfile.txt the third one "startnumber" is a number when i compare it with 9 ($startnumber -le 9) it give's me a "unary operator expected", i know that -le is for number comparison. What i need is to convert $startnumber to integer (i have try to do it with expr but... (8 Replies)
Discussion started by: marios
8 Replies
5. Shell Programming and Scripting
Hi fellows!!
i'm doing something which is not working out for me properly which i don't understand why
nowdate=`date +%s`
echo $nowdate
now the problem how to convert a date which is stored in a variable
mydate="22/Oct/2011"
mydate=`date -d '$mydate' +%s`
it gives error... (11 Replies)
Discussion started by: me_newbie
11 Replies
6. Shell Programming and Scripting
hi,
how to I do this?
i="4.000"
if ; then
echo "smaller"
fi
how do I convert the "4.000" to 4?
Thanks! (4 Replies)
Discussion started by: h0ujun
4 Replies
7. Shell Programming and Scripting
Using below command
awk 'NR==FNR{A=$1;next}
{sum+=($2*A)}END{OFMT="%20f";print int(sum)}' Market.txt Product.txt
answer:351770174.00000
how to convert this to 351770174.
when i try with below command i am getting different result.
awk 'NR==FNR{A=$1;next}... (3 Replies)
Discussion started by: katakamvivek
3 Replies
8. Shell Programming and Scripting
Hi All,
sessionid_remote=$(echo "select odb_sessionid from sysopendb where odb_dbname='syscdr';" | sudo -u cucluster ssh ucbu-aricent-vm93 "source /opt/cisco/connection/lib/connection.profile; $INFORMIXDIR/bin/dbaccess sysmaster@ciscounity")
for sid in $sessionid_remote;do
if * ]];... (2 Replies)
Discussion started by: deeptis
2 Replies
9. Shell Programming and Scripting
Hi all,
I am trying to write a script to be able to
Run top command
Pick the PIDs that are taking more than 90% of CPU time
Get more details like what is the script name and location for that PID
Script should run until I manually kill it by ctrl + C
I have come up with following script... (3 Replies)
Discussion started by: pat_pramod
3 Replies
10. Shell Programming and Scripting
I have data as below
"ROWS merge process complete. thousand rows changed"
I need to get a variable assigned the value of 1000. I mean convert the string thousand to 1000.
Any help or pointer.
Please use CODE tags as required by forum rules! (6 Replies)
Discussion started by: dsravanam
6 Replies
LEARN ABOUT PHP
ingres_unbuffered_query
INGRES_UNBUFFERED_QUERY(3) 1 INGRES_UNBUFFERED_QUERY(3)
ingres_unbuffered_query - Send an unbuffered SQL query to Ingres
SYNOPSIS
mixed ingres_unbuffered_query (resource $link, string $query, [array $params], [string $types])
DESCRIPTION
ingres_unbuffered_query(3) sends the given $query to the Ingres server.
The query becomes part of the currently open transaction. If there is no open transaction, ingres_unbuffered_query(3) opens a new transac-
tion. To close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to
cancel these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use
ingres_autocommit(3) before opening a new transaction to have every SQL query immediately committed. Ingres allows only a single unbuffered
statement to be active at any one time. The extension will close any active unbuffered statements before executing any SQL. In addition you
cannot use ingres_result_seek(3) to position the row before fetching.
Note
Related Configurations
See also the ingres.describe and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $link
- The connection link identifier
o $query
- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3)
for a list of SQL statements that cannot be executed via ingres_unbuffered_query(3). Data inside the query should be properly
escaped.
o $params
- An array of parameter values to be used with the query
o $types
- A string containing a sequence of types for the parameter values passed. See the types parameter in ingres_query(3) for the list
of type codes.
RETURN VALUES
ingres_unbuffered_query(3) returns a query result identifier when there are rows to fetch; else it returns FALSE when there are no rows, as
is the case of an INSERT, UPDATE, or DELETE statement. To see if an error occurred, use ingres_errno(3), ingres_error(3), or ingres_errsql-
state(3).
EXAMPLES
Example #1
Issue a simple un-buffered select
<?php
$link = ingres_connect("demodb");
$result = ingres_unbuffered_query($link, "select * from user_profile");
while ($row = ingres_fetch_row($result)) {
echo $row[1];
echo $row[2];
}
?>
Example #2
Passing query parameters to ingres_unbuffered_query(3)
<?php
$link = ingres_connect("demodb");
$params[] = "Emma";
$query = "select * from user_profile where up_first = ?";
$result = ingres_unbuffered_query($link, $query, $params);
while ($row = ingres_fetch_row($result)) {
echo $row[1];
echo $row[2];
}
?>
Example #3
Inserting a BLOB with parameter types
<?php
$link = ingres_connect("demodb");
//Open a photo
$fh = fopen("photo.jpg","r");
$blob_data = stream_get_contents($fh);
fclose($fh);
//Prepare parameters
$params[] = $blob_data;
$params[] = 1201;
//Define parameter types
$param_types = "Bi";
$query = "update user_profile set up_image = ? where up_id = ?";
$result = ingres_unbuffered_query($link, $query , $params, $param_types);
if (ingres_errno())
{
echo ingres_errno() . "-" . ingres_error() . "
";
}
?>
SEE ALSO
ingres_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3), ingres_roll-
back(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).
PHP Documentation Group INGRES_UNBUFFERED_QUERY(3)