-- On Tue, 17 Apr 2001 07:34:07 paul . wrote: >Hi Guys ! >this is the SQl >---------------- >select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY >'key_issues' DESC > >---------- >"key_issues" field has characters and i want the table to be sorted by the >key_issues alpahebeticaly . >kindly sugest >-paul > >-- > >On Tue, 17 Apr 2001 09:16:27 > Hayes, David wrote: >>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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
