You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Ma...@swisscom.com on 2003/05/27 17:23:29 UTC
XSP-ESQL : execute-query not executed. Something wrong?
Hello,
Is there something wrong with this code?
In the profiler I can see that the query is well executed to the SQL
Server, but in my page I get no data! And this query returns something
normally!
Thanks
<xsp:logic>
myquery = <esql:get-string column="pm_attrib"/>;
if (myquery != null) {
<esql:execute-query>
<esql:query>
<xsp:expr>myquery</xsp:expr>
</esql:query>
<esql:results>
<select>
<esql:row-results>
<option><esql:get-string
column="1"/></option>
</esql:row-results>
</select>
</esql:results>
</esql:execute-query>
}
</xsp:logic>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
RE: XSP-ESQL : execute-query not executed. Something wrong?
Posted by arnaud daneels <ad...@jouve.fr>.
hello,
which pool do you use and which database ?
-----Message d'origine-----
De : Maxime.Gheysen@swisscom.com [mailto:Maxime.Gheysen@swisscom.com]
Envoyé : mardi 27 mai 2003 17:23
À : cocoon-users@xml.apache.org
Objet : XSP-ESQL : execute-query not executed. Something wrong?
Hello,
Is there something wrong with this code?
In the profiler I can see that the query is well executed to the SQL
Server, but in my page I get no data! And this query returns something
normally!
Thanks
<xsp:logic>
myquery = <esql:get-string column="pm_attrib"/>;
if (myquery != null) {
<esql:execute-query>
<esql:query>
<xsp:expr>myquery</xsp:expr>
</esql:query>
<esql:results>
<select>
<esql:row-results>
<option><esql:get-string
column="1"/></option>
</esql:row-results>
</select>
</esql:results>
</esql:execute-query>
}
</xsp:logic>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org