#x27;$
> state2','$agency','$bmothername','$mage','$monthmdob','$daymdob','$yearm
> dob','$bfathername','$fage','$monthfdob','$dayfdob','$yearfdob','$commen
> ts'
27;$fage','$monthfdob','$dayfdob','$yearfdob','$commen
ts','$signupdate')";
$signupdate is the one that I wanted to be the timestamp obviously!!!
LOL
Thanks in advance for any help someone can give me
-Original Message-
From: Rober
At 12:18 -0800 2001/12/14, 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 t
Thanks, it is working perfectly as described
Steve
> Don't reference the timestamp column at all in your INSERT (or future
> UPDATE) statements and the timestamp should update just fine on its own.
>
> i.e.
> INSERT INTO Owners (NameID,ProductsKey,RegNum)
> VALUES ('$NameID','1','$RegNum
-+---++
|1 | World | 20011214194555 |
+--+---++
1 row in set (0.00 sec)
mysql>
Regards
M
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: 14 December 2001 20:16
To: MySQL (E-mail)
Subject: t
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
default for a timestamp column - it is always
NULL (which displays as '00').
HTH,
--
coop
On Fri, 2001-12-14 at 15:16, Steve Osborne wrote:
>
> Timestamp additional info:
>
> INSERT INTO Owners (NameID,ProductsKey,RegNum,ProdRegDate)
> VALUES ('$NameID&#
mysql (filter)
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 t
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').
