[thelist] CF Timestamp in a hidden input

jeff jeff at members.evolt.org
Wed Jul 19 23:18:41 CDT 2000


<ml>,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: "Minh Lee Goon" <v7ac at sdsumus.sdstate.edu>
:
: I have been stumped... not the first time. I'd like to pass the
: current date and time in a hidden field to my db.
:
: When I view source, I see:
: <input type="Hidden" name="Timestamp" value="7/19/2000 2:50:16 PM">
:
: But when the form is submitted, only the date portion is passed onto the
: db. Why is that?
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

using access?  double-check the format to make sure it will allow time.

comment out your insert statement and cfoutput #form.timestamp# to see what
the action template sees that value as.  if it's fine there then the insert
statement is to blame.

if you're not formatting that particular value in the insert, then i'd say
with absolute certainty that the culprit is your format on that particular
column not allowing time.

thanks,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org
jeff at members.evolt.org





More information about the thelist mailing list