I'd suggest hitting the DB directly, instead of Q of Q (should be faster). You could use a URL param like so: <a href="search.cfm?q=M">M</a>
And then in search.cfm do this query: select lastname, firstname from authors where lastname like '#url.q#%' That query would work in MSSQL, not sure about other DBs out there. > -----Original Message----- > From: Seeman H. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 05, 2006 12:58 PM > To: CF-Newbie > Subject: Query for searching by letters of alphabet > > How can I create a search for authors from a table (maybe a > query of queries) where all the letters of the alphabet are > displayed and the user can pick a letter (say M) and it will > then display all author lastnames sorted by the letter M. > Thanks for any help with this. "EMF <idahopower.com>" made the following annotations. ------------------------------------------------------------------------------ This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ============================================================================== ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2312 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
