Ryan Kime wrote: > OK, I really need some help on this one. > > I have a query I create on the fly using QueryNew/QueryAddRow/QuerySetCell. > Everything is fine until I try to use a cfquery with dbtype="Query" on the > created query to order the results - it throws a QofQ runtime error. If I > comment out the cfquery and call the original query created with QueryNew, > it runs fine and spits out the data (albeit unordered). > > I could really use some insight on this. I need to get that query in a > particular ordered format and time is breathing down my neck. > > > Here's a code snippet, it dies right on the <cfquery> tag saying > "Unsupported Numeric type conversion"....yet it worked fine in CF5:
when using querysetcell you need to explictly force the datatype with int() etc, there was a thread on this late last week z ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm