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