ASP/SQL Bit Datatype display issue
Posted on 2004-10-15
I have a table, SQL Svr 2000. That table has a column, datatype = bit. I am able to both update and insert into this table with 1's and 0's, no problem.
If I run a select against the table (as in 'select * from table') and output the value of that column, the following occurs:
If the value in the column is 1, I'm able to display 'True' like so:
If the value in the column is 0, that same response.write elicits the following response:
Microsoft VBScript runtime (0x800A000D)
Why doesn't the response.write work with a 'false' return?
PLEASE HELP ASAP!!