that is weird.... is that actually how it is entered in the text file? ts '2003-01-07 16:23:09'
including the [']... and is this space at the end in there too? "2003-02-23 18:34:59 ") ----- Original Message ----- From: "Leonardo Crespo - Cftop.COM" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 1:41 PM Subject: Re: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID! > The mega wierd part is that if i run the code: > > <cffile action="read" file="#AbsolutePath#\AnimaisOnline\Chat\UltimaAtualizacao.txt" variable="dtUltimaAtualizacao"> > > <cfif IsDate("#dtUltimaAtualizacao#")> > yes > <cfelse> > no > </cfif> > > #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/yyyy')# > > It returns TRUE (yes) for the cfif condition (it is a DateTime object) but the LSDateFormat does not work (error "{ts '2003-01-07 16:23:09'} " is an invalid date format. ) > > i realy need to add the line: > <cfset dtUltimaAtualizacao = CreateODBCDateTime("#dtUltimaAtualizacao#")> > > befor the #LsDate function... That's wierd and definitly not nice =/. Maybe i should post a bug @ MM page. > > > ----- Original Message ----- > From: Leonardo Crespo - Cftop.COM > To: CF-Talk > Sent: Monday, February 24, 2003 3:31 PM > Subject: Re: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID! > > > I got it working by this code: > > <cffile action="read" file="#AbsolutePath#\AnimaisOnline\Chat\UltimaAtualizacao.txt" variable="dtUltimaAtualizacao"> > > <cfset dtUltimaAtualizacao = CreateODBCDateTime("#dtUltimaAtualizacao#")> > > #LsDateFormat(dtUltimaAtualizacao, 'dd/mm/yyyy')# > > > Note the cfset tag. Looks like CFMX treats the first dtUltimaAtualizacao as a string instead of a DateTime object as CF5 does. > > That's not nice =/. Does anyone have another solution or another tip for that or should i really have to put the cfset tag in all my templates that handle dates? > > Thank you. > (ps, i also have posted this on mm foruns, if i got the solution i will let you guys know) > ----- Original Message ----- > From: Mike Townend > To: CF-Talk > Sent: Monday, February 24, 2003 3:15 PM > Subject: RE: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as INVALID! > > > Drop the quotes... > > #LsDateFormat(DateVar, 'dd/mm/yyyy')# > > Instead of > > #LsDateFormat("DateVar", 'dd/mm/yyyy')# > > HTH > > > > > Mikey > > ========================================= > http://www.phonebin.com > "From Phone to Web in minutes" > > > -----Original Message----- > From: Leonardo Crespo - Cftop.COM [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 18:05 > To: CF-Talk > Subject: URGENT, cfmx interprets MYSQL date (yyyy-mm-dd hh:mm:ss) as > INVALID! > > > I'm evaluating cfmx on j2ee. I use mysql as database and all my date are > stored in mysql default format, witch is "yyyy-mm-dd hh:mm:ss". I'm using > the Portugues(Brazilian) locale. > > As you know, MYSQL stores DateTime objects in the format "YYYY-MM-DD > HH:MM:SS". > > When i try to run the code: > > <cfquery name=bla....> > Select DateField from .... > </cfquery> > > <cfset DateVar = bla.DateField> (suppose DateVar has the value "2003-02-23 > 18:34:59 ") #LsDateFormat("DateVar", 'dd/mm/yyyy')# > > it throws an error saying 2003-02-23 18:34:59 is an INVALID date format. > > the same error is returned if i use the CREATEODBCDateTime function, as > follow #LsDateFormat("CREATEODBCDateTime(Now())", 'dd/mm/yyyy')# throwns > this error: > > "{ts '2003-01-07 16:23:09'} " is an invalid date format. > > > ALSO, > > <cfset temp = ParseDateTime("{ts '2003-23-02 18:34:59'}")> > <cfoutput>#LsDateFormat(temp, 'dd/mm/yyyy')#</cfoutput> > > outputs this: > {ts '2003-02-24 12:52:28'} 02/11/2004 > > when the correct date is > 24/02/2003 (dd/mm/yyyy format). > > > I cant understand why the mysql default date format is not valid anymore. I > realy dont want to change all my date fields in my database, or change all > my code that use dates (witch are quite alot). Does anyone knows why CFMX > does that and does anyone knows a solution? > > Tks alot > > Leonardo > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4