I just add Date()+Time() as the default value in the table - gets the
database to do the work, not your code. Every time a new row is added its
date and time stamped.
********************************
Kevin Parker
Service and Communication
WorkCover Corporation
[EMAIL PROTECTED]
ph: +61 8 82332548
fax: +61 8 82332000
********************************
-----Original Message-----
From: Elaine L [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 29 June 2000 12:38:PM
To: [EMAIL PROTECTED]
Subject: create a date for table
Hi,
Hope I am not repeating an old question.
I need to create a field in a table (Microsoft SQL) called DateCreated. The
value shd be automatically created and passed as a hidden field every time
the submit page is actioned.
What is the best way of doing this?
Ellie
Send FREE Greetings for Father's Day--or any day!
Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
****************************************************************************
This e-mail is intended for the use of the addressee only. It may contain
information that is protected by legislated confidentiality and/or is
legally privileged. If you are not the intended recipient you are prohibited
from disseminating, distributing or copying this e-mail. Any opinion
expressed in this e-mail may not necessarily be that of the WorkCover
Corporation of South Australia. Although precautions have been taken, the
sender cannot warrant that this e-mail or any files transmitted with it are
free of viruses or any other defect.
If you have received this e-mail in error, please notify the sender
immediately by return e-mail and destroy the original e-mail and any copies.
****************************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.