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
