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 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
