[thelist] writing out a multidimensional array as a TOC

[Matt Warden]

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.