Thanks everyone. turns out that you all were right I simpy had to change datatypes in my database (duh). thanks again, nelson ----Original Message Follows---- From: "t nelson" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Anyone else had this problem before? Date: Tue, 23 Jan 2001 21:45:56 -0000 Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBC374795006CD820F3B8CF1F7A8CB43456; Tue Jan 23 14:00:36 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for <[EMAIL PROTECTED]>; Tue, 23 Jan 2001 16:58:22 -0500 >From [EMAIL PROTECTED] Tue Jan 23 14:01:24 2001 Message-id: <[EMAIL PROTECTED]> Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: <cfquery name="qryName" datasource="MyDatasource"> SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice </cfquery> <cfoutput query="qryName"> <tr> <td>#UsersID#</td> <td>#DollarFormat(UsersTotalPrice)#</td> </tr> </cfoutput> Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
