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
[/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