This is a discussion on "QueryOfQuery ColdFusion" within the Databases section. This forum, and the thread "QueryOfQuery ColdFusion are both part of the Program Your Website category.
|
|
|
|
|
 |
||
QueryOfQuery ColdFusion
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Mar 18th, 2006, 19:39
|
|||
|
|||
|
QueryOfQuery ColdFusion
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> <cfset activeLetters = ValueList(getFirstLetters.FirstLetter)> Any help cordially appreciated. Thank You ContiW 
|
|
|
|
| Tags |
| queryofquery, coldfusion |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ColdFusion - Using listboxes - Need Help! | Keeldog | Other Programming Languages | 1 | Apr 18th, 2008 05:27 |
| Junior Coldfusion Developer | anzagi | Job Opportunities | 0 | Jun 17th, 2007 12:06 |
| Access, 3NF, ColdFusion, Excedrin | jswebdev | Databases | 1 | May 13th, 2006 13:03 |
| Coldfusion Developer Position | lintasllc | Job Opportunities | 0 | Dec 15th, 2005 19:55 |
| Junior Developer - Coldfusion - Cambs-UK | gsl_recruitment | Job Opportunities | 0 | Oct 11th, 2004 14:27 |
