OK, backtracking a bit.

I have a similar situation where I use script to create an XML document that
is the files and folders with filenames and extensions etc. (not that hard).
Once you have that you can do anything you want using XSLT and the
document() function as long as the files don't disappear.

If you keep your recursive script to generate the base XML generalised then
you can use any XSLT you want to give any form of representation of the
files and folders. In my case I am parsing for XML documents since I'm
keeping metadata about DBF files in corresponding XML files (same names) and
then using this as the basis for an ADO upload to a specific system.

Chris.


"dSchwartz" <schwartz@c...> wrote in message
news:4ae1ece2.0403031442.69ee256c@p......
Thanks all for your comments.  I guess I'll probably think about
storing the xml inside MS SQL server, or even just using SQL Server
instead of xml....


"Chris Barber" <chris@b...> wrote in message
news:<#stOeLEAEHA.1608@T...>...
> One more comment.
>
> document() doesn't handle missing files very well - it raises a parse time
> error. First time I got this I admit that I had expected it to just
> gracefully gloss over and continue (shows how much I read the docs then).
>
> I'm not saying that this behaviour is wrong but it's a bit annoying at
times
> and to my mind makes the XSLT a bit fragile where this particular method
is
> concerned.
>
> Chris.
>
> "dSchwartz" <schwartz@c...> wrote in message
> news:4ae1ece2.0403011455.495fe581@p......
> What I think I'm looking for is a way (in XSL stylesheet) to get the
> contents of a directory.  How can this be accomplished?
>
> more detailed:
>
> /root
>  index.aspx
>  xsl_style.xsl
>  /xml
>   newsletter_001.xml
>   newsletter_002.xml
>   newsletter_xxx.xml
>
>
> now i want to use xsl_style.xsl to pull two attributes from the root
> element of each and every file in the xml directory.  Something like
> this:
>
> for (each file in xml AS xmlFile)
>  <xsl:value-of select="document(xmlFile)//newsletter[@title]" />
>  <xsl:value-of select="document(xmlFile)//newsletter[@date]" />
>
>
> how do i create that loop?  I have to do this without a file that
> contains a list of the files in the xml directory, so i need to
> dynamically get the contents of the xml directory!
>
> Thanks for your time