Dan,
Yes it works on the datetime and getdate() function.
Thanks to others who offered suggestion of CF coding which I will try at another time.
Ellie
On Thu, 29 Jun 2000 01:44:16
Dan Blickensderfer wrote:
>Ellie,
>
>In SQL use the getdate() function.
>
>Dan
>
>
>----- Original Message -----
>From: "Elaine L" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, June 29, 2000 1:41 AM
>Subject: RE: create a date for table
>
>
>> 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.
>
>------------------------------------------------------------------------------
>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.
