Re: Date Function - Empty Value

Torsten Roehr wrote:

"Gabe" <ydnahg-news4432@mailblocks.com> wrote in message news:20040520162742.33097.qmail@pb1.pair.com...

Torsten Roehr wrote:

"Gabe" <ydnahg-news4432@mailblocks.com> wrote in message news:20040519211125.84931.qmail@pb1.pair.com...

Torsten Roehr wrote:

"Gabe" <ydnahg-news4432@mailblocks.com> wrote in message news:20040519193101.75891.qmail@pb1.pair.com...

Torsten Roehr wrote:

"Gabe" <ydnahg-news4432@mailblocks.com> wrote in message news:20040519152017.13913.qmail@pb1.pair.com...

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....