Yes/No field in database won't work

[BarrMan]

When i add to my code these lines it doesn't show me any results.
If AirCondition = True Then
SQL = SQL & " AND AirCondition=" & true
Else
SQL = SQL & " AND AirCondition=" & false
End If

Can anyone tell me what is the problem?
How should i write the condition?

Thanks.

[mehere]

since you're saying yes/no field, i'm assuming it's an access database ... try this:

If AirCondition = True Then
SQL = SQL & " AND AirCondition=-1"
Else
SQL = SQL & " AND AirCondition=0"
End If

[BarrMan]

It's not working either :/

[mehere]

show the form field for aircondition. i've tested a query and it works.

[BarrMan]

<TD width="46" align="middle" vAlign="bottom">מרפסת<BR>
<INPUT type="checkbox" value="1" name="balcony"></TD>
<TD width="32" align="middle" vAlign="bottom">חנייה<BR>
<INPUT type="checkbox" value="1" name="parkingSpot"></TD>
<TD width="38" align="middle" vAlign="bottom">מעלית<BR>
<INPUT type="checkbox" value="1" name="elevator"></TD>
<TD width="25" align="middle" vAlign="bottom">מזגן<BR>
<INPUT type="checkbox" value="1" name="aircondition"></TD>

[mehere]

since your checkbox value is a 1 try this:

If AirCondition = 1 Then
SQL = SQL & " AND AirCondition=-1"
Else
SQL = SQL & " AND AirCondition=0"
End If

[oracleguy]

You could also try putting the True/False in the quotes.

e.g.
If AirCondition = True Then
SQL = SQL & " AND AirCondition=true"
Else
SQL = SQL & " AND AirCondition=false"
End If

[BarrMan]

It works now! Thanks! :)