cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sudhi <sudheen...@insage.com>
Subject Re: sql again
Date Wed, 30 Aug 2000 13:41:16 GMT
Hi,
The only thing I can suspect is ' .
Try changing it to &apos;
Eg

<sql:query>update table1 set name=&apos;goro&apos;</sql:query>

HTH
~S

Gerogi Danov wrote:
> 
> Here is the page, I am using to produce result - nothing unusual.
> But in the moment I change the contents of the <sql:query> tag with :
> 
> <sql:query>update table1 set name='goro'</sql:query>
> 
> I get the responce "statement unproprerly terminated" from JDBC.
> What do you say Dima :) ?
> 
> <?xml version="1.0"?>
> <?cocoon-process type="xsp"?>
> <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:username>goro</sql:username>
>                 <sql:password>goro</sql:password>
>                 <sql:driver>oracle.jdbc.driver.OracleDriver</sql:driver>
>                 <sql:dburl>jdbc:oracle:thin:@192.168.20.222:1521:vectra</sql:dburl>
>                 <sql:doc-element>options</sql:doc-element>
>                 <sql:row-element>options</sql:row-element>
>                 <sql:tag-case>lower</sql:tag-case>
>                 <sql:null-indicator>yes</sql:null-indicator>
>                 <sql:id-attribute>ID</sql:id-attribute>
>                 <sql:id-attribute-column>foo_id</sql:id-attribute-column>
>                 <sql:query>select * from table1</sql:query>
>                 <sql:count-attribute>count</sql:count-attribute>
>         </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

Mime
View raw message