You don't need to pass it as a parameter. Just use map:aggregate with a
map:part that gets all the authors. To cache the result of the SQL query you
can use an expires pipeline with a very long expiration time.
Jasha Joachimsthal
j.joachimst...@onehippo.com - ja...@apache.org
Hippo
Europe • Amsterdam Oosteinde 11 • 1017 WT Amsterdam • +31 (0)20 522
4466
USA • San Francisco 755 Baywood Drive Second Floor • Petaluma CA
94954 • +1 877 414 4776 (toll free)
Canada • Montréal 5369 Boulevard St-Laurent #430 • Montréal QC H2T 1S5
• +1 (514) 316 8966
www.onehippo.com • www.onehippo.org • i...@onehippo.com
On 16 January 2011 11:54, Andre Juffer <ajuf...@sun3.oulu.fi> wrote:
> On 01/14/2011 06:23 PM, Des Magner wrote:
>
>> Hi
>>
>> I want to combine two pieces of XML that gets passed to my XSL
>> transformation. I have a list of authors that needs only to be read
>> once. I then have a page to edit different articles and this page must
>> present the list of authors for selection. But I do not want to read the
>> list of authors from the database every time an article needs to be
>> edited. So I thought the best way to do this would be to define a
>> resource that contains the list of authors and pass this as a parameter
>> to the transformation for the article edit page as outlined below. Is it
>> possible to somehow refer to the authors resource where I have placed
>> the ???.
>>
>
> As far as I know this is NOT possible.
>
> As an alternative, you could include XML file with the authors list into
> the XML file containing the page that requires editing (or include the XML
> file containing the page into the XML file holding the authors list), before
> you use your transformer. The transformer that selects from the authors'
> node what it needs to produce the proper SQL.
>
>
>
>> Any help much appreciated
>> Regards
>> Des
>>
>> <map:resource name="authors">
>> <map:generate src="authors.xml"/>
>> <map:transform type="sql">
>> <map:parameter name="use-connection" value="myConnection"/>
>> </map:transform>
>> </map:resource>
>>
>> <map:generate src="article.xml"/>
>> <map:transform type="sql">
>> <map:parameter name="use-connection" value="myConnection"/>
>> <map:parameter name="article-id" value="{request-param:article}"/>
>> </map:transform>
>> <map:transform src="article.xsl">
>> <map:parameter name="authors" value="{???}"/>
>> </map:transform>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
>> For additional commands, e-mail: users-h...@cocoon.apache.org
>>
>>
>
> --
> Andre H. Juffer | Phone: +358-8-553 1161
> Biocenter Oulu and | Fax: +358-8-553-1141
> Department of Biochemistry | Email: andre.juf...@oulu.fi
> University of Oulu, Finland | WWW: www.biochem.oulu.fi/Biocomputing/
> StruBioCat | WWW: www.strubiocat.oulu.fi
> NordProt | WWW: www.nordprot.org
> Triacle Biocomputing | WWW: www.triacle-bc.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@cocoon.apache.org
> For additional commands, e-mail: users-h...@cocoon.apache.org
>
>
