If you created the query with querynew(), you aren't able to do any of this in 6.1. That's one of the reasons I'm creating the UDF. Also, the sorting is corrected in my technique.
On 7/25/05, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > What I have done with these wierd QofQ issues is to wrap TO_CHAR() > around my attributes in the original SQL. (using Oracle here) The > JDBC drivers then handle it all as text, but CF numerics still work on > the attributes, som emajic casting in CF, eh? Sorting maybe an issue, > hasn't bothered me yet. This is very useful when working with date > attributes and nulls, like when you try to union two Qs with QofQ. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212701 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
