Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    44

    Unanswered: Syntax error (comma) in query expression

    Hi..
    i kip gettin tis error... but it seems nthin wron to mi.. can ani1 help mi c?
    thanx...

    Syntax error (comma) in query expression

    Code:
    rs_vChecked.Source = "SELECT Rating FROM Test WHERE a='" & check1 & "' , b='" & check2 & "', c='" & check3 &"', d='" & check4 & "', e='" & check5 & "'"

  2. #2
    Join Date
    Jan 2005
    Posts
    362
    SELECT * FROM Persons
    WHERE FirstName='Tove'
    AND LastName='Svendson'
    http://www.w3schools.com/sql/sql_and_or.asp
    dimis

  3. #3
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Or in other words, you need to replace your comma's with and's, don't forget the spaces either side of the and

  4. #4
    Join Date
    Jan 2006
    Posts
    44
    okay, i gt it works.. thanx alot..
    btw, sorry that i have posted de thread twice.. coz initially when i post, it says tt the database had sum prob.. so i posted it again..

Posting Permissions

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