cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Maxime.Ghey...@swisscom.com>
Subject RE: ESQL: "execute-query" ignored by cocoon!!!
Date Thu, 10 Apr 2003 12:43:57 GMT
that's just a part of the sample... if you prefer :

...
 <esql:connection>
 <esql:pool>wfmgt</esql:pool>
...
	 <esql:execute-query>
		<esql:query>
			select ur_name from Users
	    </esql:query>
		<esql:results>
		  <td align="left"><select name="mywfdispatcher"
width="100%">
		  <option>all</option>
		  <esql:row-results>
			<option><esql:get-string
column="ur_name"/></option>
		  </esql:row-results>
		 </select></td>
		</esql:results>
	  </esql:execute-query>	
...
	  <esql:execute-query>
		<esql:query>
			select * from Status
	    </esql:query>
		<esql:results>
		  <td align="left"><select name="mywfstatus"
width="100%">
		  <option>all</option>
		  <esql:row-results>
			<option><esql:get-string
column="st_name"/></option>
		  </esql:row-results>
		 </select></td>
		</esql:results>
	  </esql:execute-query>	
...
 </esql:connection>
...

And in the Profiler I only get "select * from status", nothing else.




-----Original Message-----
From: Leszek Gawron [mailto:ouzo@vip.net.pl] 
Sent: Thursday, April 10, 2003 2:41 PM
To: cocoon-users@xml.apache.org
Subject: Re: ESQL: "execute-query" ignored by cocoon!!!


On czw, kwi 10, 2003 at 02:30:57 +0200, Maxime.Gheysen@swisscom.com
wrote:
> I don't know why, but in all my pages, all the following queries are
> simply ignored!!!! Cocoon just jump over it! in SQL Profiler I see all
> queries, like "select * from Status", "select * from Groups", but not
> following! Is it maybe because of a conflict with the session variable
> "user"? 
> 
> 	 <esql:execute-query>
> 		<esql:query>
> 			select ur_name from Users
> 	    </esql:query>
> 		<esql:results>
> 		  <esql:row-results>
> 			<option><esql:get-string
> column="ur_name"/></option>
> 		  </esql:row-results>
> 		</esql:results>
> 	  </esql:execute-query>		
Is the piece of code you provided enclosed with <esql:connection> tag ?
	ouzo
-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/      ouzo@vip.net.pl          _\\()//_
         .'/()\'.     Phone: +48(600)341118     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message