I do not think it has anything to do with the database or ODBC, because you can
replicate the problem by building a query in ColdFusion. Check out this code:
<cfscript>
q = QueryNew("c1");
iRow = QueryAddRow(q);
QuerySetCell(q,"c1",Val("5"),iRow);
</cfscript>
<cfloop query="q">
<cfoutput>#isNumeric(c1)#</cfoutput><br>
<cfparam name="c1" type="numeric" default="-1">
</cfloop>
The mere fact that the isNumeric function returns true but then the <cfparam>
tag does not recognize the very same variable as numeric seems to be a bug.
You would think the two operations would share the same logic. Has anyone
reported this to Adobe? Does anyone know if this problem exists in newer
versions of ColdFusion?
Nate
>Some more information about this problem. The numeric data is coming from
>an MS Access (yeah, I know) column of type "Number:Long Integer."
>
>When I hard code in a number instead of pulling it from the database, the
>problem goes away. If I change the code so that the number is retrieved
>from a struct, 1D array, or 2D array, the problem does not occur.
>
>So I'm thinking the problem may have to do with either the database or ODBC.
>Any thoughts?
>
>Again, thanks in advance.
>
>--
>Mosh Teitelbaum
>evoch, LLC
>Tel: (301) 942-5378
>Fax: (301) 933-3651
>Email: [EMAIL PROTECTED]
>WWW: http://www.evoch.com/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289927
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
