Accessing nrofrows from SQL Transformer within Stylesheet

2003-03-11 Thread Samuel Bruce
Hello, I can't seem to access the nrofrows value returned from the SQL Transformer. The resulting XML after the SQL Transformer executes in my pipeline is as follows: records rowset xmlns=http://apache.org/cocoon/SQL/2.0; nrofrows=4 row ... /row row ... /row

RE: Accessing nrofrows from SQL Transformer within Stylesheet

2003-03-11 Thread Samuel Bruce
Thanks very much. That worked. I tried the sql namespace prefix before but I put it in the wrong place. Previously I used sql:@nrofrows. Thanks again. --- Luca Morandini [EMAIL PROTECTED] wrote: -Original Message- From: Samuel Bruce [mailto:[EMAIL PROTECTED] Sent: Tuesday, March

Logic control in sitemap via parameters

2003-03-06 Thread Samuel Bruce
Within a pipeline, I retrieve DB records using an SQL Transformer. I know the number of rows that I've retrieved using the nr-of-rows parameter. I'd like to branch to a different pipeline if the number of rows retrieved in the SQL Transform is 0. Is there a way to pass that nrofrows value from my

Re: Newbie Use of Request Params with DB Action

2003-03-04 Thread Samuel Bruce
:43 PM, Samuel Bruce wrote: Thanks for responding and sorry for the ambiguity of my post. Your reply was helpful. The parameters that I am referring to are request parameters sent from a post in an HTML form to a pipeline in my sitemap. That pipeline has a mod-db action. I'd like

Re: Newbie Use of Request Params with DB Action

2003-03-04 Thread Samuel Bruce
I don't know what I did the first time, but whatever I did wrong I must not have had enough patience to look at it closer. The request parameters ARE displayed with the request generator after the db action. Thank you again for your help! --- Samuel Bruce [EMAIL PROTECTED] wrote: Thank you once

Re: Newbie Use of Request Params with DB Action

2003-03-04 Thread Samuel Bruce
Thanks. Solved with your help. Take care, be well, God bless. --- Christian Haul [EMAIL PROTECTED] wrote: On 04.Mar.2003 -- 06:26 AM, Samuel Bruce wrote: I don't know what I did the first time, but whatever I did wrong I must not have had enough patience to look at it closer

Newbie Use of Request Params with DB Action

2003-03-03 Thread Samuel Bruce
Hello, I'm using a version of cocoon that I built from CVS back in October of 2002, running with tomcat 4.1.12 on WIN XP. I have a pipeline that generates an HTML form and passes parameters to a mod-db action which inserts DB records successfully. Can any of those parameters passed to the

Re: Newbie Use of Request Params with DB Action

2003-03-03 Thread Samuel Bruce
[EMAIL PROTECTED] wrote: Samuel Bruce wrote: Hello, I'm using a version of cocoon that I built from CVS back in October of 2002, running with tomcat 4.1.12 on WIN XP. I have a pipeline that generates an HTML form and passes parameters to a mod-db action which inserts DB

Re: mod-db action yields 'CALL IDENTITY()' MySQL syntax error

2002-10-25 Thread Samuel Bruce
Thanks very much. It worked like a charm. This configuration wasn't apparent to me from reading the documentation. Thanks for making it clear. --- Christian Haul [EMAIL PROTECTED] wrote: On 24.Oct.2002 -- 09:38 PM, Samuel Bruce wrote: Hello, I'm using the latest CVS, TC 4.1.12, JDK

Package oracle.jdbc/sql does not exist error building latest CVS

2002-10-24 Thread Samuel Bruce
I'm using WIN XP, JDK 1.4.01, Tomcat 4.04 Any help is greatly appreciated __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -

mod-db action yields 'CALL IDENTITY()' MySQL syntax error

2002-10-24 Thread Samuel Bruce
Hello, I'm using the latest CVS, TC 4.1.12, JDK 1.4.01. The mod-db action inserts the first row correctly, but fails on the second row insert. It seems to also fail attempting to rollback. Anything you can do to help is appreciated. Here is a snippet from my sitemap.log: DEBUG (2002-10-24)