Hi Deanna, This morning I just worked out what i had done wrong! It was that I had been putting the <option value=#articleID#> and not <option value=#authorID#> with my initial form.
Each article when CREATED the user gets a chance to link to other related articles. Once these articles are selected (in the form) they get inserted into a field called articleRelatedLinks as a list of the articleIDs. When an article is displayed it checks to see which articleIDs are related to the field articleReatedLinks and adds the links to the page. What is the normalised way of doing this? By a dynamic search? Excuse my limited knowledge. Thanks! :) ---------- Original Message ---------------------------------- From: "Deanna Schneider" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 16 Nov 2004 07:15:38 -0600 >Stuart, >I'm surprised no one has mentioned it yet, but I wouldn't recommend storing >a list in your database. I'd recommend figuring out the normalized way to do >it. I'm a bit confused as to what you're really storing. Is it that one >article is related to other articles? > >Back to the question at hand - are you sure there aren't any spaces in your >list? Have you tried this? >> <p>Article Related Links<br> >> >> <select name="articleRelatedLinks" multiple size="25"> >> <cfoutput query="showAllTitles"> >> <option value="#articleID#" <cfif >> ListFind(replace(showArticle.articleRelatedLinks, " ", ""), >> articleID)>selected</cfif>>#articleTitle#</option> >> </cfoutput> >> </select> >> >> </p> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184378 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
