Hi,
I’m having trouble getting the following query working:
SQL = “SELECT * FROM tblNews WHERE Featured = ‘True’”
I can’t work out why it isnt working. The Featured RS contains true and false values but when I try the above query i get an error?
SQL = “SELECT * FROM tblNews”
Works fine.
Please help, thanks
[COLOR=“Red”]############
worked it out, value didnt need ’ ’
SQL = "SELECT * FROM tblNews WHERE Featured = True "[/COLOR]
