SQL Server Invalid column name 'False' (Classic asp, table edit issue)

bq3bfh9z  于 2023-08-02  发布在  其他
关注(0)|答案(1)|浏览(119)

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)

ruarlubt

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.

相关问题