Getting value from Yes/No

[Emma123]

I have a field in the database called Gas it's a Yes/No field I'm trying to get the value, as far as I remember it returns a -1 for yes, is this true? Here's my code:

If oRS("Gas") = "-1" then
Response.Write("&nbsp &nbsp &nbsp &nbsp Gas:")
Response.Write(" <input type='checkbox' name='fGas' Checked>")
Else
Response.Write("&nbsp &nbsp &nbsp &nbsp Gas:")
Response.Write(" <input type='checkbox' name='fGas'>")
End If

Thanks Emma

[angst]

I assume that your using an access database?


If oRS("Gas") = "-1" then
CheckedValue = "Checked"
Else
CheckedValue = ""
End If
Response.Write("&nbsp &nbsp &nbsp &nbsp Gas:")
Response.Write(" <input type='checkbox' name='fGas' " & CheckedValue & ">")

[Emma123]

Unfortunately the -1 isn't working any other ideas?

[angst]

can you look in the database table and see whaet value is being stored?

[Emma123]

If oRS("Gas").Value = "True" then
CheckedValue = "Checked"
Else
CheckedValue = " "
End If
Response.Write("&nbsp &nbsp &nbsp &nbsp Gas:")
Response.Write(" <input type='checkbox' name='fGas' " & CheckedValue & ">")

:thumbsup:

[demtron]

Whether the DB returns True/False, -1/0 or 1/0 depends on the DB. Assuming that you are using SQL Server or Access, then True/False will work.