Showing only once

Results 1 to 2 of 2

Thread: Showing only once

  1. #1
    Join Date
    Dec 1969

    Default Showing only once

    I have an Access database with a table called ‘address’ I need to display these on a page sorted by ‘suburb’ but with the suburb showing only once for all the records containing that suburb. I have implemented all the other code and it works fine, except I have the suburb name appearing on all records, looks messy.<BR>If anyone can help with the code, I would be most appreciative.

  2. #2
    Join Date
    Dec 1969

    Default RE: Showing only once

    Sort it out in ASP by hiding the repeating suburb:<BR>&#060;%<BR>LastSuburb = ""<BR>Do While Not rs.EOF<BR> If rs("Suburb").value&#060;&#062;LastSuburb Then<BR> &#039; Display Suburb<BR> Response.write rs("Suburb")<BR> End If<BR> &#039; Display all other fields in rs<BR> &#039; ...<BR> LastSuburb = rs("Suburb").value<BR> rs.MoveNext<BR>Loop<BR>%&#062;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts