If the table is creating a new record each time a client logs in simply set
the default value for your date field to Now() - do this within Access it
self in Design mode.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Jerre Hale
Sent: Thursday, 24 May, 2001 12: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