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 <[EMAIL PROTECTED]>
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to