|Subject:||ADODB error from JS|
|Posted by:||Adrian (Adrian_Garden…@NOSPAMhotamil.com)|
|Date:||Thu, 24 Jul 2003|
I have an ASP page on an intranet IIS server that posts data via a
System DSN to an Access DB, normally it works fine however sometimes it
returns 0 for success but no data is added to the DB!?
Set conn = Server.CreateObject("ADODB.Connection")
sql="Insert Into testtable (Survey_1,Survey_2)
sql=sql & "'" & Request.Form("Survey_1") & "',"
sql=sql & "'" & Request.Form("Survey_2") & "')"
on error resume next
if err<>0 then
Response.Write(" Survey NOT Added! ")
Response.Write("<h3>" & recaffected & " Survey Added </h3>")
Set conn = Nothing
The above is cut down version as there are a lot of fields!
Anyone know why it would return 0 sometimes but not add the data?