[Zope] Newbie Question (dropdown menu)

[Jim Washington]

Hi, Joel

<untested>

Just displaying the list in a <select>:

<select name="whatever">
<dtml-in ZSQLMethodthatgetsthelist>
<option value="<dtml-var theFieldname>"><dtml-var theFieldname></option>
</dtml-in>
</select>

If "whatever" already has a value and you want that selected:

<select name="whatever">
<dtml-in ZSQLMethodthatgetsthelist>
<option value="<dtml-var theFieldname>"
<dtml-if "whatever == theFieldname"> selected </dtml-if>>
<dtml-var theFieldname></option>
</dtml-in>
</select>

</untested>

the </option> tags are apparently optional.

hth

-- Jim Washington

joel grimes wrote:
> 
> I'm trying to fill a combo-box (pardon the vb-centric lingo - I don't know
> what the things are called - it's a <select...><option...> thing) with items
> selected from a table.  I haven't a clue how to do this.  I've got the ODBC
> Connection and SQL Method working, but how do I iterate through the query
> results to fill a drop-down?
> 
> Thanks
> 
> Joel Grimes