Alphabetical list & Anchor links

add an 'order by letter ASC, company ASC' to the query to make sure the order is correct, then use the NESTED output like was shown. This is requiered for this to work as explained

this is a simple example that was shown above. see what it's doing?
<CFOUTPUT QUERY="getNames" GROUP="letter">
<H3><A NAME="#letter#">#letter#</A></H3>
<CFOUTPUT>#company#<BR></CFOUTPUT>
</CFOUTPUT>

To start out, you can query and get the first letter this way:

<CFQUERY NAME="getNames" DATASOURCE="mydsn">
SELECT company, Left(company, 1) AS letter FROM mytable ORDER BY company
</CFQUERY>

Then your output would be like this:

<CFOUTPUT QUERY="getNames" GROUP="letter">
<H3><A NAME="#letter#">#letter#</A></H3>
<CFOUTPUT>#company#<BR></CFOUTPUT>
</CFOUTPUT>

To create the anchor links, modify this code to write the output to one variable and add another variable that would write something like this:
<A HREF="###letter#">#letter#</A> |

When you're done, display the links and then the lists. You might need to modify this for company names that begin with a number.