RE: Named queries in SQLTransformer

Thu, 10 Nov 2005 00:39:03 -0800

Agreed - remember namespaces throughout!  If
in doubt, suggest you do some reading around XSLT;
there are lots of good resources/books on the 'net and
its well worth the time to learn, if you plan on working
with XML in any shape or form.
 
Also; you can look at using Cocoon Views to get
intermediate outputs (eg. from the SQL transformer);
again; various articles and discussions on this topic. eg.


>>> [EMAIL PROTECTED] 2005/11/10 10:23 AM >>>
I do not exactly know what you are asking here, shouldn't you just read some documentation about cocoon stuff?

Anyway, if you are familiar with xsl, and you try to transform your results form the sqltransformer, do not forget the sql namespace.

For example : <xsl:value-of select="/sqlpart/sql:rowset/sql:row/sql:thisfield"/>

Probably you forgot the namespace

AS

>
>
> Hi,
>
> I am trying to create an XSL page
> showing rowsets from several queries from SQLTransformer
> (Cocoon 2.0.4 with sitemap actions),
> but so far can't see anything on the screen.
>
> 1) Could you please point me to some good example
> of such simple (select) DB report - especially XSL part ?
>
>
> 2) I think, I can't get anything from SQL transformer
> because I am trying to read its output from incorrect place:
> <xsl:variable name='thedata'
> select='/page/content/paging/data'/>
>
> Is there a standard place for the output of SQL Transformer?
> Or how and where is it specified (if you give query a name)?
> Maybe it should be: /page/content/paging/data/cust_data
> or /root/?/page/content/paging/data/cust_data ?
> (where cust_query is a query name).
>
>
> TIA,
> Oleg.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


--
This message is subject to the CSIR's copyright, terms and conditions and e-mail legal notice.
Views expressed herein do not necessarily represent the views of the CSIR.

CSIR E-mail Legal Notice

CSIR Copyright, Terms and Conditions

For electronic copies of the CSIR Copyright, Terms and Conditions and the CSIR Legal Notice
send a blank message with "REQUEST LEGAL" in the subject line to CSIR HelpDesk


This message has been scanned for viruses and dangerous content by MailScanner,
and is believed to be clean. MailScanner thanks Transtec Computers for their support.