You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Conny Kreyßel <Co...@inter-forum.de> on 2000/04/14 11:21:53 UTC

SQL Querys

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?


With best regards

Conny Kreyßel

INTER-FORUM Systemhaus GmbH
Chemnitzer Str. 7
04457 Leipzig
Germany

Tel.:  +49-341-25 92 00
Fax :  +49-341-25 92 020
WWW :  http://www.inter-forum.de/
eMail: conny.kreyssel@inter-forum.de