Re: Date Function - Empty Value

"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