Why cant you pass "UPPER(ColumnName)" depending on user selection
choice "Total" value="Total Desc" choice "Dept" value="Upper(Dept) Desc" if i understood you question correct. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:21 PM To: CF-Talk Subject: ORDER BY and UPPER() I've got a particular query in which I'd like to have the ORDER BY clause dynamic so that I can pass it into my CFC as an argument. Piece of cake except for a minor detail. If the order by column is a string I need to use UPPER() in order for it to be ordered properly...and contrary to that, if I use UPPER() and the column is numeric it gets casted to a string !! Catch 22. There may be a simple solution...anyone have a suggestion? Using Oracle. ThX! Stacy Young System Integration Specialist, Architecture Surefire Commerce http://www.sfcommerce.com <http://www.sfcommerce.com> (p) 514-380-2700 ext: 3234 (f) 514-380-2760 AVIS IMPORTANT: ------------------------------- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: ------------------------------- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
