Randy ... give the date field in your Access database a default value of now(). Then
anytime a record is created the date field will automatically be populated with the
current time. You just insert userid and password and the timestamp is taken care of.
Good luck,
Bill
-----Original Message-----
From: Adkins, Randy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 10:46 AM
To: CF-Talk
Subject: RE: Insertion of date and time of entry into a database field
Post your Query Code that does the insert
-----Original Message-----
From: Jerre Hale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 10:14 AM
To: CF-Talk
Subject: Insertion of date and time of entry into a database field
I would like to capture the current date and time in an Access database
file when a client logins and downloads software. I can capture the
userid and password with the following code in template1 and this code
in template2 <cfinsert datasource="ssh" tablename="ssh"></cfinsert> . I
tried the create date function as you can see below but it does not
insert the date and time into the database. How can I accomplish the
desired result?
Thanks,
Jerre
Template1
<CFOUTPUT>
<FORM ACTION="template2.cfm" METHOD="Post">
<TABLE width="600">
<TR>
<TD>username:</TD>
<TD><INPUT TYPE="text" NAME="username"></TD>
</TR>
<TR>
<TD>password:</TD>
<TD><INPUT TYPE="password" NAME="password"></TD>
</TR>
<tr>
<TD><INPUT TYPE="#createodbcdate(now())#"
NAME="#createodbcdate(now())#"></TD>
</tr>
</TABLE width="600">
<INPUT TYPE="submit" VALUE="Login">
</FORM>
</CFOUTPUT>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists