Is your datatype for the table field "UsersTotalPrice" small money or
money?
-----Original Message-----
From: t nelson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 23, 2001 3:46 PM
To: CF-Talk
Subject: Anyone else had this problem before?
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
