Hi ok I have a table: "rlbTerms" that contains basically a list of terms and their definitions.
I create a page with a query that returns all the terms and definitions in a table layout and are order by terms ASC.
What I want is a way to create anchor tags dynamically so that a user can click on the letter "G" and it will take them to the "G" section of the table.
I tried googling the function, but honestly not sure what to look for. I hope I explained this well enough to understand. Thanks for any advice in advance!
btw here is my query:
<cfquery name="rsTerms" datasource="rlbulbs">
SELECT rlbterms.terms, rlbterms.definitions
FROM rlbterms
ORDER BY rlbterms.terms
</cfquery>
Here was what I was trying to do:
<cfquery name="rsTerms" datasource="rlbulbs">
SELECT rlbterms.terms, rlbterms.definitions, left(rlbterms.terms,1) AS letterField
FROM rlbterms
ORDER BY rlbterms.terms
</cfquery>