Erm, have you tried using #CreateODBCDate(dateformat)#? C. Hatton Humphrey, Developer Fisher, Towne & Associates 716-839-2141 x336 [EMAIL PROTECTED]
> -----Original Message----- > From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 09, 2001 2:53 PM > To: CF-Talk > Subject: Re: date time problem > > > Here is the whole insert query, I tried it with and without the single > quotes. > > > <CFSET date = Now()> > <CFQUERY DATASOURCE="#application.dsn#" NAME="new_cust_insert"> > INSERT INTO customer > VALUES ( '#custNum#', > '#f_name#', > '#l_name#', > '#address_1#', > '#address_2#', > '#city#', > '#state#', > '#zip_code#', > '#phone_1#', > #ext_1#, > '#phone_2#', > #ext_2# > '#dateFormat(date, "mm/dd/yyyy")#' ) > </CFQUERY> > > > > > > ----- 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
