HOW TO OUTPUT MULTIPLE SELECT VALUES DROP DOWN?

[olchik]

Hello, I am trying to output multiple select values in drop down box. This is an update form. User sees what he selected previously and can edit it if needed.
This is my code:
<tr>
<td bgcolor=eeeeee width="226" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Post Weeks:</font></font><font color=ff0000>*</font><br><font size="1">Hold shift while clicking to select multiple weeks. 8 weeks max</font></td>
<td width="514"> <select id="sel01" name="postweek" multiple size="5" onchange="copyOptions();" onblur="countit(this)">
<cfoutput query="get_request_info"><cfloop from="#startdate#" to="#dateAdd("d",700,now())#" index="i" step="7">
<option value="Week #week(i)# (#dateformat(i,"mm/dd/yyyy")# - #dateformat(dateAdd("d",6,i),"mm/dd/yyyy")#)" <Cfif postweek is "Week #week(i)# (#dateformat(i,"mm/dd/yyyy")# - #dateformat(dateAdd("d",6,i),"mm/dd/yyyy")#)">selected</CFIF>> Week <cfif #week(i)# is "53">1<cfelse>#week(i)#</cfif> (#dateformat(i,"mm/dd/yyyy")# - #dateformat(dateAdd("d",6,i),"mm/dd/yyyy")#)
</cfloop></cfoutput>
</select
</td>
</tr>

But for some reason I only get one (first) of the 4 choices that user has has in his record selected. Does anybody know how can I make all his previous selections be selected in this drop down?

PLEASE HELP!

Thank you

 

[FALCONSEYE]

is your query get_request_info return more than 1 value?

http://www.jetansolutions.com

 

[olchik]

Hi FALCONSEYE,

Yes, this query may return up to 8 records, because user can select up to 8 options.

Thank you for your response!

 

[GUJUm0deL]

Put your get_request_info query into a list and then select the options based on that. This is how I did it in the past:

<cfquery name="getList" datasource="#DB#">
SELECT	 Table1_ID, Table1_Col1 Table1_Col2, Table1_Col3
FROM	 Table1
</cfquery>
<cfset GmCombine = valuelist(getList.Table1_ID)>
					
<select name="Table1_ID" size="10" multiple>
  <option value="">Please Select</option>
  <option value="">=================================================</option>
  
  <cfloop query="getList">
    <option value="#Table1_ID#" <cfif listfind(GmCombine, Table1_ID)>selected</cfif>>#Name#</option>
  </cfloop>
</select>

What I did was take the query and add the results into a list by its Table1_ID, then in the <select> I chose all id's that were in the GmCombine list.

Hope this makes sense.

My actual situation was different in that I had to loop over a SECOND query and select all options from the list I combined in the FIRST query. BUt the basic principle is the same.

____________________________________
Just Imagine.

http://www.imajinarts.com