Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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)

like image 509
HOY Avatar asked Mar 30 '12 10:03

HOY


1 Answers

When setting a BIT field, use 0 for 'False' and 1 for 'True'.

Note that there are no quotes around the 0 or 1.

like image 92
nealkernohan Avatar answered Oct 31 '22 16:10

nealkernohan