QueryOfQuery with ColdFusion MSAccess - Select title first letter only

[walter via AccessMonster.com]

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 this 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>


Any help cordially appreciated. Thank You
ContiW

 

[Duane Hookom]

I'm not sure which functions work in a query of queries. Consider creating
the FirstLetter in your original query. Then your second <cfquery> will be:

<cfquery name="getFirstLetters" dbtype="query">
SELECT FirstLetter
FROM getEntries
GROUP BY FirstLetter
</cfquery>

 

[walter via AccessMonster.com]

Consider creating the FirstLetter in your original query.

Thank You Douane. It works. Still I will continue researching why it doesn't
in the QoQ.
Have a nice weekend.
WalterConti

 

[Duane Hookom]

Perhaps QoQ doesn't support the Left() function.