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
