Hi,
I tried to set up the field in Microsoft SQL 7
the datatype as dateime (or shd it be timestamp?)
and the default value to Date()+Time() but an
error msg came up:
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]'date' is not a recognized
function name.
What's missing
Thanks in advance
Ellie
On Thu, 29 Jun 2000 12:43:18
Parker, Kevin wrote:
>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.
>
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.
