At 09:45 PM 1/23/01 +0000, you wrote:
>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?
It seems like your datatype on that field is set to text instead of numeric.
Now announcing my newly updated website
http://www.blivit.org/mr_urc/index.cfm
Resume: http://www.blivit.org/mr_urc/resume.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
