cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Derek Hohls" <DHo...@csir.co.za>
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"/> 
    </map:transform>

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

<rowset 
  xmlns="http://apache.org/cocoon/SQL/2.0"
  xmlns:sq2="http://apache.org/cocoon/SQL/2.0" 
  nrofrows="0" 
  name="my-query"/>

PS Suggest you use names for your queries below:

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


>>> fabrizio.picca@gmail.com 2004/11/08 06:42:45 PM >>>
i'm executing a query like this

<sql:execute-query>
		<sql:query>delete from comments where
cid='<xsl:value-of
select="$cid"/>' and user='<session:getxml context="cSession"
path="/parameter/username"/>' </sql:query>
	</sql:execute-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
affected"
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

mysql_affected_rows?

thank you.
-- 
copyright - fabpicca

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org 
For additional commands, e-mail: users-help@cocoon.apache.org 


-- 
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message