Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting WHERE field = True ??????

Status
Not open for further replies.

FieroFixer

Programmer
Nov 26, 2001
6
US
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;

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top