Getting Certain Information

[WOLFcfm]

Hi, I have a question that I'm hoping someone could help me with. I'm use
coldfusion and microsoft access. I have a database and I'm trying to access
only a certain piece of information from the database, for example, I want to
get the names of the only the people that signed a form so in the database I
have a column called signed and in microsoft access the data type is
yes/no...so I tried selecting the names of only the people who signed the form
and my code looks like this:


<cfquery name="signedname" datasource="psharp">
select name
from pforms
where signed = 'yes'


unfortunately this code doesn't work, does anyone know what is wrong with it?
I'm not sure if 'yes' is the correct term to use for something selected in
microsoft access database.

Any type of help will be much appreciated, thank you.

[BKBK]

Use True or -1 in place of ' yes ', thus

<cfquery name="signedname" datasource="psharp">
select name
from pforms
where signed = True
</cfquery>

[WOLFcfm]

I tried all those before:
yes, true, on, 1
and they all didn't work but one thing I didn't try before which I noticed in
your code is to leave out the single quotes, I just tried them with no quotes
and they worked, thanks a lot for your help, I really appreciate it!

[BKBK]

Right.