Paging Results by Letter

[ravenssi]

Does any one know how to page results by letter like it is done on this site

http://www.acts247.com/asp/bands_atoz_listing.asp

HELP PLEASE

 

[jitter]

With out being able to see their underlying code I could take a guess. You would basically use the one .asp page. Each link would pass the appropriate value in the query string ie. clicking 'A' will pass 'Value=A' in the querystring. When the asp page looks at this querystring and sees the value it bases its query on this value more than likely using something like this:

strSQL = "Select * From tblBands Where BandName Like '" & _
Request.Querystring("Value&quot & "%'"

Then they just loop through the recordset to populate the page.

Let me know if this makes sense and if you have any other questions.