Sorting recordset with 'index' letters

[tim-p]

Hi

I am trying to create a recordset where the results are sorted into
alphabetical order but also where an index letter is included at the top of
each new first letter's list:

ie.
A
Aardvark
Apple
Axe

B
Bee
Brain
Bus

C
Cat
Chair

Can anyone think how to do this?

Thanks for any suggestions!

TP

[Paul Whitham TMM]

This is how you do it in ASP.

Firstly make sure that the you sort the recordset output in alphabetical
order. Then you would use the following code on the page

<%
Dim ThisLetter, TestLetter, TestName
ThisLetter = ""
%>

'Start of Repeat Region
TestName = recordset.fields.Item("NameField").value
TestLetter = Left(TestName,1)

If ThisLetter <> TestLetter then
response.write ("<p>") & TestLetter
ThisLetter = TestLetter
End if
Response.Write ("<br>") & TestName

'End of Repeat Region

Once you have positioned the code then wrap the areas denoted by the Start &
End Comments in a dreamweaver created repeat region

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"tim-p" <webforumsuser@macromedia.com> wrote in message
news:d5sv2t$gcf$1@forums.macromedia.com...

> Hi
>
> I am trying to create a recordset where the results are sorted into
> alphabetical order but also where an index letter is included at the top

of

> each new first letter's list:
>
> ie.
> A
> Aardvark
> Apple
> Axe
>
> B
> Bee
> Brain
> Bus
>
> C
> Cat
> Chair
>
> Can anyone think how to do this?
>
> Thanks for any suggestions!
>
> TP
>

[tim-p]

Hi Paul

Works a treat!

Thank you very much for your help.

Tim P