SQL error any help really appreciated!

abrewitt · June 16th, 2006, 08:35 AM

I have a SQL error I cannot see and was wondering if u can see it?;

Code:

' build the SQL UPDATE "command string"
strCmdTxtMem="UPDATE link SET link_text='" & request("linkText") & "',"
strCmdTxtMem=strCmdTxtMem & " link_url='" & request("linkUrl") & "',"
strCmdTxtMem=strCmdTxtMem & " link_title='" & request("linkTitle") & "',"
strCmdTxtMem=strCmdTxtMem & " WHERE link_id=" & request("linkId")

I outptted the sql and get this error message;

UPDATE link SET link_text='Blue Anvil', link_url='http://www.blue-anvil.com/', link_title='go to blue anvil design', WHERE link_id=4
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/editmember_process_basic.asp, line 31

i really appreciate any help, Anthony

Rob · June 16th, 2006, 08:50 AM

remove the comma before the WHERE Clause

abrewitt · June 16th, 2006, 08:57 AM

Thats great Rob! thanks!

you can never see ur own!