I have installed a table editor, (Universal Table Editor) which is coded by classic asp. However I am not able to edit or delete a column. I recieve the error
Invalid column name 'False'
The reasons seems to be bit field of SQL Server, it displays true/false but it is not a boolean field.
So is there a way to solve it in SQL Server?, or is there an easy solution on ASP code? (I saw a solution for adding a parameter booleanasbit = true, but couldn't implement it)
1条答案
按热度按时间ruarlubt1#
When setting a BIT field, use 0 for 'False' and 1 for 'True'.
Note that there are no quotes around the 0 or 1.