Thanks for your help Jerry and Al! I'm still having that problem where it only finds a few of the numbers in the list. The field is set as a varchar(200) that shouldn't be a problem should it?
I broke the code down so it's easier to read and only specifically targets one particular row (just for my testing): <!-- gets all the article details--> <cfquery name="showArticle" datasource="user020"> SELECT * FROM tbl_020articleDetails WHERE articleID = 61 </cfquery> <!-- get all the titles of the articles --> <cfquery name="showAllTitles" datasource="user020"> SELECT articleID, articleTitle FROM tbl_020articleDetails </cfquery> <p>Article Related Links<br> <select name="articleRelatedLinks" multiple size="25"> <cfoutput query="showAllTitles"> <option value="#articleID#" <cfif ListFind(showArticle.articleRelatedLinks, articleID)>selected</cfif>>#articleTitle#</option> </cfoutput> </select> </p> The field articleRelatedLinks (row 61) has this information: 13,7,64,8,14,21,63,37,76,15 It's really bizzare how it is only picking up a few pieces of the list. Any help would be great, Thanks, Saturday. On 15/11/04 10:33 pm, "Jerry Johnson" <[EMAIL PROTECTED]> wrote: > You are almost there. Two problems. > > First, you are going to want listFind, rather than listContains, I think. > listContains is not an exact match. looking for "5" will find "5" and "35" and > "50". > Second, are there really spaces after the , in the list? If so, I think you'll > want to get rid of them. "5" will not match " 5" > > If you are still having problems, could you send the exact relatedLinks value, > and a couple of ID values to see if there is some reason they aren't matching? > > Thanks, > > > Jerry Johnson > Web Developer > Dolan Media Company > >>>> [EMAIL PROTECTED] 11/15/04 05:29PM >>> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:184344 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
