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
What type of variable do you have UsersTotalPrice set to in the db? (e.g.
nvarchar, money, etc.)
--=@ greg @=--
- Original Message -
From: "t nelson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, January 23, 2001 4:45 PM
Subject: Anyone else had this problem before?
cfquery name="qryName" datasource="MyDatasource"
SELECT UsersID, UsersTotalPrice
FROM TableName
WHERE UsersID = (#UsersID#)
ORDER BY UsersTotalPrice
/cfquery
Change the query to:
cfquery name="qryName" datasource="MyDatasource"
SELECT UsersID, UsersTotalPrice
FROM
$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:
try this
cfquery name="qryName" datasource="MyDatasource"
SELECT UsersID, UsersTotalPrice
FROM TableName
WHERE UsersID = (#UsersID#)
ORDER BY cast(UsersTotalPrice as decimal)
/cfquery
- Original Message -
From: "t nelson" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL
At 09:45 PM 1/23/01 +, 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
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
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:
Don't store numeric data in a text field. That should fix your problem.
R
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
Do you mean in the source or the displayed HTML? I'm not sure of the
question.
If you mean the source, look at your cfoutput statement as being a loop.
Every time your code goes through the loop, it executes the code as if there
were multiple lines. The line that contains the CFOUTPUT doesn't
Yes, we have had that problem. Look for content that is being output
OUTSIDE of the tds, but inside the trs. All that content, like
non-breaking spaces, will appear in front of the table, effectively pusshing
it down. It won't show up in 'view source' as in front of the table, but
that is how
11 matches
Mail list logo