Return-Path: <sudheendra@insage.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 46859 invoked from network); 30 Aug 2000 13:39:31 -0000
Received: from corporate.planet.net (208.163.25.10)
  by locus.apache.org with SMTP; 30 Aug 2000 13:39:31 -0000
Received: from insage.com (prog16.planet.net [208.163.30.16])
	by corporate.planet.net (8.9.3/8.8.5) with ESMTP id JAA16168
	for <cocoon-users@xml.apache.org>; Wed, 30 Aug 2000 09:39:05 -0400 (EDT)
Message-ID: <39AD0EFC.8363856C@insage.com>
Date: Wed, 30 Aug 2000 09:41:16 -0400
From: sudhi <sudheendra@insage.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: cocoon-users@xml.apache.org
Subject: Re: sql again
References: <BHELJKKOALHGCBGAFINIAEAPCAAA.gdanov@comsoft.bg>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

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