SPLIT HTML TABLE ON CHANGE IN VALUE?

[IncredibleVolk]

I currently have an html table that displays data from an SQL table. I was wondering if it's possible to create a new table for each value in a field. For instance:

Column A
X
X
X
Y
Y
Y

Is there a way I can create a new html table for each change in Column A? One table for X and one for Y?


do while not rs.EOF

 

[vbkris]

TheValue=""
do while not rs.EOF
if(TheValue<>rs("Column A")) then
TheValue=rs("Column A"))
response.write("New column: "&TheValue&"<br>")
end if


Known is handfull, Unknown is worldfull