Syntax error in an UPDATE statement 1

[codehead]

Hello All:

I can't seem to get the syntax correct on an UPDATE statement. The "pkey" value is an integer and the statement runs o.k. with an integer value, but not with my "request" statement nested in it.

updateStmt = conn.ExecuteSQL("UPDATE REQ_REQUIREMENTS SET ASSIGNED_POC = '"&request("assigned_poc")&"' WHERE pkey = "&request("pkey")&"")

What am I doing wrong?

Thanks!

 

[codehead]

It's working now. I'm using the hidden input field and a plain request on the following page:

updateStmt = conn.ExecuteSQL("UPDATE REQ_REQUIREMENTS SET ASSIGNED_POC = '"&request("assigned_poc")&"' WHERE pkey = "&request("pkey_value"))

Thanks!

 

[DotNetGnat]

glad everything worked for you...

-DNG