Use CFQUERYPARAM and your problems will vanish. MySQL is picky about using strings as date literals, so it's getting screwed up. CF formats the default MySQL date value (0000-00-00 00:00:00) as 11/30/02 for some reason. If you look in the DB, it'll be all zeros though.
cheers, barneyb On Mon, 20 Dec 2004 12:44:37 -0700, Jason Smith <[EMAIL PROTECTED]> wrote: > After switching a cold fusion application from an access database to mysql > I have some strange problems that I am not 100% sure on. Image issues no > thumbnails showing up I assume it's related to the original storage > location of the images. However one issue I can't seem to correct and has > me stumped there is a time/date stamp that is recorded anytime a bid for an > item is submitted. In access this was working fine no issues and no > problems what so ever. Under mysql this snip of code. > > TIME: #TimeFormat(now(), 'HH:MM:SS')#<br> > DATE: #DateFormat(now(), 'MM/DD/YYYY')#<br> > </em> > <br> > <br> > <span style="size: 9px;">Please do not respond to this email.</span> > </span> > </cfmail> > > <cfset theTime = TimeFormat(now(), "HH:MM:SS")> > <cfset theDate = DateFormat(now(), "MM/DD/YYYY")> > <cfquery name="createItemNotes" datasource="#DS#"> > INSERT INTO tblItemNotes > (itemID, > itemStatusID, > itemListPrice, > locationID, > itemNotes, > agent, > dateEntered, > timeEntered) > VALUES > (#getItemDetail.itemID#, > #getItemDetail.itemStatusID#, > #getItemDetail.itemListPrice#, > #getItemDetail.locationID#, > 'OFFER SUBMITTED<br> > BY: #form.OfferName#<br> > CONTACT INFO: #form.offercontact#<br> > AMOUNT: $#form.offeramount#', > 'WEB USER', > '#theDate#', > '#theTime#') > > Now to test this problem I have submitted offers on items today and then > run a report that checks for current open bids and the bids I placed today > are coming up with a November 30th 2002 date stamp this has left me > completely boggled and I don't understand what could be causing this issue. > I have verified all time/dates on all servers that are used for this > application/database are reporting correct time and date. > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
