for loop in recordset

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246993 More actions · Answer 1

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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

nplinares Old Hand Points: 335 More actions · Answer 2

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

Phil Parkin SSC Guru Points: 246993 More actions · Answer 3

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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

nplinares Old Hand Points: 335 More actions · Answer 4

Old Hand

Points: 335

November 18, 2008 at 6:19 pm

i will write it to a text file