On Tue, Aug 5, 2008 at 9:27 PM, Joel D Canfield <joel at bizba6.com> wrote: > my brain is melting; I should know how to do this but it just won't come > to the surface > > I have aryTOC as rs.GetRows > > the data looks much like > [secID] [secDesc] [chapID] [chapDesc] > 1 Section1Desc 1 Chapter1Desc > 1 Section1Desc 2 Chapter2Desc > 2 Section2Desc 3 Chapter3Desc > > etc. > > multiple sections, multiple chapters within each section > > I want to write > > Section1Desc > Chapter1Desc > Chapter2Desc > . . . > All the chapters in Section1 > Section2Desc > allt he chapters in Section2 Assuming your data set is ordered.. I'm going to use it as if it were a resultset because I don't remember the notation for accessing a multi-dimensional array in vbscript,. but here's the algorithm currentSection = "" loop ' i forget the exact syntax for vbscript if currentSection <> aryTOC("secDesc") then currentSection = aryTOC("secDesc") response.write currentSection ' format as needed end if response.write aryTOC("chapDesc") ' format as needed end loop -- Matt Warden Cincinnati, OH, USA http://mattwarden.com This email proudly and graciously contributes to entropy.