Thanks, The query is generated from form fields, so I ended up having to use the list approach (had tried it before, but I must have been tired - it was easy enough this morning).
I just made a modification of Ray Camden's QuerySort UDF so that it manually creates a new recordset it the QofQ method doesn't work. Thanks for your help! Steve > 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243926 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
