I'll bet you $10 your correct.
:)
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Cameron Childress" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2001 3:13 PM
Subject: RE: Anyone else had this problem before?
> $5 says your UsersTotalPrice column is a text datatype, and not an
integer.
> Change it to a number (int) datatype in the database, and it will be
ordered
> correctly.
>
> -Cameron
>
> --------------------
> Cameron Childress
> elliptIQ Inc.
> p.770.460.7277.232
> f.770.460.0963
>
> > -----Original Message-----
> > From: t nelson [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 23, 2001 4: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
