[thelist] Inserting dates and booleans into MS Access

[Tim Burgan]

Jay Blanchard wrote:

> Now, what about the checkboxes?


Yeah.. I got a little over-excited!

Still got these to worry about.


I tried converting the boolean values of the variables I'm using to 
strings, so that instead of the SQL looking like:

   INSERT INTO tblStudents
    (name, username, password, permissions, website, displayUser)
   VALUES ('jon','dfg','gdfd','20-Jan-05','student','0','1');

it looks like:

   INSERT INTO tblStudents
    (name, username, password, permissions, website, displayUser)
   VALUES ('jon','dfg','gdfd','student','False','True');

This didn't work either. The format setting in Access is set to 
True/False, not Yes/No or On/Off.


Any suggestions?. it seems that PHP must ALWAYS contain the single 
quotes with each value to obtain correct syntax.


Thanks again
Tim