Hi,
The behaviour of the ValueList function seems to have changed between CF5
and CFMX - it returns integers as one-decimal place floating points (i.e.
5.0 instead of 5).
<!--- TEST SCRIPT --->
<cfscript>
qTest = QueryNew("idnum,idtext");
for(i=1; i LTE 5; i=i+1) {
newRow = QueryAddRow(qTest);
tmp = QuerySetCell(qTest,"idnum", i);
tmp = QuerySetCell(qTest,"idtext", "#i#");
}
</cfscript>
<cfdump var="#qTest#">
<cfoutput>
ValueList(qTest.idnum) = #ValueList(qTest.idnum)# <br />
ValueList(qTest.idtext) = #ValueList(qTest.idtext)#
</cfoutput>
<!--- END TEST SCRIPT --->
On CF5 is get:
ValueList(qTest.idnum) = 1,2,3,4,5
ValueList(qTest.idtext) = 1,2,3,4,5
But Standard 6,1,0,83762 returns:
ValueList(qTest.idnum) = 1,2.0,3.0,4.0,5.0
ValueList(qTest.idtext) = 1,2.0,3.0,4.0,5.0
Has anyone else noticed this, got a work around?
cheers
David
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
