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

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:kelvin@sasdesign.co.uk] Sent: 02 May 2001 12:26 To: php recieve Subject: [PHP-WIN] inserting a bit into mssql database 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 nearest to 'bit' from the available choices) but this gave the same sql error... Has anyone managed to do an insert like this? Are there any tricks I should be aware of? TIA, Kelvin. -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net For additional commands, e-mail: php-windows-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net