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