Gossamer Forum
Home : General : Databases and SQL :

SQL update returns err 424

Quote Reply
SQL update returns err 424
I'm trying to update a record using SQL in an HTML file, the code looks like this:

[/code]
sql="UPDATE CLH_Projects SET "
sql=sql & "Loan_No = '" & Request.Form("Loan_No") & "', "
sql=sql & "Legal1 = '" & Request.Form("Legal1") & "', "
sql=sql & "Legal2 = '" & Request.Form("Legal2") & "', "
sql=sql & "Address1 = '" & Request.Form("Address1") & "', "
sql=sql & "Address2 = '" & Request.Form("Address2") & "', "
sql=sql & "City ='" & Request.Form("City_key") & "', "
sql=sql & "County = '" & Request.Form("County_key") & "', "
sql=sql & "Company_Key = '" & Request.Form("Company_Key") & "' "
sql=sql & " WHERE Project_Key = '" & ProjKey & "'"

on error resume next

conn.Execute sql

response.write(sql)



response.write(", 2-" & err &" ")

if err<>0 then
response.write("No update permissions!")
else
response.write("Record " & ProjKey & " was updated!")
end if


Can somebody help me figure where the error is?
Thanks!

DG
Quote Reply
Re: [dggonzalez] SQL update returns err 424 In reply to
I've moved your thread. PLEASE use the correct forum!

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [dggonzalez] SQL update returns err 424 In reply to
For de-bugging purposes, remove the error codes at the bottom (if err....) , so that you can see what the error is, since you are using ON ERROR function, that will mask the actual error you are receiving.

Basically, Err 424 is an object undefined error. But to see which object is undefined, you need to remove the error checking codes.

Hope this helps.
========================================
Buh Bye!

Cheers,
Me