This content has been marked as final. Show 3 replies
A list of surname, firstname from the query SelectAll? You didn't specifiy your delimiter, so I'll use a pipe.
<cfset mylist = mylist & surname & ", " & firstname & "|">
not sure if you understood what i need,
i have 2 option values below, the second one should show a list of all surnames, firstname, but it actually only shows one, because i have a output query allready "SelectNames" i need to have another ie nested but this cant be done, so how esle can i do this
<option value="#SelectNames.PlayerID#" selected>#SelectNames.Surname#, #SelectNames.FirstName#</option>
<option value="#SelectALL.PlayerID#">#SelectALL.Surname#, #SelectALL.FirstName#</option>
> actually only shows one, because i have a output query allready
If you replace your second cfoutput tag with cfloop, you should be able to
overcome this particular problem.
use <cfloop query="SelectALL">
instead of <cfoutput query="SelectALL">