Yes, there is a space. I have tried this for two different queries with the
same results.
Ian
[EMAIL PROTECTED] wrote:
> Did you try putting a space before the word 'SELECTED' in your option tag?
> If not, I think that is your problem.
> HTH
> Jeff
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: None
> To: Fusebox
> Subject: Select box bug?
>
> 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#_#getA
> rtic
> 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.Sub
> cate
> goryCode#_#Application.adminGetSubject.SubjectCode#"
> EQ
>
"#getArticleSubjects.CategoryCode#_#getArticleSubjects.SubcategoryCode#_#get
> Arti
> cleSubjects.SubjectCode#">
> <OPTION
>
VALUE="#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubje
> ct.S
> ubcategoryCode#_#Application.adminGetSubject.SubjectCode#"
>
SELECTED>#Application.adminGetSubject.CategoryCode#_#Application.adminGetSub
> ject
> ..SubcategoryCode#_#Application.adminGetSubject.SubjectCode#</OPTION>
> <CFELSE>
> <OPTION
>
VALUE="#Application.adminGetSubject.CategoryCode#_#Application.adminGetSubje
> ct.S
>
ubcategoryCode#_#Application.adminGetSubject.SubjectCode#">#Application.admi
> nGet
>
Subject.CategoryCode#_#Application.adminGetSubject.SubcategoryCode#_#Applica
> tion
> ..adminGetSubject.SubjectCode#</OPTION>
> </CFIF>
> </CFOUTPUT>
> </CFSELECT>
> </TD>
> <TD COLSPAN="4">
> <!--- Display the current article category names--->
>
<CFOUTPUT>#getArticleSubjects.Category#_#getArticleSubjects.SubCategory#<CFI
> F
> 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
