SQL processor and XML submission

> My problem is the follow:
> I have a sql processor on sql.xpl file. This processor simply connect to a mysql database and perform a select query.
> The page flow is the follow:
>
> <page id="home" path-info="/anagrafica/home" view="operazioni-view.xhtml">
>  <action when="/employer/action = 'search'">
>   <result page="sql" transform="oxf:xslt">
>   <query xsl:version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
>   <name>
>     <xsl:value-of select="doc('input:action')/employer/name"/>
>   </name>
>   <surname>
>     <xsl:value-of select="doc('input:action')/employer/surname"/>
>   </surname>
>   <phone>
>     <xsl:value-of select="doc('input:action')/employer/phone"/>
>   </phone>
>   <address>
>     <xsl:value-of select="doc('input:action')/employer/address"/>
>   </address>
>   </query>
>   </result>
>   </action>
> </page>
>
> As you can see i try to submit an xml structure (<query>) to "sql".
> As result, in sql processor, the element <sql:param> can't find the value of relative element. As consequence my query always return null value.
> I try to replace sql processor with a processor that write the XML submission on a file to see the result. The xml file is correct and contains the aspected value.
> If i perform the XML submission from view page of HOME (operazioni-view.xhtml) with POST method i can perform the query with success.
> However i want to pass through page-flow to respect the MVC model.

> On 6/15/07, [hidden email] <[hidden email]> wrote:
>> My problem is the follow:
>> I have a sql processor on sql.xpl file. This processor simply connect to
>> a mysql database and perform a select query.
>> The page flow is the follow:
>>
>> <page id="home" path-info="/anagrafica/home"
>> view="operazioni-view.xhtml">
>>  <action when="/employer/action = 'search'">
>>   <result page="sql" transform="oxf:xslt">
>>   <query xsl:version="2.0"
>> xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
>>   <name>
>>     <xsl:value-of select="doc('input:action')/employer/name"/>
>>   </name>
>>   <surname>
>>     <xsl:value-of select="doc('input:action')/employer/surname"/>
>>   </surname>
>>   <phone>
>>     <xsl:value-of select="doc('input:action')/employer/phone"/>
>>   </phone>
>>   <address>
>>     <xsl:value-of select="doc('input:action')/employer/address"/>
>>   </address>
>>   </query>
>>   </result>
>>   </action>
>> </page>
>>
>> As you can see i try to submit an xml structure (<query>) to "sql".
>> As result, in sql processor, the element <sql:param> can't find the value
>> of relative element. As consequence my query always return null value.
>> I try to replace sql processor with a processor that write the XML
>> submission on a file to see the result. The xml file is correct and
>> contains the aspected value.
>> If i perform the XML submission from view page of HOME
>> (operazioni-view.xhtml) with POST method i can perform the query with
>> success.
>> However i want to pass through page-flow to respect the MVC model.
>
> Most likely, this is because the default namespace in your page flow
> is http://www.orbeon.com/oxf/controller. On the <query> element, try
> to add xmlns="".
>
> Alex
>
> --
> Orbeon Forms - Web 2.0 Forms, open-source, for the Enterprise
> http://www.orbeon.com/
>
>

> On 6/21/07, Massimiliano Di Dato <[hidden email]> wrote:
> > I try to put on query xmlns="" but nothing, i try to cancel xmlns attribute
> > but nothing.
> > How can i do?
>
> Is the XSLT running? Say, are you getting an error if you type an
> invalid XPath expression? If the XPath is running, is the input
> document what you expected it to be? Try to put somewhere <xsl:copy-of
> select="/*"/> and see what gets inserted there.
>
> Alex
> plain text document attachment (message-footer.txt)
> --
> 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