H.,
I believe you're missing the following element beneath your
<sql:execute-query> element, namely:
<sql:update-rows-attribute>rows-updated</sql:update-rows-attribute>
Hope this helps,
Christian
> -----Ursprüngliche Nachricht-----
> Von: M. Homayoun Pourheidari [mailto:homayoun_pourheidari@hp.com]
> Gesendet am: Montag, 31. Juli 2000 19:02
> An: cocoon-users@xml.apache.org
> Betreff: xsp/sql problems
>
> Hi,
>
> I'm trying to understand how the xsp works and I'm running into two
> issues:
>
> 1)
> I took the xsp example that was provided in the sql directory
> and got it
>
> to work :)
>
> Then I changed the query statement from a select to an insert and I
> insert a simple key, value pair ('k4', 'v4');
>
> -- taglib2.xml--
>
> <?xml version="1.0"?>
>
> <?cocoon-process type="xsp"?>
> <?cocoon-process type="xslt"?>
> <!-- <?xml-stylesheet href="taglib2.xsl" type="text/xsl"?> -->
>
> <xsp:page
> language="java"
> xmlns:sql="http://www.apache.org/1999/SQL"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core"
> >
>
> <page title="SQL Search Results">
>
> <sql:execute-query>
>
> <sql:driver>oracle.jdbc.driver.OracleDriver</sql:driver>
>
> <sql:dburl>myurl</sql:dburl>
> <sql:doc-element>rowset</sql:doc-element>
> <sql:row-element>row</sql:row-element>
> <sql:username>muusername</sql:username>
> <sql:password>mypasswd</sql:password>
> <sql:tag-case>lower</sql:tag-case>
> <sql:null-indicator>yes</sql:null-indicator>
> <sql:id-attribute-column>key</sql:id-attribute-column>
> <sql:query>insert into dummy values('k4','v4')</sql:query>
> </sql:execute-query>
>
> </page>
>
> </xsp:page>
>
> --
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
|