This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: read records from database in XSLT


It's not possible in XSLT, you need extensions. Either in XSLT (like 
http://xml.apache.org/xalan-j/extensionslib.html#sql for XALAN) or a 
servlet which evaluates your expressions and returns the XML.

Regards,

Joerg

Ming schrieb:
> Hi,
> 
> I have a question regarding reading records from a database in XSLT.
> 
> I have the following xml file:
> 
> <files>
> <file db="db1" name="/record/2233/21/1/12_mmish"  />
> <file db="db2" name="/record/2233/21/2/34_ytrrm"  />
> </files>
> 
> And the name attribute is a key in a mysql table. What I want is the
> value of the key. So, I can use "select recordvalue from Record where
> keyvalue = '/record/2233/21/1/12_mmish'" to get the record value from
> the table.
> 
> The record value is actually in xml format like this:
> <xml>
>   <db1>
>    <title> title1 </title>
>   </db1/>
> </xml>
> 
> What I need is to read the whole value in my stylesheet using something
> like <xsl:variable name='record' select="document(@name)/xml"/>. But
> since the name attribute is not the path to a xml file, I cannot use
> this method.
> 
> Can anyone give me some suggestions on how to approach this or some
> information I can know more about using queries in my stylesheet?
> 
> Thanks a lot.
> 
> Ming


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]