View Single Post
  #10 (permalink)  
Old September 21st, 2004, 06:33 AM
pgtips pgtips is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

usually the easiest way to sort out probs with malformed SQL is to add
Response.Write sql_insert
Response.End

before the line that errors. That way you can see exactly what SQL is going to be sent to the db. Often it's then obvious what the problem is.

Try that and if you can't figure it out then post the SQL here and we'll take a look.

rgds
Phil