cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: SQL Querys
Date Wed, 19 Apr 2000 05:21:10 GMT
On 18 Apr 2000 c.kreyssel@t-online.de wrote:

> When I try to get a query from our database like this
> 
> <database>
> 
>  &dbconn_defs;
> 
>  <query connection="oracle">
>   SELECT id,artbez FROM bez WHERE id = 100
>  </query>
> 
> </database>
> 
> it will be worked fine, but when I try like this
> 
> <database>
> 
>  &dbconn_defs;
> 
>  <query connection="oracle">
>   <![CDATA[SELECT id,artbez FROM bez WHERE id = 100]]>
>  </query>
> 
> </database>
> 
> it doesnt work, and I receive a error from our database "invalid 
> SQL-Statement".
> 
> I would like use > or < in the statement but the same error is occured. 
> What is wrong?

Likely a bug in the code - try using &lt; and &gt; and see if it works.

- donald


Mime
View raw message