C
contiw
Guest
The column "title" exists in a normal query.
Need to select the first letter of the titles to build a list for a prev-next alphabetical search.
I am not able to make the following QoQ work.
I have tried many variations both in the SELECT statement and in the GROUP BY
<cfquery name="getFirstLetters" dbtype="query">
SELECT #left(getEntries.Title,1)# as FirstLetter
FROM getEntries
GROUP BY #left(getEntries.Title,1)#
</cfquery>
<cfset activeLetters = ValueList(getFirstLetters.FirstLetter)>
Any help cordially appreciated. Thank You
ContiW
Need to select the first letter of the titles to build a list for a prev-next alphabetical search.
I am not able to make the following QoQ work.
I have tried many variations both in the SELECT statement and in the GROUP BY
<cfquery name="getFirstLetters" dbtype="query">
SELECT #left(getEntries.Title,1)# as FirstLetter
FROM getEntries
GROUP BY #left(getEntries.Title,1)#
</cfquery>
<cfset activeLetters = ValueList(getFirstLetters.FirstLetter)>
Any help cordially appreciated. Thank You
ContiW
