It looks like that you are adding no days to lastmodified which should
be the same as lastModified. So I would simply insert lastModified. If
it's a datatype mismatch (i.e. you're inserting a string into and
datetime field, or vice versa) then just make sure you're using/not
using single quotes properly.
Hope this helps
Michael Corrigan
Programmer
Endora Digital Solutions
www.endoradigital.com
630/942-5211 x-134
----- Original Message -----
From: Douglas L. Brown
To: CF-Talk
Sent: Friday, November 09, 2001 12:45 PM
Subject: date time problem
I have a form with a hidden field like below, and I keep getting an
error when tring to insert
<cfset date = Now()>
<input type="hidden" NAME="lastModified"
VALUE="#dateFormat(date,
"mm/dd/yyyy")#">
INSERT
#dateAdd( "d", "0", "#lastModified#" )#
<CF_SIGNATURE
NAME="Douglas L. Brown"
EMAIL="[EMAIL PROTECTED]"
PHONE="714.538.6611"
WEB="http://www.carnivorepc.com";>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
