Re: list problem, displaying "CHECKED" listboxes
dammit...yeah, i was backwards. was a long night :) On Thu, 24 Mar 2005 01:34:18 -0500, Jim Davis <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 24, 2005 12:19 AM > > To: CF-Talk > > Subject: Re: list problem, displaying "CHECKED" listboxes > > > > you want to use listContains() instead of listFind(), I believe. > > I think that Charlie means the other way around, reversed, back-a-ward to > for-a-ward. You want to use ListFind() > > "ListContains()" returns true of the string exists in ANY of the list > elements: so "1", "2" and "12" are all contained in the list "12". > > However "ListFind()" matches the exact element - so "1" and "2" cannot be > found in the list "12" but "12" (obviously) can be. > > "Contains" in CF is always a content search, not a match (you can use > "Contains" as an evaluation operator as well). > > Jim Davis > > ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199888 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
RE: list problem, displaying "CHECKED" listboxes - SOLVED, thx
thanks Charlie, Jim that was it. Gil -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 1:34 AM To: CF-Talk Subject: RE: list problem, displaying "CHECKED" listboxes > -Original Message- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 12:19 AM > To: CF-Talk > Subject: Re: list problem, displaying "CHECKED" listboxes > > you want to use listContains() instead of listFind(), I believe. I think that Charlie means the other way around, reversed, back-a-ward to for-a-ward. You want to use ListFind() "ListContains()" returns true of the string exists in ANY of the list elements: so "1", "2" and "12" are all contained in the list "12". However "ListFind()" matches the exact element - so "1" and "2" cannot be found in the list "12" but "12" (obviously) can be. "Contains" in CF is always a content search, not a match (you can use "Contains" as an evaluation operator as well). Jim Davis ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199873 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
RE: list problem, displaying "CHECKED" listboxes
> -Original Message- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 12:19 AM > To: CF-Talk > Subject: Re: list problem, displaying "CHECKED" listboxes > > you want to use listContains() instead of listFind(), I believe. I think that Charlie means the other way around, reversed, back-a-ward to for-a-ward. You want to use ListFind() "ListContains()" returns true of the string exists in ANY of the list elements: so "1", "2" and "12" are all contained in the list "12". However "ListFind()" matches the exact element - so "1" and "2" cannot be found in the list "12" but "12" (obviously) can be. "Contains" in CF is always a content search, not a match (you can use "Contains" as an evaluation operator as well). Jim Davis ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199861 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
Re: list problem, displaying "CHECKED" listboxes
you want to use listContains() instead of listFind(), I believe. On Wed, 23 Mar 2005 23:56:09 -0500, mayo <[EMAIL PROTECTED]> wrote: > I'm creating an admin section where users can select from a series of > checkboxes (for example itemColor or itemSize). > > When I examine the db I see there was no problem inserting the data via the > checkboxes. However I'm having problems in the "edit" screen when I want to > show the user the selected items. > > Example: user selects white and black > > [X]White > [X]Black > [ ]Red > [ ]Green > [ ]Blue > > White and Black are inserted correctly. In the edit screen I would like the > user to see the itemColors selected. Everything works well EXCEPT when the > checked item is greater than 10. > > For example: user select Polka Dots > > 1. [ ]White > 2. [ ]Black > 3. [ ]Red > 4. [ ]Green > 5. [ ]Blue > > 12.[X]Polka Dots > > It's inserted correctly into the table > > itemColors > itemID=123 > itemColor=12 > > However it's displayed as Black, White and Polka Dots > > 1. [X]White > 2. [X]Black > 3. [ ]Red > 4. [ ]Green > 5. [ ]Blue > > 12.[X]Polka Dots > > 1,2, and 12 are shown as selected. If 13 Blue Stripes was selected then > 1,3, and 13 would be displayed. > > The relevant tables are > > items (name,desc,etc...) and > itemColors(itemID, itemColorID) > > When updates to the colors are made first all rows associated with the > itemID are deleted then new rows are inserted. This works as expected. > > The relevant code is below. I just don't see what I'm missing. > > > > listContains(valueList(getItemColors.colorID),colorID)>CHECKED > >#colorName# > > > > > > > > SELECT items.*, itemType.*, categories.*,designers.* > FROM items,itemType,categories,designers > WHERE > items.itemID=#ID# AND > items.categoryID = categories.categoryID AND > items.itemTypeID = itemType.itemTypeID AND > items.designerID = designers.designerID > > > > > > SELECT * > FROM itemColors > WHERE itemID = #ID# > > > > > SELECT * > FROM itemSizes > WHERE itemID = #ID# > > > > > > Gil > > ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199860 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
list problem, displaying "CHECKED" listboxes
I'm creating an admin section where users can select from a series of checkboxes (for example itemColor or itemSize). When I examine the db I see there was no problem inserting the data via the checkboxes. However I'm having problems in the "edit" screen when I want to show the user the selected items. Example: user selects white and black [X]White [X]Black [ ]Red [ ]Green [ ]Blue White and Black are inserted correctly. In the edit screen I would like the user to see the itemColors selected. Everything works well EXCEPT when the checked item is greater than 10. For example: user select Polka Dots 1. [ ]White 2. [ ]Black 3. [ ]Red 4. [ ]Green 5. [ ]Blue 12.[X]Polka Dots It's inserted correctly into the table itemColors itemID=123 itemColor=12 However it's displayed as Black, White and Polka Dots 1. [X]White 2. [X]Black 3. [ ]Red 4. [ ]Green 5. [ ]Blue 12.[X]Polka Dots 1,2, and 12 are shown as selected. If 13 Blue Stripes was selected then 1,3, and 13 would be displayed. The relevant tables are items (name,desc,etc...) and itemColors(itemID, itemColorID) When updates to the colors are made first all rows associated with the itemID are deleted then new rows are inserted. This works as expected. The relevant code is below. I just don't see what I'm missing. CHECKED >#colorName# SELECT items.*, itemType.*, categories.*,designers.* FROM items,itemType,categories,designers WHERE items.itemID=#ID# AND items.categoryID = categories.categoryID AND items.itemTypeID = itemType.itemTypeID AND items.designerID = designers.designerID SELECT * FROM itemColors WHERE itemID = #ID# SELECT * FROM itemSizes WHERE itemID = #ID# Gil ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199858 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
Re: If "x" is in a list problem - What worked..
This did it: checked="checked" Thanks for the pointers... -- Les Mizzell -- Certe, toto, sentio nos in kansate non iam adesse -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: If "x" is in a list problem
listFind() and listFindNoCase() look for exact matches, listContains() and listContainsNoCase() look for substrings. A quick way to keep them straight is remember that listContains() works like the contains comparison operator. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: If "x" is in a list problem
Or use ListFind()LOL - forgot about that one. At 04:49 PM 8/5/2004, you wrote: >This what you mean? > > > > > > > > > > > >Ray > > >At 04:38 PM 8/5/2004, you wrote: > >I'm using this to preselect checkboxes: > > > >checked="checked" > > > >...but that ain't correct - because it needs to return true ONLY if the > >entire string in the list = "3". > > > >Currently, "37" or "43" would return true as well. > > > >So, for a string of "3,33,43,73" how do I get it to return true for ONLY > >"3"? > > > >I'm a little unclear as to the exact syntax... > > > >-- > >Les Mizzell > >-- > >Certe, toto, sentio nos in kansate non iam adesse > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: If "x" is in a list problem
This what you mean? Ray At 04:38 PM 8/5/2004, you wrote: >I'm using this to preselect checkboxes: > >checked="checked" > >...but that ain't correct - because it needs to return true ONLY if the >entire string in the list = "3". > >Currently, "37" or "43" would return true as well. > >So, for a string of "3,33,43,73" how do I get it to return true for ONLY >"3"? > >I'm a little unclear as to the exact syntax... > >-- >Les Mizzell >-- >Certe, toto, sentio nos in kansate non iam adesse > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: If "x" is in a list problem
On Thu, 05 Aug 2004 16:38:28 -0400, Les Mizzell <[EMAIL PROTECTED]> wrote: > I'm using this to preselect checkboxes: > > checked="checked" > > but that ain't correct - because it needs to return true ONLY if the > entire string in the list = "3". > > Currently, "37" or "43" would return true as well. > > So, for a string of "3,33,43,73" how do I get it to return true for ONLY > "3"? > > I'm a little unclear as to the exact syntax... Use ListFind(). Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
If "x" is in a list problem
I'm using this to preselect checkboxes: checked="checked" ...but that ain't correct - because it needs to return true ONLY if the entire string in the list = "3". Currently, "37" or "43" would return true as well. So, for a string of "3,33,43,73" how do I get it to return true for ONLY "3"? I'm a little unclear as to the exact syntax... -- Les Mizzell -- Certe, toto, sentio nos in kansate non iam adesse -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: [Reply To] RE: list problem
I forgot to say this is CFMX only > -Original Message- > From: Seamus Campbell [mailto:[EMAIL PROTECTED] > Sent: zondag 20 juni 2004 10:04 > To: CF-Talk > Subject: [Reply To] RE: list problem > > many thanks > Seamus > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
[Reply To] RE: list problem
many thanks Seamus You wrote text = REReplace(text,"\^[ \t]*(?=([\r\n]|$))","^N/A","all"); >> >>> -Original Message- >>> From: Seamus Campbell [mailto:[EMAIL PROTECTED] >>> Sent: zondag 20 juni 2004 7:55 >>> To: CF-Talk >>> Subject: list problem >>> >>> Hi >>> >>> I have a list I'm trying to read with cffile >>> >>> The list items sometimes have a binding code in the last >>> field and sometimes nothing. So its read as having either 7 >>> or 8 fields. >>> So I'm trying to insert "N/A" in the last field when nothing >>> is there === >>> AN^Apr04-^1^Bonyhady, Tim and Griffiths, Tom (eds.).^ Prehistory to >>> Politics: John Mulvaney, the Humanities and the Public >>> Intellectual. ^Mulvaney, one of Australia's best known >>> prehistorians, has been an influential figure in public >>> debate and public policy about world heritage, archaeological >>> and conservation practice, the function and operation of >>> museums, and the relevance of the humanities. * R.P. $32.95 >>> now $^7.95^ paper AN^Apr04-^2^De Waal, Frans.^ The Ape >>> and the Sushi Master: Cultural Reflections by a >>> Primatologist. ^The author examines the influence of European >>> ethology and Japanese primatology on the way in which we >>> regard other animals, the possibility of non-human culture >>> within the animal world, and our perceptions of the human >>> race. * R.P. $49.95 now $^19.95^ AN^Apr04-^3^Elliott, >>> Anthony.^ The Mourning of John Lennon. >>> ^Examines the life, works, death and iconic status of this >>> most iconoclastic former Beatle, and discusses the psychology >>> of "celebrity". * R.P. $27.95 now $^7.95^ paper >>> AN^Apr04-^4^Frost, Ginger S.^ Promises Broken: Courtship, >>> Class, and Gender in Victorian England. ^The first part >>> concentrates on legal issues. The second part delves into the >>> social issues of the action - e.g. detailing the gender >>> expectations that strongly influenced the verdicts and >>> reasons for broken engagements. The third part explores >>> various cultural ramifications for the action among the >>> elite. Reveals the nuances of courtship, marriage and common >>> law in Victorian England. R.P. $70.00 now $^14.95^ >>> === >>> Records 1 and 3 have paper as the last field but 2 and 4 have >>> nothing . >>> >>> Any ideas on how I can do this >>> >>> Many thanks >>> Seamus >>> >>> >>> Seamus Campbell Boldacious WebDesign >>> http://www.boldacious.com [EMAIL PROTECTED] >>> ph 02 6297 4883 mob 0410 609 267 >>> >>> >>> >>> >> >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: list problem
OK, and...? Paul Kenney [EMAIL PROTECTED] 916-212-4359 > -Original Message- > From: Seamus Campbell [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 19, 2004 10:55 PM > To: CF-Talk > Subject: list problem > > > Hi > > I have a list I'm trying to read with cffile > > The list items sometimes have a binding code in the last field > and sometimes nothing. So its read as having either 7 or 8 fields. > So I'm trying to insert "N/A" in the last field when nothing is > there > === > AN^Apr04-^1^Bonyhady, Tim and Griffiths, Tom (eds.).^ Prehistory to > Politics: John Mulvaney, the Humanities and the Public > Intellectual. ^Mulvaney, one of Australia's best known > prehistorians, has been an influential figure in public debate and > public policy about world heritage, archaeological and > conservation practice, the function and operation of museums, and > the relevance of the humanities. * R.P. $32.95 now $^7.95^ > paper > AN^Apr04-^2^De Waal, Frans.^ The Ape and the Sushi Master: Cultural > Reflections by a Primatologist. ^The author examines the influence > of European ethology and Japanese primatology on the way in which > we regard other animals, the possibility of non-human culture > within the animal world, and our perceptions of the human race. * > R.P. $49.95 now $^19.95^ > AN^Apr04-^3^Elliott, Anthony.^ The Mourning of John Lennon. > ^Examines the life, works, death and iconic status of this most > iconoclastic former Beatle, and discusses the psychology of > "celebrity". * R.P. $27.95 now $^7.95^ paper > AN^Apr04-^4^Frost, Ginger S.^ Promises Broken: Courtship, Class, > and Gender in Victorian England. ^The first part concentrates on > legal issues. The second part delves into the social issues of the > action - e.g. detailing the gender expectations that strongly > influenced the verdicts and reasons for broken engagements. The > third part explores various cultural ramifications for the action > among the elite. Reveals the nuances of courtship, marriage and > common law in Victorian England. R.P. $70.00 now > $^14.95^ > === > Records 1 and 3 have paper as the last field but 2 and 4 have > nothing . > > Any ideas on how I can do this > > Many thanks > Seamus > > > Seamus Campbell Boldacious WebDesign > http://www.boldacious.com [EMAIL PROTECTED] > ph 02 6297 4883 mob 0410 609 267 > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
list problem
Hi I have a list I'm trying to read with cffile The list items sometimes have a binding code in the last field and sometimes nothing. So its read as having either 7 or 8 fields. So I'm trying to insert "N/A" in the last field when nothing is there === AN^Apr04-^1^Bonyhady, Tim and Griffiths, Tom (eds.).^ Prehistory to Politics: John Mulvaney, the Humanities and the Public Intellectual. ^Mulvaney, one of Australia's best known prehistorians, has been an influential figure in public debate and public policy about world heritage, archaeological and conservation practice, the function and operation of museums, and the relevance of the humanities. * R.P. $32.95 now $^7.95^ paper AN^Apr04-^2^De Waal, Frans.^ The Ape and the Sushi Master: Cultural Reflections by a Primatologist. ^The author examines the influence of European ethology and Japanese primatology on the way in which we regard other animals, the possibility of non-human culture within the animal world, and our perceptions of the human race. * R.P. $49.95 now $^19.95^ AN^Apr04-^3^Elliott, Anthony.^ The Mourning of John Lennon. ^Examines the life, works, death and iconic status of this most iconoclastic former Beatle, and discusses the psychology of "celebrity". * R.P. $27.95 now $^7.95^ paper AN^Apr04-^4^Frost, Ginger S.^ Promises Broken: Courtship, Class, and Gender in Victorian England. ^The first part concentrates on legal issues. The second part delves into the social issues of the action - e.g. detailing the gender expectations that strongly influenced the verdicts and reasons for broken engagements. The third part explores various cultural ramifications for the action among the elite. Reveals the nuances of courtship, marriage and common law in Victorian England. R.P. $70.00 now $^14.95^ === Records 1 and 3 have paper as the last field but 2 and 4 have nothing . Any ideas on how I can do this Many thanks Seamus Seamus Campbell Boldacious WebDesign http://www.boldacious.com [EMAIL PROTECTED] ph 02 6297 4883 mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: drop-down list problem
The table had doubles and I did not bother to look. Thanks. RO -Original Message- From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, June 14, 2004 11:31 AM To: CF-Talk Subject: Re: drop-down list problem On Mon, 14 Jun 2004 11:22:36 -0400, Robert Orlini wrote: > > I have a dynamic dropdown list that gets a statecode from a table and then compares to what is sent via form tag. It displays the state in the tag as selected along with other states that can be chosen in the dropdown. Its all OK, except it displays all the states twice. Any help with the code would be appreciated; here it is: > > > > Selected>#left(trim(statename),15)# > > There's nothing in your code to indicate why you're getting doubles - before you run this code, can you CFDUMP the getStates query to make sure that it's not got the doubles within it? Oh, and get rid of the double SIZE attribute in the SELECT - either it's size 1 or it's size 20... which is it? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: drop-down list problem
I don't see anything wrong with your code - I bet the issue is your query. If you cfdump your query before this code, do you see 2 of each state? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: drop-down list problem
On Mon, 14 Jun 2004 11:22:36 -0400, Robert Orlini wrote: > > I have a dynamic dropdown list that gets a statecode from a table and then compares to what is sent via form tag. It displays the state in the tag as selected along with other states that can be chosen in the dropdown. Its all OK, except it displays all the states twice. Any help with the code would be appreciated; here it is: > > > > Selected>#left(trim(statename),15)# > > There's nothing in your code to indicate why you're getting doubles - before you run this code, can you CFDUMP the getStates query to make sure that it's not got the doubles within it? Oh, and get rid of the double SIZE attribute in the SELECT - either it's size 1 or it's size 20... which is it? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
drop-down list problem
I have a dynamic dropdown list that gets a statecode from a table and then compares to what is sent via form tag. It displays the state in the tag as selected along with other states that can be chosen in the dropdown. Its all OK, except it displays all the states twice. Any help with the code would be appreciated; here it is: Selected>#left(trim(statename),15)# Thanks. Robert at HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Help With List Problem
there may be a better appraoch to this. would you please explain what you really want in more detail. like why are there 3 items in list 2, and you only talked about dealing with the first 2 items??? >From: "Double Down" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Help With List Problem >Date: Fri, 7 Dec 2001 12:10:49 -0800 > >I have two lists that I need to compare. List one is a comma delimited >list pulled from a record in the database (1,2,3) List two is comma >delimited but has two values separated by a semi-colon that is an >application variable (1;yes,2;no,3;maybe). The problem I am having is >that I want to compare list1 with the first value in list2, if list1 >matches list2 I would like to display the second value of list2. > >This is the code that I have written: > > > > > > > > > > >This code finds the first element in list1 and list2 and displays the >second value in list2 properly and that is all. It is not displaying any >of the other values because it cannot find them, even though they are >in list1 and the first value in list2. > >If anyone can help me out with this I would really appreciate it. > >Thanks > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help With List Problem
Well, lets draw out your lists, and the problem is obvious. You search in list2 with a delimeter of ";", so your list looks like... 1 yes,2 no,3 maybe If you want more, just ask... Jerry Johnson >>> [EMAIL PROTECTED] 12/07/01 03:10PM >>> I have two lists that I need to compare. List one is a comma delimited list pulled from a record in the database (1,2,3) List two is comma delimited but has two values separated by a semi-colon that is an application variable (1;yes,2;no,3;maybe). The problem I am having is that I want to compare list1 with the first value in list2, if list1 matches list2 I would like to display the second value of list2. This is the code that I have written: This code finds the first element in list1 and list2 and displays the second value in list2 properly and that is all. It is not displaying any of the other values because it cannot find them, even though they are in list1 and the first value in list2. If anyone can help me out with this I would really appreciate it. Thanks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help With List Problem
I have two lists that I need to compare. List one is a comma delimited list pulled from a record in the database (1,2,3) List two is comma delimited but has two values separated by a semi-colon that is an application variable (1;yes,2;no,3;maybe). The problem I am having is that I want to compare list1 with the first value in list2, if list1 matches list2 I would like to display the second value of list2. This is the code that I have written: This code finds the first element in list1 and list2 and displays the second value in list2 properly and that is all. It is not displaying any of the other values because it cannot find them, even though they are in list1 and the first value in list2. If anyone can help me out with this I would really appreciate it. Thanks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists