Invalid column name "False" (classic asp, table editing problem)

I installed the Universal Table Editor, which is encoded with classic asp. However, I cannot edit or delete a column. I get an error

Invalid column name 'False'

The reasons are apparently the SQL Server bit field, it displays true / false, but it is not a logical field.

So, is there a way to solve this problem in SQL Server ?, or is there a simple solution for ASP code? (I saw a solution to add the booleanasbit = true parameter, but could not implement it)

+6
source share
1 answer

When setting the BIT field, use 0 for "False" and 1 for "True".

Note that there are no quotes around 0 or 1.

+8
source

Source: https://habr.com/ru/post/912039/


All Articles