Grouping recordsets

Results 1 to 2 of 2

Thread: Grouping recordsets

  1. #1
    Nick Herbert Guest

    Default Grouping recordsets

    Firstly, thanks to David Moran for answering my last question about null values.<BR><BR>My next question concerns grouping within recordsets.<BR><BR>I have a database of paintings. I want a page showing all the paintings, but grouped by the different artists.<BR><BR>I&#039;ve been looking up information on loops, but haven&#039;t been able to figure it out yet.<BR><BR>Please can someone give me a hint.<BR><BR>Many thanks,<BR><BR><BR>Nick

  2. #2 Guest

    Default RE: Grouping recordsets

    Ok. You would have a table of artists, each row has a field ArtistID, ArtistName, Comments. Another table Paintings with fields ArtistID, PaintingName, Image.<BR><BR><BR>On your first ASP page, you display the rows from the artist table, each with a link:<BR><BR>&#060;a href="paintings.asp?ArtistID=&#060;%=Rs("ArtistID" )%&#062;"&#062;&#060;%=Rs("ArtistName")%&#062;&#06 0;/a&#062;<BR><BR>then you build the second page round the query<BR>"Select * from Paintings where ArtistID=" & Request.QueryString("ArtistID")<BR>

Posting Permissions

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