Dude I am going to lose it!!!!! I still get the error after doing it like that
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 14: Incorrect syntax near '11/09/2001'. ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 11:33 AM Subject: Re: date time problem > Have you considered forgoing passing that variable via the form and just > put #dateFormat(date, > "mm/dd/yyyy")# in the insert statement? > > 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
