...

Another SQL error help appreciated!

abrewitt
06-19-2006, 08:02 PM
Apparently I cannot code SQL; - can u see my mistake?


strCmdTxtMem="UPDATE pages SET page_name='" & request("pageName") & "',"
strCmdTxtMem=strCmdTxtMem & " page_content='" & request("pageContent") & "'"
strCmdTxtMem=strCmdTxtMem & " page_keywords='" & request("pageKeywords") & "'"
strCmdTxtMem=strCmdTxtMem & " WHERE page_id=" & request("pageId")

Any help appreciated, Anthony

Kid Charming
06-19-2006, 08:56 PM
You're missing commas after your second and third conditions.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum