Nathan,
The reason this fails is that C1 is a complex value. You are trying to set
the entire column of a query as a numeric value. When you use isnumeric(c1)
in the loop C1 in this case refers to the value that is contained in the
column for that row. Using the cfparam you would need to specify the row of
C1, for example:
<cfoutput query="q" >
<cfoutput>#isNumeric(c1)#</cfoutput><br>
<cfparam name="c1[currentrow]" type="numeric" default="-1" >
</cfoutput>
This works without error. If you try and set the currentrow out of bounds
<cfparam name="c1[0]" type="numeric" default="-1" > you will receive the
same error.
--
Gary Gilbert
http://www.garyrgilbert.com/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion is delivering applications solutions at at top companies
around the world in government. Find out how and where now
http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289952
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
