want to query : YES or NO

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

2. UNIX for Dummies Questions & Answers

Query

Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk...

3. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

4. Shell Programming and Scripting

Query

hi i am producing txt outputs of archives created by our tsm software. problem is some of these files are too large to open in excel so i can despatch. here is a example of the output TAG_460 /prod_bak 7 FILE /ARCHIVE/Whistles- ...

5. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1...

6. UNIX for Dummies Questions & Answers

Need Help on query

I just started to learn unix - need help to write a script to query a logfile and produce the results that contains a specific word "alarm" for a period from X day to Y day. I really have no idea how to begin - :( please help... ____________________________________________________ #...

7. Shell Programming and Scripting

query.....

hi friends i want to know details of `exec` exact use of this command ..... actually i went through the man page but i didn`t get the satisfactory ...conclusion.... thaks in advance....

8. Shell Programming and Scripting

query

I have converted data written on excel sheet in unix through shell & perl prg now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this: hfgg|tytt| but I want like...

9. UNIX for Dummies Questions & Answers

query

hi, how can i do the following..... i have file containing followig a k 10000 b c 200000 d e 50 a j 40 how can i list all rows containg last value more than 1000? and how can i find number of blank rows in the file? THANKS! regards vivek

LEARN ABOUT PHP

ibase_execute

IBASE_EXECUTE(3)							 1							  IBASE_EXECUTE(3)

ibase_execute - Execute a previously prepared query

SYNOPSIS

       resource ibase_execute (resource  $query, [mixed  $bind_arg], [mixed  $...])

DESCRIPTION

	Execute a query prepared by ibase_prepare(3).

	This  is  a lot more effective than using ibase_query(3) if you are repeating a same kind of query several times with only some parameters
       changing.

PARAMETERS

	      o $query
		- An InterBase query prepared by ibase_prepare(3).

	      o $bind_arg
		-

	      o $...
		-

RETURN VALUES

	If the query raises an error, returns FALSE. If it is successful and there is a (possibly empty) result set (such as with a SELECT query),
       returns a result identifier. If the query was successful and there were no results, returns TRUE.

       Note

	       This  function  returns	the  number of rows affected by the query (if > 0 and applicable to the statement type). A query that suc-
	      ceeded, but did not affect any rows (e.g. an UPDATE of a non-existent record) will return TRUE.

EXAMPLES

       Example #1

	      ibase_execute(3) example

	      <?php

	      $dbh = ibase_connect($host, $username, $password);

	      $updates = array(
		  1 => 'Eric',
		  5 => 'Filip',
		  7 => 'Larry'
	      );

	      $query = ibase_prepare($dbh, "UPDATE FOO SET BAR = ? WHERE BAZ = ?");

	      foreach ($updates as $baz => $bar) {
		  ibase_execute($query, $bar, $baz);
	      }

	      ?>

SEE ALSO

       ibase_query(3).

PHP Documentation Group 													  IBASE_EXECUTE(3)

Shell Programming and Scripting