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 3 of 3

Thread: syntex error

  1. #1
    New Coder
    Join Date
    Dec 2009
    Posts
    17
    Thanks
    4
    Thanked 0 Times in 0 Posts

    syntex error

    i have following error comes

    Microsoft JET Database Engine (0x80040E14)
    Syntax error (comma) in query expression 'ID=72, 72'.
    /addnews/Latestnews/update_record.asp, line 34

    the query is

    Code:
    SQL = "UPDATE latestNews SET newstitle='" & newstitle & "', newsbody='" & newsbody & "', newsdate='" & newsdate & "' WHERE 
    
    ID=" & ID
    whts wrong??

  • #2
    Regular Coder
    Join Date
    Apr 2009
    Posts
    244
    Thanks
    1
    Thanked 20 Times in 20 Posts
    crystal nano,

    Do a Response.Write(SQL). Copy the resulting string and try to run it and evaluate it on the SQL side. I'm sure from there, you'll be able to pretty much figure out on your own what is wrong with the query.

    Regards,
    Mike

  • #3
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    i'd say that you likely have two fields for ID, so when you do the request you are getting both split by a comma


  •  

    Posting Permissions

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