Mark Pecaut wrote:
On Thu, May 20, 2004 at 12:28:00PM -0400, Gabe wrote:
I'm trying to store a date in a date/time field using the short date
format ( m/d/yyyy ). For some reason it won't let me post an empty
value to that field in the DB. I've tried using empty quotes ( "" )
I'm using Microsoft Access for my database not MySQL. Does that change
what I need to do?
Access delimits dates with '#' hash marks. Try something like:
UPDATE tablename SET date_field=#9/30/2003# WHERE foo='bar';
or
UPDATE tablename SET date_field=NULL WHERE foo='bar';
if you want to make that field null. If it complains when you try to
set it NULL and you want it to be null, put 'No' for 'Required' for that
field in Design View.
-Mark
I'll give those a try. Thanks for the tips.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
