I tried it with just #lastModified# and get incorrect syntax near '11' and ' #lastModified# ' gives me incorrect syntax near '11/09/2001' I'm getting major frustrated......
Doug ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 11:05 AM Subject: Re: date time problem > 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"> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists