Anyone else had this problem before?

[t nelson]

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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists