RE: [PHP] SQL - INSERT INTO booleans
| From: | Mikey | Date: | Wed, 19 Jan 2005 22:47:51 +0000 |
| Subject: | RE: [PHP] SQL - INSERT INTO booleans | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-206783@lists.php.net to get a copy of this message | ||
> $db_sql = "INSERT INTO tblStudents (name, username, password, expiry,
> permissions, website, displayUser) VALUES ('Joe',
>
> 'joejoe','pw4joe','20-Jan-05','staff','true','false');";
>
> In using MS Access via COM, the data types for each column (in order)
> is: string, string, string, date, string, boolean, boolean.
>
> I am continually getting a data type mismatch error (relating to the
> boolean columns) when trying to execute this code.
>
> I've tried removing the single quotes, but that returns a syntax error.
Have you tried 1 for true and 0 for false?
Just a guess...
Mikey