cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From c.kreys...@t-online.de
Subject SQL Querys
Date Thu, 01 Jan 1970 00:00:00 GMT
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

Mime
View raw message