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
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
