Dynamic Multiple Select Menu - Multiple Options Selected 1

[peter11]

I am creating an edit page for coaches. I have a multiple select that generates and works fine. I am trying to make options in the menu "selected" according to a separate query (currentpos). The problem comes when the currentpos query generates more than one match (meaning two or more options should be selected). I tried to put a cfloop inside the option tag but that does not work.

<cfquery datasource="paper" name="pos">
select posname,posid from spcoachpos 
</cfquery>
						
<cfquery datasource="paper" name="currentPos">
select posid, userid from spCoachAssign
where userid = #eduser.userid# 
</cfquery>
						
<select name="posid" id="posid" multiple size = "6">
<option value = "0">None</option>
<cfloop query="pos">
<option [b]<cfloop query= "currentpos">[/b] <cfif pos.posid is currentpos.posid> selected </cfif> </cfloop> value="#pos.posid#" >  #pos.posname#</option>
</cfloop>
</select>

 

[r937]

what does "does not work" mean? crashes the server? issues an error message? hangs indefinitely? returns easy-to-prepare guacamole recipes?



r937.com | rudy.ca

 

[peter11]

Sorry,
no options are selected.
also when previewing in dreamweaver the cfloop tag I highlighted is orange instead of the burgandy that all cf tags are.

 

[r937]

try this --

<select name="posid" id="posid" 
    multiple size = "6">
<option value="0">None</option>
<cfloop query="pos">
[b]<cfset tempvariable=pos.posid>[/b]
<option 
  <cfloop query= "currentpos"> 
   <cfif currentpos.posid 
      eq [b]tempvariable[/b]> selected </cfif> 
  </cfloop> 
  value="#pos.posid#" 
    >  #pos.posname#</option>
</cfloop>
</select>

r937.com | rudy.ca