If you're trying to sort by the 4th item in the columns list, omit the
single quotes around 4.
Given that you are using the * to select all the columns, I suggest
specifying the column name in your order by clause. The next programmer
(maybe you) who looks at the code will be glad you did; also, if the column
order in the table is changed, you'll get unexpected results.
-----Original Message-----
From: paul . [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17, 2001 8:53 AM
To: CF-Talk
Subject: order by not working
Hi guys am using orderby to sort the fields to get the sort order
alphabetically am finding taht is not working please suggest
-----------------------
select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
'4' ASC
----------------
the above is the SQL whats wrong>>
-paul
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
