Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : General

Author Message
 Post subject:
PostPosted: Tue Mar 15, 2005 4:53 am 
Offline

Joined: Sat Mar 12, 2005 10:44 pm
Posts: 10
If i have more then one records(Rows) are fatched in a Sql Statement how can we handle these records one by one..?


Back to top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 15, 2005 5:12 pm 
Offline

Joined: Wed Mar 19, 2003 4:28 pm
Posts: 510
Location: Canada
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.


Back to top
 Profile WWW 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : General


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.