FieroFixer
Programmer
I have an access database where I've used a field with a True/False format. I can't seem to use this field in a WHERE sql select statement without getting "unspecified error" I've been able to get the results of this field by just selecting it, but no luck in a WHERE clause. In addition I've also built the query in the access query design wizard and it worked fine within access, but as soon as I brought it into my ASP page it didn't work.
here's my statement:
SELECT projects.projtitle, projects.start, projects.finish, projects.picture, projects.description FROM projects WHERE projects.current = True;
here's my statement:
SELECT projects.projtitle, projects.start, projects.finish, projects.picture, projects.description FROM projects WHERE projects.current = True;