You are here: Re: Inserting NULL into a smalldatetime « PHP SQL « IT news, forums, messages
Re: Inserting NULL into a smalldatetime

Posted by Techie123 on 06/29/06 20:17

OKAY, Here's the real story...
I tried the $variable=NULL, not $variable='NULL' and it worked, kind
of. Now I have 1/1/1900 in Enterprise Manager. When I print that out it
comes to 1900-01-01 00:00:00.

So, what's the answer here. That I do not know. I could just change all
my logic to look for that time stamp, but it seems stupid that I can
enter a NULL in manually, but there isn't some SQL command for it.

Techie123 wrote:
> Perhaps I spoke too soon. I need to figure out what to do if I want to
> have a function to erase a date previously entered.
>
>
> Techie123 wrote:
> > IT'S SO EASY I FEEL DUMB. Just completely omit INSERTing a NULL into it
> > all together and it automatically inserts one for you!!!!! This is a
> > really good group! I got my answer and I didn't even have to have a
> > reply! ;-)
> >
> > P.S. - I tried the NULL instead of 'NULL' and it did the same thing.
> > Leaving it out worked for me.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация