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