I've been reading about CFQUERYPARAM to see where this needs to be inserted to fix my date problem but I am new to CF and I'm most likely overlooking a simple solution can anyone pointme in the right direction or a site that has some better tutorial type information about storing date/time stamps correctly?
At 12:53 PM 12/20/2004, you wrote: >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 - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188322 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
