cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fabrizio picca <fabrizio.pi...@gmail.com>
Subject Re: retrieving number of affected rows in a sql query
Date Tue, 09 Nov 2004 08:18:42 GMT
that parameter will set the attribute only if  the query gives back
effective rows(i.e if a query is fired up it gives back the number of
tuples corresponding the request. )

The sql "DELETE" (the one i'm using this time) does not give any tuple out.
So the nrofrows is 0.
I've already tried with that , but with no success.


On Tue, 09 Nov 2004 08:36:56 +0200, Derek Hohls <dhohls@csir.co.za> wrote:
> 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
> 
> 


-- 
copyright - fabpicca

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


Mime
View raw message