Re: Looping through lists
Why not write ONE query and loop thru your database and add a row to a NEW table related to a key in your table with the keywords in a delimited list for each keyword extracted from the list. You do this once and then you can search the keywords table to get your results. Terry Troxel - Original Message - From: Chris Geanious <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, August 22, 2001 8:58 AM Subject: RE: Looping through lists > Hi Nick and all who have responded, > Thanx for the input. I am sure I will be able to make this work with all > your help. > > I inherited the DB. Would love to have the keywords in seperate cells, but... > > Actually, it is an EndNote reference library that I converted to an Access db. > If anyone has had any experience with EndNote you might want to weigh in here. > > Thanx again to all who replied. I will post back with what I come up with. > > Chris > > At 10:34 AM 8/22/2001 +0100, you wrote: > >Chris, > > > >This isn't what you want to hear, but really your database design > >needs changing so that each keyword is in a separate row. > > > >If that's not an option, you could read the list of keywords > >and do a ListFindNoCase() on it. That will be incredibly slow though, > >if you do it for every entry in a large database. > > > >Nick > > > >-Original Message- > >From: Chris Geanious [mailto:[EMAIL PROTECTED]] > >Sent: Wednesday, August 22, 2001 5:01 AM > >To: CF-Talk > >Subject: Looping through lists > > > > > >Greetings, > >Am constructing a db search using (among other things) a form text area for > >keywords. In the data base there is a KeyWords field which contains a > >comma delimited list of keywords for each entry. > > > >I have a query which loops over the form text box entries. How do I then > >loop over the database keyword fields to check for a match? I am a little > >stuck. Any suggestions, code snippets, links to sites would be greatly > >appreciated. > > > >TIA, > > > >Chris > >== > >Chris Geanious > >Support Systems Analyst Senior > >Institute For Human Development > >Northern Arizona University > > > > > >** > >Information in this email is confidential and may be privileged. > >It is intended for the addressee only. If you have received it in error, > >please notify the sender immediately and delete it from your system. > >You should not otherwise copy it, retransmit it or use or disclose its > >contents to anyone. > >Thank you for your co-operation. > >** > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Hi Nick and all who have responded, Thanx for the input. I am sure I will be able to make this work with all your help. I inherited the DB. Would love to have the keywords in seperate cells, but... Actually, it is an EndNote reference library that I converted to an Access db. If anyone has had any experience with EndNote you might want to weigh in here. Thanx again to all who replied. I will post back with what I come up with. Chris At 10:34 AM 8/22/2001 +0100, you wrote: >Chris, > >This isn't what you want to hear, but really your database design >needs changing so that each keyword is in a separate row. > >If that's not an option, you could read the list of keywords >and do a ListFindNoCase() on it. That will be incredibly slow though, >if you do it for every entry in a large database. > >Nick > >-Original Message- >From: Chris Geanious [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 22, 2001 5:01 AM >To: CF-Talk >Subject: Looping through lists > > >Greetings, >Am constructing a db search using (among other things) a form text area for >keywords. In the data base there is a KeyWords field which contains a >comma delimited list of keywords for each entry. > >I have a query which loops over the form text box entries. How do I then >loop over the database keyword fields to check for a match? I am a little >stuck. Any suggestions, code snippets, links to sites would be greatly >appreciated. > >TIA, > >Chris >== >Chris Geanious >Support Systems Analyst Senior >Institute For Human Development >Northern Arizona University > > >** >Information in this email is confidential and may be privileged. >It is intended for the addressee only. If you have received it in error, >please notify the sender immediately and delete it from your system. >You should not otherwise copy it, retransmit it or use or disclose its >contents to anyone. >Thank you for your co-operation. >** > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Chris, I agree with some of the other comments that your database design might need some work, but as an answer to your question I'll propose this. Say your form has a field called FORM.strKeywords which is the field in which the user will type a set of keywords separated by spaces. Here's what you'll want to do on the page that the search form submits to: SELECT id , strName , strKeywords FROM tblYourTableName WHERE 1=1 AND strKeywords LIKE '%#keyword#%' Of course, this will only find records which match ALL of the keywords a user entered. I think you should be able to figure out how to adapt this to finding ANY matching records if that's what you wanted. Hope this helps, Tyson Tyson Vanek, Technical Lead duoDesign, The eBusiness Architects Building your business online 847.491.3000 main | [EMAIL PROTECTED] 847.491.3100 fax | www.duodesign.com 847.491.4270 direct | www.chicagoangels.org Come to our free 2-hour seminar "The eBusiness Squeeze" http://www.duodesign.com/squeeze/seminar.html -Original Message- From: Chris Geanious [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 11:01 PM To: CF-Talk Subject: Looping through lists Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
This may be an example of what you are looking for: === Qry: Populate_job_Function - selects possible codes and descriptions - codes are comma delimited in tbl: gt_resumes.discipline field in Qry: Demographic_display === select code, description from gen_tables where table_name='functions' order by description === select discipline from gt_resumes where gt_resumes.id=#client.id# === checks tbl: gt_resumes.discipline field for values in tbl: gen_tables and returns corresponding descriptions === #populate_job_function.description#; #populate_job_function.description#; JoAnn A. Schlosser Senior Consultant Association Management Software Grant Thornton LLP Washington, D. C. 703.837.4428 -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 5:34 AM To: CF-Talk Subject: RE: Looping through lists Chris, This isn't what you want to hear, but really your database design needs changing so that each keyword is in a separate row. If that's not an option, you could read the list of keywords and do a ListFindNoCase() on it. That will be incredibly slow though, if you do it for every entry in a large database. Nick -Original Message- From: Chris Geanious [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 5:01 AM To: CF-Talk Subject: Looping through lists Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
On 8/22/01, Bud penned: Then: WHERE somefield = '#somevalue#' and ( OOPS. Extra "(" --->(keywords LIKE ',#Trim(mycriteria)#,' OR 0=1) Take that out and try it. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
On 8/21/01, Chris Geanious penned: >Greetings, >Am constructing a db search using (among other things) a form text area for >keywords. In the data base there is a KeyWords field which contains a >comma delimited list of keywords for each entry. > >I have a query which loops over the form text box entries. How do I then >loop over the database keyword fields to check for a match? I am a little >stuck. Any suggestions, code snippets, links to sites would be greatly >appreciated. There's really no way that I know of to loop over a field in a database without first pulling out the data and looping over that. Since you are using a comma delimited list, I'd add a comma to the beginning and end of the field on the insert so it looks like: ,keyword1,keyword or phrase,keyword3,etc, Then: WHERE somefield = '#somevalue#' and ( (keywords LIKE ',#Trim(mycriteria)#,' OR 0=1) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Interesting, Chris, I usually use SQL statment as the following: SELECT * FROM dbname WHERE keywords LIKE '%#FORM.QUERY#%' That means, select all columns from dbname where keywords field contains the value of #FORM.QUERY#. % signs means, any set of charachters Regards, Hamid Hossain --- Chris Geanious <[EMAIL PROTECTED]> wrote: > Greetings, > Am constructing a db search using (among other > things) a form text area for > keywords. In the data base there is a KeyWords > field which contains a > comma delimited list of keywords for each entry. > > I have a query which loops over the form text box > entries. How do I then > loop over the database keyword fields to check for a > match? I am a little > stuck. Any suggestions, code snippets, links to > sites would be greatly > appreciated. > > TIA, > > Chris > == > Chris Geanious > Support Systems Analyst Senior > Institute For Human Development > Northern Arizona University > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Why not use Verity ? -Original Message- From: Chris Geanious [mailto:[EMAIL PROTECTED]] Sent: 22 August 2001 05:01 To: CF-Talk Subject: Looping through lists Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Chris, This isn't what you want to hear, but really your database design needs changing so that each keyword is in a separate row. If that's not an option, you could read the list of keywords and do a ListFindNoCase() on it. That will be incredibly slow though, if you do it for every entry in a large database. Nick -Original Message- From: Chris Geanious [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 5:01 AM To: CF-Talk Subject: Looping through lists Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
Looping through lists
Greetings, Am constructing a db search using (among other things) a form text area for keywords. In the data base there is a KeyWords field which contains a comma delimited list of keywords for each entry. I have a query which loops over the form text box entries. How do I then loop over the database keyword fields to check for a match? I am a little stuck. Any suggestions, code snippets, links to sites would be greatly appreciated. TIA, Chris == Chris Geanious Support Systems Analyst Senior Institute For Human Development Northern Arizona University ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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: Looping through lists
Jon, Here is what I have done for that issue. Session.BasketItems hold the unique ID number for the SKU (Products) and Session.BasketCount is the associated list of quantities for each item. Or to put it another way listProducts=Session.BasketItems and listQuantity=Session.BasketCount SELECT SKU_ID, SKU_NO, SKU_SHORTDESC, SKU_LONGDESC, SKU_COLOR, SKU_LIST, SKU_SALE, SKU_RATINGS, SKU_WEIGHT FROM SKUTable WHERE 0=0 and (0 = 1 OR SKU_ID = #ii# ) #SKU_NO# - #SKU_QTY# Best Regards, Dennis Powers UXB Internet (203)879-2844 http://www.uxbinfo.com -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 01, 2000 10:17 AM To: [EMAIL PROTECTED] Subject: Re: Looping through lists I have two lists, listProducts and listQuantity. I want to do the following: For each productID in listProducts, do a search that returns all the relevant info about the product, display it in a table, and add the quantity listed in listQuantity. What I need to know is how to make sure that listQuantity returns only one value for each iteration of the CFOUTPUT loop. any ideas? If this makes no sense at all, let me know and I will email you what I have so far, by way of explanation. -- This Email is 100% Virus Free! How do I know? Because no Microsoft products were used to generate it! ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_tal k or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through lists
> I have: > productlist = "1,2,3,4" > quantitylist = "2,1,1,1" > > and i want to > > SELECT tblProduct.*, > tblProductSize.productsizeSize, > tblProductWeight.productweightWeight, > tblProductColor.productcolorColor > FROM((tblProduct > LEFT JOIN tblProductColor > ON tblProduct.productId = tblProductColor.productcolorProductId) > LEFT JOIN tblProductSize > ON tblProduct.productId = tblProductSize.productsizeProductId) > LEFT JOIN tblProductWeight > ON tblProduct.productId = tblProductWeight.productweightProductId > where tblProduct.productId IN (#ShoppingCart_Product#); > > and then to output: > > > > #productname# > #productDesc# > etc... > QUANTITY GOES HERE > > > > I want to add a to the table row that include the quantity of > the product, as contained in quantitylist IF ShoppingCart_Product is the same as productlist then just do > > #productname# > #productDesc# > etc... > #ListGetAt(quantitylist,ListFind(productlist ,productId))# > > ~Justin > > ::: > Jon Tillman > LINUX USER: #141163 > ICQ: 4015362 > [EMAIL PROTECTED] > http://tillman.freehosting.net > ::: > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through lists
On Tue, 01 Aug 2000, JustinMacCarthy spewed forth into the void: > Assuming you have > > > namelist = "tom,dick,harry" > IDlist = "1,2,3" > > and you want to > > select id, some_col from table where id in (#idlist#) > > > output is > > id some_col > 2 textorsomething > 3 textorsomething > > then you chould do > > > > #listgetat(namelist,listfind(idlist,id,))# #some_col# > > > > ugly but ... > > ~justin > I have: productlist = "1,2,3,4" quantitylist = "2,1,1,1" and i want to SELECT tblProduct.*, tblProductSize.productsizeSize, tblProductWeight.productweightWeight, tblProductColor.productcolorColor FROM((tblProduct LEFT JOIN tblProductColor ON tblProduct.productId = tblProductColor.productcolorProductId) LEFT JOIN tblProductSize ON tblProduct.productId = tblProductSize.productsizeProductId) LEFT JOIN tblProductWeight ON tblProduct.productId = tblProductWeight.productweightProductId where tblProduct.productId IN (#ShoppingCart_Product#); and then to output: #productname# #productDesc# etc... QUANTITY GOES HERE I want to add a to the table row that include the quantity of the product, as contained in quantitylist ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through lists
Assuming you have namelist = "tom,dick,harry" IDlist = "1,2,3" and you want to select id, some_col from table where id in (#idlist#) output is id some_col 2 textorsomething 3 textorsomething then you chould do #listgetat(namelist,listfind(idlist,id,))# #some_col# ugly but ... ~justin - Original Message - From: "Jon Tillman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 01, 2000 4:53 PM Subject: RE: Looping through lists > So, what if I wanted to do the following: > create a loop that would take two lists, perform the query on all the values > in one of them, output the formatted results of those queries, but insert the > values from the second list, one for each query returned? > > On Tue, 01 Aug 2000, Anthony Geoghegan spewed forth into the void: > > Hi Jon, > > > > Jon Wrote: > > |Hey, I need to figure out how to loop though a list and > > |perform a query for > > |each value returned in the list. Any ideas? > > > > You can get a query to select all the records with an entry contained in a > > comma delimited list so: > > > > > > SELECT stuff FROM stuff_list > > WHERE stuff_id IN (#stuff_id_list#) > > > > > > Regards, > > Anthony Geoghegan > > Lead Developer > > Ireland Film and Television Net > > 26 South Frederick Street > > Dublin 2 > > Ireland > > Tel: +353 1 671 3664 > > Fax: +353 1 671 0763 > > Web: www.iftn.ie www.wow.ie > > mailto:[EMAIL PROTECTED] > > > > NOTICE: > > This communication is confidential. The copyright in this communication > > belongs to Ireland Film & Television Net (IFTN) or a third party. > > > > If you are not the intended recipient of this communication please delete > > and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. > > If you are the intended recipient of this communication you should not copy, > > disclose or distribute this communication without the authority of IFTN. > > > > Any views expressed in this communication are those of the individual sender > > except where the sender specifically states those are of view of IFTN. > > > > Except as required by law IFTN does not represent, warrant, and/guarantee > > that the integrity of this communication has been maintained or that the > > communication is free of virus, interception or interference. > > > > > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- > This Email is 100% Virus Free! How do I know? > Because no Microsoft products were used to > generate it! > > ::: > Jon Tillman > LINUX USER: #141163 > ICQ: 4015362 > [EMAIL PROTECTED] > http://tillman.freehosting.net > ::: > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Looping through lists
So, what if I wanted to do the following: create a loop that would take two lists, perform the query on all the values in one of them, output the formatted results of those queries, but insert the values from the second list, one for each query returned? On Tue, 01 Aug 2000, Anthony Geoghegan spewed forth into the void: > Hi Jon, > > Jon Wrote: > |Hey, I need to figure out how to loop though a list and > |perform a query for > |each value returned in the list. Any ideas? > > You can get a query to select all the records with an entry contained in a > comma delimited list so: > > > SELECT stuff FROM stuff_list > WHERE stuff_id IN (#stuff_id_list#) > > > Regards, > Anthony Geoghegan > Lead Developer > Ireland Film and Television Net > 26 South Frederick Street > Dublin 2 > Ireland > Tel: +353 1 671 3664 > Fax: +353 1 671 0763 > Web: www.iftn.ie www.wow.ie > mailto:[EMAIL PROTECTED] > > NOTICE: > This communication is confidential. The copyright in this communication > belongs to Ireland Film & Television Net (IFTN) or a third party. > > If you are not the intended recipient of this communication please delete > and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. > If you are the intended recipient of this communication you should not copy, > disclose or distribute this communication without the authority of IFTN. > > Any views expressed in this communication are those of the individual sender > except where the sender specifically states those are of view of IFTN. > > Except as required by law IFTN does not represent, warrant, and/guarantee > that the integrity of this communication has been maintained or that the > communication is free of virus, interception or interference. > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- This Email is 100% Virus Free! How do I know? Because no Microsoft products were used to generate it! ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through lists
On Tue, 01 Aug 2000, peter spewed forth into the void: > > > select * > from stillAtWork > where somevalue = #currItemInList# > and salary < #peanuts# > order by salary > > > > #xyz# > > > > Thanks, that works well. I have one more question (for the time being). It has to do with displaying the output of the above. I have two lists, listProducts and listQuantity. I want to do the following: For each productID in listProducts, do a search that returns all the relevant info about the product, display it in a table, and add the quantity listed in listQuantity. What I need to know is how to make sure that listQuantity returns only one value for each iteration of the CFOUTPUT loop. any ideas? If this makes no sense at all, let me know and I will email you what I have so far, by way of explanation. -- This Email is 100% Virus Free! How do I know? Because no Microsoft products were used to generate it! ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Looping through lists
Hi Jon, Jon Wrote: |Hey, I need to figure out how to loop though a list and |perform a query for |each value returned in the list. Any ideas? You can get a query to select all the records with an entry contained in a comma delimited list so: SELECT stuff FROM stuff_list WHERE stuff_id IN (#stuff_id_list#) Regards, Anthony Geoghegan Lead Developer Ireland Film and Television Net 26 South Frederick Street Dublin 2 Ireland Tel: +353 1 671 3664 Fax: +353 1 671 0763 Web: www.iftn.ie www.wow.ie mailto:[EMAIL PROTECTED] NOTICE: This communication is confidential. The copyright in this communication belongs to Ireland Film & Television Net (IFTN) or a third party. If you are not the intended recipient of this communication please delete and destroy all copies and telephone IFTN on +353 1 671 3664 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of IFTN. Any views expressed in this communication are those of the individual sender except where the sender specifically states those are of view of IFTN. Except as required by law IFTN does not represent, warrant, and/guarantee that the integrity of this communication has been maintained or that the communication is free of virus, interception or interference. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Looping through lists
select * from stillAtWork where somevalue = #currItemInList# and salary < #peanuts# order by salary #xyz# - Original Message - From: "Jon Tillman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 31, 2000 10:50 PM Subject: Looping through lists > Hey, I need to figure out how to loop though a list and perform a query for > each value returned in the list. Any ideas? > > -- > This Email is 100% Virus Free! How do I know? > Because no Microsoft products were used to > generate it! > > ::: > Jon Tillman > LINUX USER: #141163 > ICQ: 4015362 > [EMAIL PROTECTED] > http://tillman.freehosting.net > ::: > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Looping through lists
Hey, I need to figure out how to loop though a list and perform a query for each value returned in the list. Any ideas? -- This Email is 100% Virus Free! How do I know? Because no Microsoft products were used to generate it! ::: Jon Tillman LINUX USER: #141163 ICQ: 4015362 [EMAIL PROTECTED] http://tillman.freehosting.net ::: -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.