Syntax error (comma) in query expression

Cuttie0506 · #1 (**permalink**) 01-17-06, 01:48

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 & "'"

dimis2500 · #2 (**permalink**) 01-17-06, 10:24

SELECT * FROM Persons
WHERE FirstName='Tove'
AND LastName='Svendson'
http://www.w3schools.com/sql/sql_and_or.asp
dimis

rokslide · #3 (**permalink**) 01-17-06, 17:11

Or in other words, you need to replace your comma's with and's, don't forget the spaces either side of the and

Cuttie0506 · #4 (**permalink**) 01-17-06, 23:31

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..

Internet Services

Web Development

Digital Marketing

Consumer Tech