Looks fine to me this could be shortend <cfoutput query="getKeywords" group="short_desc"> #short_desc#<br /><br /> </cfoutput>
Paul. -----Original Message----- From: John Barrett [mailto:[email protected]] Sent: Sunday, 11 January 2009 10:27 PM To: cf-newbie Subject: cfquery & alphabetical order Hi, I am wondering what the best way to have a cfquery to become in a alphabetical order. What are the best practice, I don't think that I am using it here. In the SLECT LEFT(column name,number of caharacters) is there a limit on the number of characters? I would prefer to just get the entire cell. Maybe I should not complain, as the code works fine, and does what I what, displays the listing in alphabetical order, but I am trying to learn the best way to do this. Thanks so much, John here is my code: <cfquery name="getKeywords" datasource="my_datsource"> SELECT LEFT(short_desc,100) AS short_desc FROM senior_links ORDER BY short_desc </cfquery> <cfoutput query="getKeywords" group="short_desc"> <cfoutput>#short_desc#<br> </cfoutput><br /> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4282 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
