cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From r...@offermanns.de
Subject eldap with nested esql query
Date Thu, 31 Jan 2002 16:25:02 GMT
Hi,

after getting eldap to work I would like to do an nested sql query inside the ldap result
rows.

esql query standalone works
eldap query standalone works

esql query inside eldap produces no error, but I always get an empty sql result set.

The code is something like:

<eldap:results>
  <eldap:get-entries>
    <entry>
      <esql:connection>
        <esql:pool>quart</esql:pool> 
	  <esql:execute-query>
 	    <esql:query>select * from test</esql:query> 
	    <esql:results>
              <esql:row-results>
	        <db_data>
		  <id><esql:get-string column="uid"/></id>
		</db_data> 
 	      </esql:row-results>
            </esql:results>
            <esql:no-results>
              <error>no results were found</error>
            </esql:no-results>
            <esql:error-results>
              <message><esql:get-message/></message>
              <stacktrace><esql:get-stacktrace/></stacktrace>
            </esql:error-results>
         </esql:execute-query>
        </esql:connection>	
        <ldap_dn><eldap:get-dn/></ldap_dn>
    </entry>
  </eldap:get-entries>
</eldap:results>

The same esql code on the same page *before* the ldap stuff works perfectly. But within the
ldap query, I always get
<entry>
  no results were found
  <ldap_dn>correct dn</ldap_dn>
</entry>

What am I doing wrong?

Rolf
--
Rolf Offermanns <rolf@offermanns.de>
PGP available on request

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

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