SQL statment...

[zivon]

hello everyone ! :)

I have a problam with a asp page I'm making
I'm getting this error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'R_EMAIL = [e-mail]'.

this is the code
rs.Open "SELECT * FROM stats WHERE R_EMAIL = " & REmail & "",my_Conn,1,3

anyone can see something wrong with it ?

thank you from advance, Idan
have a nice week !

[murphyf]

hello everyone ! :)

I have a problam with a asp page I'm making
I'm getting this error:

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'R_EMAIL = [e-mail]'.

this is the code
rs.Open "SELECT * FROM stats WHERE R_EMAIL = " & REmail & "",my_Conn,1,3

anyone can see something wrong with it ?

thank you from advance, Idan
have a nice week !

Looks like a quote problem! Try enclosing REMail in quotes like:

rs.Open "SELECT * FROM stats WHERE R_EMAIL = ' " & REmail & " ' " & my_Conn,1,3

[zivon]

thank you very much :)
I tried to add " not ' as you said... heh...