xmldb-query issus ?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

xmldb-query issus ?

Wang Yan
Hi, I have a problem with the code below. All ideas will be helpful ! Thank you.
------------------------------------------------------------------------------------------------------------------
<p:config xmlns:p="http://www.orbeon.com/oxf/pipeline" xmlns:oxf="http://www.orbeon.com/oxf/processors" xmlns:xdb="http://orbeon.org/oxf/xml/xmldb" xmlns:xu="http://www.xmldb.org/xupdate" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

    <p:param type="input" name="instance"/>
   
    <p:processor name="oxf:xslt">
        <p:input name="data" href="#instance"/>
        <p:input name="config">
             <xdb:query collection="/db/ops/ essaieXist" create-collection="true" xsl:version="2.0">
                xquery version "1.0";
                <result>
                    {for $getPersonal in /CGC-IS/Projects/EU-Project
                    where $getPersonal/ProjectContract/ProjectDescriptor/ProjectAcronym = '<xsl:value-of select="/*/document/ProjectName"/>'
                    return
                    <Finances>
             &n bsp;           {$getPersonal/ProjectContract/Status}
                    </Finances>}
                </result>
                </xdb:query>
        </p:input>
        <p:output name="data" id="xmldb-query"/>
    </p:processor>
** t******************************************************************************************************************
This 1st processor select the value in /*/document/ProjectName, and put all tags between <xdb:query>...</xdb:query> in the seconde processor
****************************************************************************** ****************************************
<!--p:processor name="oxf:xmldb-query">
        <p:input name="datasource" href="../data-access/exist/datasource.xml"/>
        <p:input name="query" href="#xmldb-query2"/>
        <p:output name="data" id="xmldb-query"/>
    </p:processor-->
********************************************************************************************************************
The 2nd process interprets the query by searching in the database (THIS IS THE PROBLEM PART, I CANT
OBTAIN THE RIGHT INFORMATION, THE ONLY THING WHICH IS RETURNED IS : <result/>, INSTEAD OF :
<result><Finances><Status>Signed</Status></Finances></result>)
********************************** **********************************************************************************
    <p:processor name="oxf:xml-converter">
        <p:input name="config">
            <config/>
        </p:input>
        <p:input name="data" href="#xmldb-query"/>
        <p:output name="data" id="converter"/>
    </p:processor>
    <p:processor name="oxf:file-serializer">
        <p:input name="config">
            <config>
                <file>data.xm l</file>
                <directory>C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\CGCReloaded\WEB-INF\resources\is\management\personal</directory>
            </config>
        </p:input>
        <p:input name="data" href="#converter"/>
    </p:processor>
</p:config>


-----------------------------------------------------
Romandie Annonces : http://annonces.romandie.com
Petites annonces 100% gratuites entre romands
-----------------------------------------------------




--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: xmldb-query issus ?

Alessandro  Vernet
Administrator
May I ask what the problem is? ;)

Alex

On 12/15/06, Wang Yan <[hidden email]> wrote:

> Hi, I have a problem with the code below. All ideas will be helpful ! Thank
> you.
> ------------------------------------------------------------------------------------------------------------------
> <p:config xmlns:p="http://www.orbeon.com/oxf/pipeline"
> xmlns:oxf="http://www.orbeon.com/oxf/processors"
> xmlns:xdb="http://orbeon.org/oxf/xml/xmldb"
> xmlns:xu="http://www.xmldb.org/xupdate"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
>
>     <p:param type="input" name="instance"/>
>
>     <p:processor name="oxf:xslt">
>         <p:input name="data" href="#instance"/>
>         <p:input name="config">
>              <xdb:query collection="/db/ops/ essaieXist"
> create-collection="true" xsl:version="2.0">
>                 xquery version "1.0";
>                 <result>
>                     {for $getPersonal in /CGC-IS/Projects/EU-Project
>                     where
> $getPersonal/ProjectContract/ProjectDescriptor/ProjectAcronym
> = '<xsl:value-of select="/*/document/ProjectName"/>'
>                     return
>                     <Finances>
>              &n bsp;
> {$getPersonal/ProjectContract/Status}
>                     </Finances>}
>                 </result>
>                 </xdb:query>
>         </p:input>
>         <p:output name="data" id="xmldb-query"/>
>     </p:processor>
> **
> t******************************************************************************************************************
> This 1st processor select the value in /*/document/ProjectName, and put all
> tags between <xdb:query>...</xdb:query> in the seconde processor
> ******************************************************************************
> ****************************************
> <!--p:processor name="oxf:xmldb-query">
>         <p:input name="datasource"
> href="../data-access/exist/datasource.xml"/>
>         <p:input name="query" href="#xmldb-query2"/>
>         <p:output name="data" id="xmldb-query"/>
>     </p:processor-->
> ********************************************************************************************************************
> The 2nd process interprets the query by searching in the database (THIS IS
> THE PROBLEM PART, I CANT
> OBTAIN THE RIGHT INFORMATION, THE ONLY THING WHICH IS RETURNED IS :
> <result/>, INSTEAD OF :
> <result><Finances><Status>Signed</Status></Finances></result>)
> **********************************
> **********************************************************************************
>     <p:processor name="oxf:xml-converter">
>         <p:input name="config">
>             <config/>
>         </p:input>
>         <p:input name="data" href="#xmldb-query"/>
>         <p:output name="data" id="converter"/>
>     </p:processor>
>     <p:processor name="oxf:file-serializer">
>         <p:input name="config">
>             <config>
>                 <file>data.xm l</file>
>                 <directory>C:\Program Files\Apache Software
> Foundation\Tomcat
> 5.5\webapps\CGCReloaded\WEB-INF\resources\is\management\personal</directory>
>             </config>
>         </p:input>
>         <p:input name="data" href="#converter"/>
>     </p:processor>
> </p:config>
>
>
>
>
> -----------------------------------------------------
>  Romandie Annonces : http://annonces.romandie.com
>  Petites annonces 100% gratuites entre romands
>  -----------------------------------------------------
>
>
> --
> You receive this message as a subscriber of the [hidden email]
> mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>

--
Blog (XML, Web apps, Open Source):
http://www.orbeon.com/blog/



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet