Update query results

the following code snippet behaves differently on cf10 versus previous versions.

 

<cfoutput>coldfusion version #server.coldfusion.productversion# <br></cfoutput>

<cfquery name="rs" datasource="myds">

select currdumpdate miscvalues id = 1

</cfquery>

<cfoutput>#rs.currdumpdate# <br></cfoutput>

<cfset rs.currdumpdate = ucase(dateformat(rs.currdumpdate,"yyyy-mmm-dd"))>

<cfoutput>#rs.currdumpdate# <br></cfoutput>

 

results shown follows:

 

coldfusion version 9,0,1,274733
2013-04-17 00:00:00.0
2013-apr-17

 

coldfusion version 10,0,5,283319
2013-04-17 00:00:00.0
2013-04-17 00:00:00.0

 

whether best practice or isn’t issue issue unexpected behavior change in cf10.  of course can adjust code , change how code in future added work checking existing applications isn't appreciated.  bug or intentional change make weary else might lurking in cf10 might break our apps.

 

database oracle, use , changing databases account cf10 behavior changes isn't practical.

 

any way restore previous behavior of earlier cf versions cf10?

i've found higher cf version, less tolerent of less perfect code.  find annoying.  opinion problems code should have been apparent when wrote it.  have done it.

More discussions in ColdFusion

adobe