TeleFlow Forums http://teleflow.org/phpbb/ |
|
More then One recods in single Sql Statement http://teleflow.org/phpbb/viewtopic.php?f=1&t=234 |
Page 1 of 1 |
Author: | Honest_Words [ Tue Mar 15, 2005 4:53 am ] |
Post subject: | |
If i have more then one records(Rows) are fatched in a Sql Statement how can we handle these records one by one..? |
Author: | Chris [ Tue Mar 15, 2005 5:12 pm ] |
Post subject: | |
The SQL Statement step runs your query, and the Fetch step grabs a single row. So, run your sql statement using the SQL Statement step, then, use a Fetch step to gather a row/record of results. Do whatever processing you want to do with those results, then run the Fetch step again. When the Fetch step follows the bomb/fail path, you have fetched all of the rows. <br> <br>You must make sure that your SQL Statement and the Fetch step used to retreive rows from it both have the same handle number. |
Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |