Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Torsten Roehr wrote:
"Gabe" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Environment: PHP 4.3.6 Access DB W2K IIS 5
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 ( "" )
or
NULL and I always get a datatype mismatch sql error. So then I just tried submitting a date that will never be used ( e.g. 1/1/1111 ).
That
works, but then when I try to read the date out of the field in the
DB
and format it using the date() function in PHP it doesn't display anything (which is fine with me). I read up on the date function on
the
PHP website and valid dates are limited from 01-01-1970 to
19-01-2038
on
windows machines. So that explains why the function returns
nothing.
So, I guess my question is this: Is what I'm doing technically ok (using a date that's not in the valid range)? Or does anyone know
of
an
empty date value that I can submit to the DB?
Thanks!
NULL should work if you have allowed it for the column when creating
the
table. Can you post your table structure?
Regards, Torsten
Well, I would, but I can't seem to figure out how to export just the structure out of access. Wouldn't NULL be allowed by default?
This command should show you the table structure: SHOW CREATE TABLE tablename
Please post the output.
regards, Torsten
Sorry Torsten, but you'll have to forgive my lack of understanding. Where should I put that command in?
Thanks for you patience.
In the mysql command line, if possible or if you're using phpMyAdmin.
Should
also work with mysql_query() in a php script and echoing out the result.
Do
you know how to do this?
Regards, Torsten
I'm using Microsoft Access for my database not MySQL. Does that change what I need to do?
I'm not familiar with Access but should have an option or specific view to show you the table structure. Look at the Access program help for something like that.
Regards, Torsten
After looking carefully through the table structure, it does allow NULL values. So maybe I'm not passing it correctly to the variables in the SQL. I thought I was....
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
