><INPUT TYPE="#createodbcdate(now())#"
NAME="#createodbcdate(now())#"> there is no input type of 5/23/01 etc..
You could use <input type = "hidden" name = "dbcolumn" value =
"#createodbcdate(now())#">
That should do it. just makes sure the column name in your db is the same as
the input name.
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
"Losing - If at first you don't succeed, failure may be your style."
~despair.com
-----Original Message-----
From: Jerre Hale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 7: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
