Whats wrong with this select statement

[dawilis]

I keep getting this error Syntax error in WHERE clause.

RSvoucher.Source = "SELECT * FROM voucher WHERE group ='" & Request.QueryString("cat") & "'"

[allida77]

"Group" is probaly a reserved word or Request.QueryString("cat") may be returning a "" value.

[Roy Sinclair]

Originally posted by allida77
"Group" is probaly a reserved word or Request.QueryString("cat") may be returning a "" value.

Group definitely is a reserved word, it's used in "Group by" clauses.

This will work:

RSvoucher.Source = "SELECT * FROM voucher WHERE [group] ='" & Request.QueryString("cat") & "'"

[dawilis]

the smallest things - the biggest pains

[whammy]

I assume it's working for you now?

[dawilis]

ta