Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: Syntax Error with SQL Query

    I am trying to query my database using ASP...i did a Response.Write to view the query.....

    UPDATE BatterStats SET H=3,K=0,E=0,AVG=.456 WHERE ID=23


    It was working fine until i added the AVG part with the decimal and what not. I tried the query in Access and it worked fine. What could the problem possibly be?

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    try this....

    UPDATE BatterStats SET H=3,K=0,E=0,AVG=0.456 WHERE ID=23

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    Originally posted by rokslide
    try this....

    UPDATE BatterStats SET H=3,K=0,E=0,AVG=0.456 WHERE ID=23
    Sorry i actually fixed it...the problem was 'AVG' is a reserved keyword....Access didn't have a problem with it by SQL does.

Posting Permissions

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