Hmpf, See my previous comment... ;-D
j/k I already did state my solution tho.
Either use a name letter .. always store the
first letter of the last name in its own
column, index that column.
Or do a query and on the last name field
do where lname = Lower(Left(LName, 1)) = 'letter'
If you are wanting to make the ones without
someone unclickable it would be a little
more complex, but still doable with one efficient
query.. I would lean towards just storing the
name letter and indexing that column.
In your query if you wanted the entire list without
pulling up specific members.. you would just select
the distinct name letter's and order it...
Checking for each individual letter with a separate
if check would also be cumbersome..
So, I personally would make a list of the alphabet loop over that
list creating a structure for each letter, no members
for that letters structure then you just display
the letter and no link... :)
Jeremy Allen
elliptIQ Inc.
>-----Original Message-----
>From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
>Sent: Friday, January 26, 2001 12:28 PM
>To: CF-Talk
>Subject: RE: Alphabetic List
>
>
>What would you suggest ?? :-)
>
>Justin
>
>>-----Original Message-----
>>From: Jeremy Allen [mailto:[EMAIL PROTECTED]]
>>Sent: Friday, January 26, 2001 4:36 PM
>>To: CF-Talk
>>Subject: RE: Alphabetic List
>>
>>
>>I would recommend against using this method
>>even if the field is indexed as this causes a
>>full table scan to occur which will greatly
>>degrade as it is used a lot and as the table
>>grows in size.
>>
>>Jeremy Allen
>>elliptIQ Inc.
>>
>>>-----Original Message-----
>>>From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
>>>Sent: Friday, January 26, 2001 12:27 PM
>>>To: CF-Talk
>>>Subject: Re: Alphabetic List
>>>
>>>
>>>You can do this in your SQL
>>>
>>>SELECT People Info
>>>WHERE LastName LIKE 'A%'
>>>
>>>This would be for people with last names that start with A.
>>>
>>>Kevin
>>>----- Original Message -----
>>>From: <[EMAIL PROTECTED]>
>>>To: "CF-Talk" <[EMAIL PROTECTED]>
>>>Sent: Friday, January 26, 2001 10:13 AM
>>>Subject: Alphabetic List
>>>
>>>
>>>> Hi,
>>>>
>>>> In Yahoo address book, they have this list for finding a particular
>>>> person easily
>>>> by the first letter of their last name:
>>>>
>>>> All - A B C D E F G H I J K L M N O P Q R S T U V W X Y Z - Lists
>>>>
>>>> Does anyone have any insights on how the algorithm of implementing this
>>>> feature?
>>>>
>>>> For example, I have a user database, and I want to use this feature to
>>>> find
>>>> persons whose last name start with a particular letter.
>>>>
>>>> Thanks!
>>>>
>>>> Hong
>>>>
>>>
>>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
