cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <>
Subject Re: retrieving number of affected rows in a sql query
Date Tue, 09 Nov 2004 06:36:56 GMT
Try using:

    <map:transform type="sql">
      <map:parameter name="use-connection" value="your-connection"/>
      <map:parameter name="show-nr-of-rows" value="true"/> 
      <map:parameter name="clob-encoding" value="UTF-8"/> 

Assuming there is no matching record, you will get XML something


PS Suggest you use names for your queries below:

  <sql:query name="my-query">

>>> 2004/11/08 06:42:45 PM >>>
i'm executing a query like this

		<sql:query>delete from comments where
select="$cid"/>' and user='<session:getxml context="cSession"
path="/parameter/username"/>' </sql:query>

i've this problem:

When the where clauses are respected the line is correctly deleted and
i should obtain (simulating in mysql shell) something like "ok, 1 row
otherwise i should get "0 rows affected".

Is there in cocoon a way to get the number of rows affected by a query
like php instruction


thank you.
copyright - fabpicca

To unsubscribe, e-mail: 
For additional commands, e-mail: 

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.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message