This seems like a possible bug but of course my code is always suspect. I am creating a series of select boxes from a query. These boxes are a list of possible categories to associate with an article. When I pull up an article, it should display select boxes for each associated category and have the correct category selected. For example, article 1 is associated with category Bo-L-1 and category Bo-S-2. So the drop down boxes should have these categories seleceted as well as listing all other possible categories. The code below works except that the select boxes all display the first category as the selected one even though the correct category displays outside of the select box. Any thoughts? Ian <CFLOOP QUERY="getArticleSubjects"> <TR> <TD> Category <CFOUTPUT>#Variables.subjectCount#: <!--- Display the current article category ---> #getArticleSubjects.CategoryCode#_#getArticleSubjects.SubcategoryCode#_#getArtic leSubjects.SubjectCode#</CFOUTPUT> <CFSELECT NAME="Category_#subjectCount#"> <OPTION VALUE=""></OPTION> <CFOUTPUT QUERY="Application.adminGetSubject"> <!--- Check to see if the current category in the list matches the current article category ---> <CFIF "#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubject.Subcate goryCode#_#Application.adminGetSubject.SubjectCode#" EQ "#getArticleSubjects.CategoryCode#_#getArticleSubjects.SubcategoryCode#_#getArti cleSubjects.SubjectCode#"> <OPTION VALUE="#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubject.S ubcategoryCode#_#Application.adminGetSubject.SubjectCode#" SELECTED>#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubject .SubcategoryCode#_#Application.adminGetSubject.SubjectCode#</OPTION> <CFELSE> <OPTION VALUE="#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubject.S ubcategoryCode#_#Application.adminGetSubject.SubjectCode#">#Application.adminGet Subject.CategoryCode#_#Application.adminGetSubject.SubcategoryCode#_#Application .adminGetSubject.SubjectCode#</OPTION> </CFIF> </CFOUTPUT> </CFSELECT> </TD> <TD COLSPAN="4"> <!--- Display the current article category names---> <CFOUTPUT>#getArticleSubjects.Category#_#getArticleSubjects.SubCategory#<CFIF getArticleSubjects.Subject NEQ "Z">_#getArticleSubjects.Subject#</CFIF></CFOUTPUT> </TD> </TR> <CFSET subjectCount = subjectCount + 1> </CFLOOP> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
