List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:December 14 2001 7:52pm
Subject:Re: timestamp additional info
View as plain text  
You are inserting the string 'NULL'
Don't include it at all in the insert.

Steve Osborne wrote:

> Timestamp additional info:
> 
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
> VALUES ('$NameID','1','$RegNumc','NULL');
> 
> ProdRegDate is the field that I want to timestamp. (Again, I've tried
> passing '', NULL, and 'NULL').
> 
> Steve Osborne
> Database Programmer
> Chinook Multimedia Inc.
> s.osborne@stripped
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <mysql-thread94073@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 
> 

Thread
timestamp additional infoSteve Osborne14 Dec
  • Re: timestamp additional infoChris Cooper14 Dec
  • Re: timestamp additional infoGerald Clark14 Dec
  • RE: timestamp additional infoMatthew Smith14 Dec
  • Re: timestamp additional info-SOLVEDSteve Osborne14 Dec