Thanks.. When I do that, I get Complex object types cannot be converted to simple values.
When I try the second solution, I get .. cannot convert the value of type class coldfusion.sql.QueryColumn to a boolean Any ideas? :) Dominic Watson wrote: > Hi Philip, instead of doing: > > <cfif 'positions.#Field#' EQ 0> > > Do: > > <cfif positions[field] EQ 0> > > Also, and this is personal preference, you can treat the 1 or 0 values as > booleans so you could also write it as: > > <cfif not positions[field]>...</cfif> or <cfif positions[field]>...</cfif> > > Dominic > > > > > > > On 01/01/2008, Phillip M. Vector <[EMAIL PROTECTED]> wrote: >> I'm trying to loop over a list of table columns and use the "selected" >> option on the select tag to set it yes or no based on the value.. But I >> can't seem to figure out how to do this as I can't indent a # within a # >> pair. >> >> Any ideas on how to make the check to see if it's 1 or 0 work? >> >> =============== >> <cfset count=0> >> <cfoutput query="Positions"> >> <cfset count=count + 1> >> <form action="#myself#Admin.ChangePermissions" >> method="post"> >> <tr> >> <td> >> #position# >> </td> >> <cfloop index = "Field" list = >> >> "DownloadGames,SeeSchedules,SeeStatus,SetStatus,EnterGames,SeeEmail,Employee,JobSettings"> >> <td> >> <select name="#Field#_#Count#"> >> <option value="1" >> <cfif >> 'positions.#Field#' EQ 1> >> Selected >> </cfif> >> >Yes >> </option> >> <option value="0" >> <cfif >> 'positions.#Field#' EQ 0> >> Selected >> </cfif> >> >No >> </option> >> </select> >> </td> >> </cfloop> >> <td> >> <input type="Text" >> Name="ListingOrder_#Count#" >> value="#Positions.ListingOrder#" size="3"> >> <input type="Hidden" Name="ID_#Count#" >> value="#Positions.id#"> >> </td> >> </tr> >> </cfoutput> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295670 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
