I use this- it gives you the A-Z but only letters that need to appear: <cfquery name="select_az" datasource="#dsn#"> SELECT DISTINCT LEFT(*COLUMN*,1) AS MyAlpha FROM *TABLE* ORDER BY LEFT(*COLUMN*,1) </cfquery>
HTH d ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, September 29, 2003 10:16 AM Subject: Re: [ cf-dev ] Simple a to z > > here's a very simple version: > > <cfquery name="getContent"> > select name > from table > order by name > </cfquery> > > <cfset currentLetter = ""> > <cfset newLetter = ""> > > <cfoutput query="getContent"> > <cfset newLetter = Left(getContent.Name, 1)> > > <cfif CompareNoCase(newLetter, currentLetter)> > <!--- first letter of this item is different from the one before ---> > <p><strong>#UCase(newLetter)#</strong><br> > <cfset currentLetter = newLetter> > </cfif> > > #getContent.Name#<br> > </cfoutput> > > would be easy to amend this to whatever you want. > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > > [EMAIL PROTECTED] > ham.gov.uk To: [EMAIL PROTECTED] > cc: > 29/09/2003 10:08 Subject: [ cf-dev ] Simple a to z > Please respond to dev > > > > > > > Does anyone know of a simple a to z list system to save me writing another > one? > > A to Z accross the top with paged results etc..... > > Regards - Paul > > > > > **************************************************************************** ********************* > > The information contained within this e-mail (and any attachment) sent by > Birmingham City Council is confidential and may be legally privileged. It > is intended only for the named recipient or entity to whom it is addressed. > If you are not the intended recipient please accept our apologies and > notify the sender immediately, or telephone +(44) 121 303 6666. > Unauthorised access, use, disclosure, storage or copying is not permitted > and may be unlawful. Any e-mail including its content may be monitored and > used by Birmingham City Council for reasons of security and for monitoring > internal compliance with the office policy on staff use. E-mail blocking > software may also be used. Any views or opinions presented are solely those > of the originator and do not necessarily represent those of Birmingham City > Council. We cannot guarantee that this message or any attachment is virus > free or has not been intercepted and amended. > > **************************************************************************** ********************* > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]