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