On Tue, 01 Aug 2000, peter spewed forth into the void:
> <CFLOOP LIST="#myListOfValues#" INDEX="currItemInList">
> <CFQUERY NAME="performTrivialFunctionInLife" DATASOURCE="...">
> select *
> from stillAtWork
> where somevalue = #currItemInList#
> and salary < #peanuts#
> order by salary
> </CFQUERY>
>
> <CFOUTPUT QUERY="performTrivialFunctionInLife">
> #xyz#<br>
> </CFOUTPUT>
> </CFLOOP>
>
>
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/[email protected]/
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.
