Use the optional second argument to QueryNew to explicitly define the data
types for each column.
-Christopher
> 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:351285
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
