In the following how can I make this loop only display the piarea once.
Meaning piarea is the title and instead of having it display for each title I want the piarea to display once then have the title items underneath it. Example right now if the piarea is listed for
Square twice I see Square listed then the title - then Square agaian then the title. I only want square displayed once then the two titles underneath it:
Do While Not recAll.EOF
srArea = recAll("piarea").Value
strAbstract = recAll("pititle"))
Response.Write "<br>" & strArea
Response.Write "<br>" & strAbstract & "<br><br>"