Hi All-
I am facing a strange error with query of query as follows:
I am first constructing a query using 'QueryNew' as
<Cfset newQuery = QueryNew("id, status, label, name")>
the status column is a numeric column in database with values of 1,2,3,4,5,6
and NULL
When I do a query of query as below, I get an error 'The value '' cannot be
converted to a number'. This does not happen always:
<cfquery dbtype="query" name="qoq">
select * from newQuery
</cfquery>
ANy thoughts on why this could be happening?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351284
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
