November 18, 2008 at 7:15 am
Hi,
how can i loop/iterate for all the records/result of my SQL Statement?
Thank you
November 18, 2008 at 3:16 pm
You want to execute a query that returns a resultset and iterate around that? Can you provide more detail about what you are trying to achieve?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 18, 2008 at 5:49 pm
ex .
select lastname, firstname, middlename, birthday from tbl_temp_users
(all fields in tbl_temp_users are varchar, i uploaded the data from tab delimited file)
i want to loop to all the records to check if the date in birthday is a valid date
November 18, 2008 at 6:16 pm
What do you want to do in those cases where the date is invalid? Error? Import the record with a null date?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 18, 2008 at 6:19 pm
i will write it to a text file
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply