Re: Sorting QofQ in ORDER BY

If I get enough time over the next couple of days I'll be able to finish the QueryCast() UDF I'm writing to enable the same thing in CFMX prior to 7. Let me know if you need it and I'll put in the effort to get it done. On 7/14/05, Jon Gunnip [EMAIL PROTECTED] wrote: If you are on CF7, then you

Sorting QofQ in ORDER BY

I've got a QofQ that I want to order on a character field. Only the field contains only numbers (don't ask), and the user wants it sorted as if they were numbers (1, 2, 3, ...) not strings (1, 10, 11, 2, 3, ...). Simple enough in database (Oracle in this case) since you can just TO_NUMBER() the

Re: Sorting QofQ in ORDER BY

If you are on CF7, then you can use Cast() in the query of queries to convert a column to a specific type. For example, cfquery SELECT Cast(StringColumn as Integer) as NumberColumn FROM MyQuery /cfquery You might not be able to due the order by in the same statement. You might need an

RE: Sorting QofQ in ORDER BY - RESOLVED

: Sorting QofQ in ORDER BY If you are on CF7, then you can use Cast() in the query of queries to convert a column to a specific type. For example, cfquery SELECT Cast(StringColumn as Integer) as NumberColumn FROM MyQuery /cfquery You might not be able to due the order by in the same statement