RE: [PHP-WIN] inserting a bit into mssql database

2001-05-02 Thread Kelvin Luck
sorry, my mistake. the problem was elsewhere in my sql and nothing to with inserting a "bit"... I've figured it out now, Cheers, Kelvin. -Original Message- From: Kelvin Luck [mailto:[EMAIL PROTECTED]] Sent: 02 May 2001 12:26 To: php recieve Subject: [PHP-WIN] inserting a

[PHP-WIN] inserting a bit into mssql database

2001-05-02 Thread Kelvin Luck
Hi, I am trying to insert into a column in a mssql 7 database with a datatype of "bit"... I have tried to insert 0, 1, '0', '1' but get an sql error every time ("Incorrect syntax near ...")... I also tried first using settype and setting my variables type to boolean (which seems to me to be the ne