"_adrian" <test @ test.com> wrote in message
news:eq4gw8KFGHA.2320@TK2MSFTNGP11.phx.gbl...
> OK.. I"ve pretty much got the basics I need for most of my SQL needs..
> however.. I need to do the following..
>
> I've got two columns.. one we'll call colors.. and one we'll call
> numbers... What I need to do, is to take the following values:
>
> Colors Numbers
> ------ ----------
> Red 1
> Red 2
> Red 3
> Blue 4
> Blue 5
> Blue 6
>
> ....and SELECT and then order them on my web page (I'm using VBScript/ASP)
> so that they display like this:
>
> RED
> -----
> 1
> 2
> 3
>
> Blue
> ----
> 4
> 5
> 6
>
> I can place and lay out the recordsets retrieved from the dabatase fine..
> problem is, I don't know how to write the code so that it gives me the
> Color only once, followed by each of the rows.. right now, I get:
>
> Red
> ----
> 1
>
> Red
> ----
> 2 etc.... help?
>