You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Boris Althaus <bo...@petra-productions.de> on 2002/12/13 15:44:36 UTC

SQL-Transformer

Hallo Cocoon Users,

does the SQL-Transformer has a map-parameter like <map:parameter name="show-nr-of-cols"/> or is there a way to retrieve the number of cols in the resultset?

Regards
Boris

RE: SQL-Transformer

Posted by Geoff Howard <co...@leverageweb.com>.
sorry, just noticed you were talking about sql transformer - i had assumed
esql logicsheet in xsp.  i need more coffee.

try
      <map:transform type="sql">
        ...
        <map:parameter name="show-nr-of-rows" value="true"/>
      </map:transform>

then, your results should start off with an attribute nrofrows on rowset,
ie:
<rowset nrofrows="2" xmlns="http://apache.org/cocoon/SQL/2.0">

Geoff

-----Original Message-----
From: Boris Althaus [mailto:boris@petra-productions.de]
Sent: Friday, December 13, 2002 10:15 AM
To: cocoon-users@xml.apache.org
Subject: Re: SQL-Transformer


mysql
----- Original Message -----
From: Geoff Howard
To: cocoon-users@xml.apache.org
Sent: Friday, December 13, 2002 4:19 PM
Subject: RE: SQL-Transformer


There is a tag defined but it's not fully implemented, although it may be in
the very latest cvs. (it only worked for one particular database)  What
database are you using?

Geoff Howard
-----Original Message-----
From: Boris Althaus [mailto:boris@petra-productions.de]
Sent: Friday, December 13, 2002 9:45 AM
To: cocoon-users@xml.apache.org
Subject: SQL-Transformer


Hallo Cocoon Users,

does the SQL-Transformer has a map-parameter like <map:parameter
name="show-nr-of-cols"/> or is there a way to retrieve the number of cols in
the resultset?

Regards
Boris


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>

Re: SQL-Transformer

Posted by Boris Althaus <bo...@petra-productions.de>.
mysql
  ----- Original Message ----- 
  From: Geoff Howard 
  To: cocoon-users@xml.apache.org 
  Sent: Friday, December 13, 2002 4:19 PM
  Subject: RE: SQL-Transformer


  There is a tag defined but it's not fully implemented, although it may be in the very latest cvs. (it only worked for one particular database)  What database are you using?

  Geoff Howard
    -----Original Message-----
    From: Boris Althaus [mailto:boris@petra-productions.de]
    Sent: Friday, December 13, 2002 9:45 AM
    To: cocoon-users@xml.apache.org
    Subject: SQL-Transformer


    Hallo Cocoon Users,

    does the SQL-Transformer has a map-parameter like <map:parameter name="show-nr-of-cols"/> or is there a way to retrieve the number of cols in the resultset?

    Regards
    Boris

RE: SQL-Transformer

Posted by Geoff Howard <co...@leverageweb.com>.
There is a tag defined but it's not fully implemented, although it may be in
the very latest cvs. (it only worked for one particular database)  What
database are you using?

Geoff Howard
  -----Original Message-----
  From: Boris Althaus [mailto:boris@petra-productions.de]
  Sent: Friday, December 13, 2002 9:45 AM
  To: cocoon-users@xml.apache.org
  Subject: SQL-Transformer


  Hallo Cocoon Users,

  does the SQL-Transformer has a map-parameter like <map:parameter
name="show-nr-of-cols"/> or is there a way to retrieve the number of cols in
the resultset?

  Regards
  Boris