Subject: [xsl] read records from database in XSLT From: Ming <myu@xxxxxxxx> Date: Tue, 14 May 2002 17:00:13 -0600 |
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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] Passing a parameter from , Stuart Celarier | Thread | Re: [xsl] read records from databas, Joerg Heinicke |
[xsl] Passing a parameter from one , paul morgan | Date | RE: [xsl] Passing a parameter from , Stuart Celarier |
Month |