Re: [PHP] SQL - INSERT INTO booleans

Tim Burgan wrote: > 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. I've forgotten the rules for MS-Access, but... Perhaps try 1 and 0 as your bool

RE: [PHP] SQL - INSERT INTO booleans

> $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, strin

[PHP] SQL - INSERT INTO booleans

Hello, I'm trying to insert a new row using the following SQL: $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 colu