Question

Hi, How to create a "html select" form with values from a Table ? I Have a table with a single column "name", ( used in twikiforms ):

I want to retrieve values from a search in order to build a select list : one two three .*

( This is for a topic where a I won't edit/apply a form : it is for some other topic )

Thanks

Environment

-- OlivierThompson - 19 Jun 2007

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

See TWiki.SearchPatternCookbook#Pattern_1_Extract_values_from_a. This topic is also included in your local TWiki web.

-- LynnwoodBrown - 19 Jun 2007

Thank you. This works partilay because I can't get rid of the "*name*" field, since the table have only one column : it's a twikiform with possible values for the form in a separate topic : How can I do a "grep -v Name" in the search ?

*Name* - one two three

-- OlivierThompson - 20 Jun 2007

Can you have your selectbox generated from the same topic as the values that are being pulled to generate the twikiform?

-- MatthewCardozo - 26 Jun 2007

Using the table example on this topic, write this:

<form>
<select>
%SEARCH{ "^\| *[a-z]" topic="%TOPIC%" type="regex" casesensitive="on" multiple="on" nonoise="on" format="<option>$pattern(^\| *([a-z]*) *.*)</option>" }%
</select>
</form>

to get this:

Replace "%TOPIC%" with the name of the option topic.

-- PeterThoeny - 10 Aug 2007