How are you setting the value on the query when the value is null from the
database? I think you may need to use javacast("NULL",0) if you keep the column
as a numeric type.
-Quan
> 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:351319
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
