Same thing, right truncation. Funny thing is I have form I use for updating the same table, and everything works great. The code is identical except for it's an update and not a insert. hmmmmmmmmmmmmmm
Doug ----- Original Message ----- From: "C. Hatton Humphrey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 11:55 AM Subject: RE: date time problem > 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
