Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Apr 2006
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up Another SQL error help appreciated!

    Apparently I cannot code SQL; - can u see my mistake?


    Code:
    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

  • #2
    Regular Coder
    Join Date
    Jun 2005
    Posts
    804
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You're missing commas after your second and third conditions.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •