Stumped on dynamic menu

[Marblehead Johnson]

Hi,
I have setup a basic query to list colours of a clothing item whilst taking on
the challenge of building an online shop. My simple query returns the colours,
however I am struggling to get these results into my form's menu for the user
to select their choice. I have setup the query 'qryItemColours' with the column
'Colour'. The starting code I have is...

<select name="Colours" id="Colours">
<option value="#qryItemColours.Colour#">#qryItemColours.Co lour#</option>
</select>

However this only returns the first value. What code do I need to include to
completly populate this menu with all query results?

Have searched through forum but with no similar problem. I'm sure I am missing
something very simple but stumped at this end.

Appreciate any help.
Thanking you in advance.:confused;

[RelentlessMike]

I believe that you are going to need to surround your <option> tags with one set of <CFLOOP> </CFLOOP> tags, referencing the query from the opening <CFLOOP> tag.

Hope that helps,
Mike

[Marblehead Johnson]

Works perfectly! Cheers Mike!

[weswhite7]

Hey - I had a similar problem but came back with not getting the result that I
was wanting. I had the smae problem as he did, but the cfloop doesn't give me
the fix.

Attribute validation error for tag CFLOOP.
The tag has an invalid attribute combination: . Possible combinations are:
Required attributes: 'from,index,to'. Optional attributes: 'step'.
Required attributes: 'condition'. Optional attributes: None.
Required attributes: 'query'. Optional attributes: 'endrow,startrow'.
Required attributes: 'index,list'. Optional attributes: 'delimiters'.
Required attributes: 'collection,item'. Optional attributes: None.


The error occurred in line 12

10 : <cfoutput query="grabmensscheduleVARJV">
11 : <select name="opponents" id="">
12 : <cfloop><option value="#opponent#">#opponent#</option></cfloop>
13 : </select>
14 : </cfoutput>

[weswhite7]

Actually, I figured out the answer to what I was doing wrong and what would
make your's much more simple.

Do it like so and it works:

<select all this stuff>
<cfoutputquery="whateveritis">
<option value="query">#query"</option
</cfoutput>
</select>