[thelist] getting data from 'bit' datatype in asp

[Michael Robertson]

I have some fields stored as "bit" datatypes in SQL Server that I need to
connect to. What is the right way. For example I write data to the field no
problem with something like:

objRs.fields("active").value= 1

but if i want to get the data like this:

if objRs.fields("active").value= 1 then   OR
if objRs.fields("active").value= true then

it doesn't work. Is there something I'm missing.

Also if I want a form element value to be put in one of these fields, what
is the right value setting?

<input type="radio" name="myButton" value="true">
<input type="radio" name="myButton" value="1">
<input type="radio" name="myButton" value="???">

Thanks