Hi Paul, Thanks so much,and I am happy that I am finally starting to get CF`-`
John On Jan 11, 2009, at 6:01 PM, Paul Kukiel wrote: > 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:4283 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
