> $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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
