of the recordset and then need to move back to the start to be able to loop again. To do this you'd do <BR><BR>oRS.MoveFirst<BR><BR>before your next loop. However, in order for this to work you need to have the proper cursor type:<BR><BR>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima01/html/ima0501.asp<BR><BR>You'd get better performance by using getrows and dumping your recordset into an array:<BR><BR>http://www.4guysfromrolla.com/webtech/tips/t053100-1.shtml<BR><BR><BR>
I am trying to grab data from two tables, heres my SQL statement. The error it gives me is missing operator.<BR><BR>sSQL = "SELECT * FROM DealerCars, TestCar_Replies WHERE DealerCars.Dealer = '" & Session("Dealer") & "' AND TestCar_Replies.ReplyID = " & Session("ReplyID")<BR><BR>any ideas?
probably one of your session vars is empty.<BR><BR>Put a response write and response end after you build the statement (after the line you pasted in so we can see the built statement).<BR><BR>Response.Write(sSQL)<BR>Respons e.Write