I have a problem with ordering the display of my querys I have to keep de fields in my access database as text fields because theses queries are generating my page dynamically. I use <cfquery...> SELECT * FROM TABLE ORDER BY field ASC </cfquery> The value of this field can be numeric and alpha. in the output it apears this way: 1000mhz amd thunderbird 650mhz amd duron 700mhz amd duron 800mhz amd thunderbird note:1000mhz comes before the 650mhz ... thats not right Is there a way to order correctly by keeping thoses strings as text strings Thanks in advance ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
