another sql error any help appreciated

abrewitt · June 19th, 2006, 12:22 PM

Can anyone see my 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")

Thanks, Anthony

Donny Bahama · June 20th, 2006, 06:17 PM

Another comma before WHERE.

abrewitt · June 21st, 2006, 05:29 AM

Sorted, Thanks!