Hey all, got a brain buster for you:
I have a query object "result" that I'm building out in a function. I've
defined all my query column datatypes.
The problem is that for one column, the datatype is varchar, but the
data in this particular instance is all numeric, save 1 row that is an
empty string. Note: The data being all numeric is coincidental. The
field is user-defined data, which is why it was declared a varchar
field.
When I do a query of queries on "result", I get an error thrown saying
"The value '' cannot be converted to a number". Double checked myself by
dumping getMetaData(result), and sure enough, the column data type is
varchar.
Even doing
<cfquery name="result" dbtype="query">
SELECT *
FROM result
</cfquery>
Throws the same error!
I know ColdFusion is seeing all the numeric values, and casting it as a
numeric variable behind the scenes, but this is NOT what I want it to
do.
How can I get the blasted QoQ to work without throwing the error?!?
James Davis
Software Engineer
Kaleida Systems, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317303
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
