Tim, what error are you getting? It's always a good idea to report specifically what you're seeing.
Often, errors after initial success inside a loop are related to the loop going too far for one of the objects being addressed. In your example below, could i be going past the end of the rs2 recordset? As an aside, it would probably be more efficient to do this kind of copying inside the database by calling a stored procedure to do it rather than iterating through the recordset one record at a time in ASP code. HTH -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 7:02 AM To: ActiveServerPages Subject: error in SQL statment hi, in a script, i'm populating a DB table using a for i=1 to something rs.addNew rs(i)=rs2(i) rs.upDate next but i get an error on the last update! can i somehow get the SQL query the server is executing that is causing the error? using "on error", an "rs" method or something similar? TIA for your time Tim --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
