Re: [ESQL-Bug???] sql exception: invalid cursor state

[Markus Heussen]

I'm sorry Torsten, but it does not work. I did like you said but now I 
get the following exception:

Original Exception: 
org.apache.avalon.framework.CascadingRuntimeException: Error getting 
ascii data for column HSNName
	at 
org.apache.cocoon.components.language.markup.xsp.EsqlHelper.getAscii(EsqlHelper.java:270)

cause: java.sql.SQLException: No data found
And now? This exception occurs even if I do a selection without DISTINCT 
or GROUP BY term.

Many thanks for your help! :-)
Greetings, Markus
Torsten Curdt schrieb:
If not please tell me what I'm doing wrong.

Try the following...
<esql:connection>
  <esql:pool><xsp-session:get-attribute name="server"/>wktkl</esql:pool>
  <esql:execute-query >
    <esql:query>SELECT DISTINCT HSNName FROM TabKFZ</esql:query>

      <esql:use-limit-clause>pervasive</esql:use-limit-clause>
    <esql:results>
      <xforms:select1 ref="FahrzeugsucheHersteller" 
appearance="minimal" tabindex="1" class="FahrzeugsucheHersteller" 
risk="112" server="*" client="*">
        <xforms:choices>
          <esql:row-results>
            <xforms:item>
            <xforms:label><esql:get-string 
column="HSNName"/></xforms:label>
            </xforms:item>
          </esql:row-results>
        </xforms:choices>
      </xforms:select1>
    </esql:results>
    <esql:no-results/>
    <esql:error-results/>
  </esql:execute-query>
</esql:connection>

cheers
--
Torsten