I don't know where you're query is coming from or what it looks like, BUT generically speaking, one approach I can think of to get around the issue would be to add another field to the query result that you CAN use to sort on. For instance, within the sql select statement, if the field you want to sort by is text (containing numeric values), then add another field that converts the value to numeric. For instance, instead of "select myTextVal from bla", you would use "select myTextVal, cast(myTextVal as int) as sortby from bla", and then within CF sort by the 'sortby' column.
The other thing you could do (though i would definately try to find another way) is to populate a new query by accessing the original one via a loop through a sorted list of values from the field you want to sort by. If it sounds complex, it is a little, which is why i would definately take my thinking back to the sql origins and try to rectify the situation there. Th > I am running into the "Unsupported Numeric type conversion in Query of > Queries" error. > > I tried Jose Alfonse mentioned on this thread: > http://www.houseoffusion.com/cf_lists/index. > cfm?method=messages&threadid=17099&forumid=4 > > It didn't help. > > I have been playing with other ways to sort a query without using QofQ, > but I haven't had any luck. > > I was hoping someone smarter than I might know the answer? > > Anyone? > > Bueller? > > Thanks, > > Steve Bryant > 918-449-9440 > Bryant Web Consulting LLC > http://www.BryantWebConsulting.com/ > http://steve.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
