<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>
----- 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/[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.
>
------------------------------------------------------------------------------
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.
