First, I think this message belongs on one of the CF Technical lists. I
don't think CF Community is a tech list.
But here goes...
If you are using SQL :
Make a field in the DB called whatever you like. I use TimeStamp. Give
this field a default value of GetDate().
This will automatically enter the date and time that each row was added to
the db. You never have to worry about this in your insert statements.
With Access :
Do the same. I think that Access uses Now() rather than GetDate().
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, August 14, 2000 9:45 AM
To: [EMAIL PROTECTED]
Subject: CF-Community V1 #63
CF-Community Mon, 14 Aug 2000 Volume 1 : Number
63
In this issue:
RE: hidden time date stamps
----------------------------------------------------------------------
Date: Mon, 14 Aug 2000 09:25:00 -0400
From: "Stewart, Mark" <[EMAIL PROTECTED]>
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
Subject: RE: hidden time date stamps
Message-ID:
<[EMAIL PROTECTED]>
Try using the CreateODBCDateTime(date) function
-----Original Message-----
From: Luke Kearney [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 13, 2000 10:13 PM
To: 'Cold Fusion Community'
Subject: hidden time date stamps
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00595.1A94F6D0
Content-Type: text/plain;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable
Can anyone give me some idea how to insert records to a DB and give the =
time
and date stamp of the server not a client side input ? I don't want =
users to
input time and date on their updates.
=20
Thanks
=20
Luke Kearney
=83=8B=81[=83N =83J=81[=83j=81[
East West Technology Service Inc.
Tel (03) 3222 7459
Fax (03) 3222 5591
------_=_NextPart_001_01C00595.1A94F6D0
Content-Type: text/html;
charset="shift_jis"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dshift_jis">
<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3D"MS Gothic"><SPAN class=3D775121202-14082000>Can =
anyone give me=20
some idea how to insert records to a DB and give the time and date =
stamp of the=20
server not a client side input ? I don't want users to input time and =
date on=20
their updates.</SPAN></FONT></DIV>
<DIV><FONT face=3D"MS Gothic"><SPAN=20
class=3D775121202-14082000></SPAN></FONT> </DIV>
<DIV><FONT face=3D"MS Gothic"><SPAN=20
class=3D775121202-14082000>Thanks</SPAN></FONT></DIV>
<DIV><FONT face=3D"MS Gothic"><SPAN=20
class=3D775121202-14082000></SPAN></FONT> </DIV>
<DIV><FONT face=3D"MS Gothic"><SPAN class=3D775121202-14082000>
<DIV><FONT face=3DArial size=3D2>Luke Kearney</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>=83=8B=81[=83N =
=83J=81[=83j=81[</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>East West Technology Service =
Inc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Tel (03) 3222 7459</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Fax (03) 3222=20
5591</FONT></DIV></SPAN></FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C00595.1A94F6D0--
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------
End of CF-Community V1 #63
**************************
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community
or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
