Sponsored Content
Full Discussion: Need help
Top Forums Shell Programming and Scripting Need help Post 302104648 by Glenn Arndt on Friday 26th of January 2007 11:35:09 AM
Old 01-26-2007
Use ksh? Try this:
Code:
integer i=0
cut -d" " -f1 tables.* | while read table; do
  i=i+1
  echo "delete from $table;"
  echo ".IF ERRORCODE <> 0 Then .QUIT $i"
done > outfile

 
DBX_FETCH_ROW(3)							 1							  DBX_FETCH_ROW(3)

dbx_fetch_row - Fetches rows from a query-result that had the DBX_RESULT_UNBUFFEREDflag set

SYNOPSIS
mixed dbx_fetch_row (object $result_identifier) DESCRIPTION
dbx_fetch_row(3) fetches rows from a result identifier that had the DBX_RESULT_UNBUFFERED flag set. When the DBX_RESULT_UNBUFFERED is not set in the query, dbx_fetch_row(3) will fail as all rows have already been fetched into the results data property. As a side effect, the rows property of the query-result object is incremented for each successful call to dbx_fetch_row(3). PARAMETERS
o $result_identifier - A result set returned by dbx_query(3). RETURN VALUES
Returns an object on success that contains the same information as any row would have in the dbx_query(3) result data property, including columns accessible by index or fieldname when the flags for dbx_query(3) were set that way. Upon failure, returns 0 (e.g. when no more rows are available). EXAMPLES
Example #1 How to handle the returned value <?php $result = dbx_query($link, 'SELECT id, parentid, description FROM table', DBX_RESULT_UNBUFFERED); echo "<table> "; while ($row = dbx_fetch_row($result)) { echo "<tr> "; foreach ($row as $field) { echo "<td>$field</td>"; } echo "</tr> "; } echo "</table> "; ?> SEE ALSO
dbx_query(3). PHP Documentation Group DBX_FETCH_ROW(3)
All times are GMT -4. The time now is 01:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy