Alphabetic order

[joakimhan]

I had a problem before with orsering my data And I got help from CFhub and he gave me this solution And it works almost

The problem is it only shows one record after each starting Character.

<CFQUERY NAME=&quot;getDomain&quot; DataSource=&quot;mysource&quot;>
SELECT
name,
url,
langid,
Right(name,1) AS FirstChar
FROM domain
GROUP BY
FirstChar
</cfquery>

<cfoutput query=&quot;&quot; group=&quot;&quot;>
#FirstChar#
<cfoutput>
#name# #Url#
</cfoutput>
</cfoutput>


This is the way i would like it to show

A
ABCnews abcnews.go.com
AdWeek

http://www.adweek.com

;
Advertising Age

http://www.adage.com

;

Back to top

B
BBC News news.bbc.co.uk
Bloomberg

http://www.bloomberg.com/bbn/

;
Brandweek

i am new to coldfusion so I hope someone acn help me

 

[philhege]

joakimhan,

Shouldn't it be LEFT(name,1) as FirstChar?

 

[pcorreia]

Instead of your SELECT statement reading

  GROUP BY
   FirstChar

Make it read

  ORDER BY 
   FirstChar

Then, your output should look like this:

<cfoutput query=&quot;getDomain&quot; group=&quot;FirstChar&quot;>
   #FirstChar#
   <cfoutput>
      #name# #Url#
   </cfoutput>
</cfoutput>

The group attribute of the

<cfoutput>

tag expects the query to be ungrouped but ordered by that field. This should solve your problem.

I also believe that the function you are looking for is LEFT().

 

[joakimhan]

Thanks for the help, it works like a beauty now.
You guys are the best

Joakim

 

[pcorreia]

Glad we could be of service... how about a blue star for our efforts? ;o)

Seriously, though, here are some sites that can help you with CF issues:

http://www.defusion.com

http://docs.rinet.ru:8083/Cold/index.htm

http://www.forta.com/cf/

http://www.cfm-resources.com

http://www.thenetprofits.co.uk/coldfusion/faq/