| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| SQL Fetch with multiple row from database http://teleflow.org/phpbb/viewtopic.php?f=16&t=395 |
Page 1 of 1 |
| Author: | sambabu [ Wed Oct 04, 2006 8:09 am ] |
| Post subject: | |
I would like to know the possiblities of getting multiple rows with single SQL statement. Then need know the logic to retrieve entire data found in the returned rowset/records from the database. <br> <br>Thanks in advance. |
|
| Author: | Chris [ Wed Oct 04, 2006 10:06 am ] |
| Post subject: | |
You can get multiple or all of the rows with a single SQL Statement step, but you have to fetch them one row at a time. <br> <br>Immediately after your SQL Statement step, use a SQL Fetch step to get a row. After you have done whatever you want with that row, go back and fetch another using the same SQL Fetch. When you reach the SQL Fetch and it goes down the bomb, or fail path, you have fetched all the rows for your query. |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|