cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@vafer.org>
Subject Re: [ESQL-Bug???] sql exception: invalid cursor state
Date Thu, 23 Sep 2004 23:26:34 GMT
> 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

Mime
View raw message