cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lionel Crine <cr...@4dconcept.fr>
Subject xmltype and sql transformer
Date Thu, 28 Jul 2005 17:44:10 GMT
I'm trying to get an XMLTYPE from oracle.

Here is the query :
<sql:query name="name">SELECT ir_struct FROM T_BNF_IR WHERE ir_sysID 
='32'</sql:query>
but it returns nothing.

I have to write :SELECT ir_struct||'' instead of SELECT ir_struct

But this generates xml error because : the resut send :
<ir_struct||><blabla>....</blabla><it_struct||>


What can I do ?

Lionel



-- 
Lionel CRINE
Ingénieur Systèmes documentaires
Société : 4DConcept
22 rue Etienne de Jouy 78353 JOUY EN JOSAS
Tel : 01.34.58.70.70 Fax : 01.39.46.06.90


Mime
View raw message