Database Result Grouping.

kefka1911 · #1 (**permalink**) 10-28-04, 15:28

Hello there, I am building an intranet web page using ASP that searches an Access DB. In the Database I have a field that contains dublicate words. For Ex.
[ SUBJECTS][ORG_LEVEL_1]
-------------------------------------
[Abuse ][Womens Abuse Society ]
[Abuse ][Childrens Abuse Center ]
[Baseball ][Newmarket Baseaball Ass.]

When I do a search, My current Script shows the results just as it is shown there, what I would like is for it to show like this.

[Abuse ][Womens Abuse Society ]
[Childrens Abuse Center ]
[BaseBall ][Newmarket Baseball Ass. ]

Thanks in Advance.

rokslide · #2 (**permalink**) 10-28-04, 16:56

So you do something like this....

Code:

Dim currentSubject
currentSubject=""
Response.Write("<table>")
Do while not myRecordset.eof
  response.write("<tr>")
  if myRecordset("Subject") <> currentSubject then
    Response.Write("<td>" & myRecordset("Subject") & "</td>")
  else
    Response.Write("<td></td>")
  end if
  Response.Write("<td>" & myRecordset("Org_Level_1") & "</td>")
  response.write("</tr>")
  myRecordset.MoveNext
Loop
Response.Write("</table>")

Internet Services

Web Development

Digital Marketing

Consumer Tech