That did it! I missed the Cast() discussion in the new docs. Good thing we just upgraded a few weeks ago. Or I'd be really mad right now.
Thanks for the tip! -----Original Message----- From: Jon Gunnip [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 13, 2005 4:00 PM To: CF-Talk Subject: 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 additional query of queries to accomplish that. For more info, see http://livedocs.macromedia.com/ coldfusion/7/htmldocs/00001271.htm Jon On 7/13/05, Lincoln Milner <[EMAIL PROTECTED]> wrote: > 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 value, but you apparently don't have that luxury in > QofQ (it doesn't like parentheses in the SQL statements. > > So anyone have any ideas on how I can do this? I'm running out of > options and "no can do" isn't sitting well with the user. > > Thanks! > > Lincoln T. Milner > Senior Applications Programmer/Analyst, Department of Health > Evaluation Sciences > > > Penn State College of Medicine Ph: 717.531.7178 x4521 > 600 Centerview Drive Fax: 717.531.5779 > Suite 2200, MC A210 [EMAIL PROTECTED] > Hershey, PA 17033-0855 > > *****E-Mail Confidentiality Notice***** This message (including any > attachments) contains information intended for a specific > individual(s) and purpose that may be privileged, confidential or > otherwise protected from disclosure pursuant to applicable law. Any > inappropriate use, distribution or copying of the message is strictly > prohibited and may subject you to criminal or civil penalty. If you > have received this transmission in error, please reply to the sender > indicating this error and delete the transmission from your system > immediately. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211821 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
