try this for your query
select, this, that, theotherthing
from tblName
where id IN (#form.ids#)
-Original Message-
From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 8:33 PM
To: CF-Talk
Subject: simple cfloop
Beginner CFer with an easy question. The situation:
The way your are doing it, just do the following:
Take plain outputs and put them around the loop (so it doesn't have to
output,output output ...(don't know if it matters)..
Then do as you were doing ...
cfoutput
cfloop index=ListIndex list=#FORM.id# delimiters=,
cfquery name=listsQuery
Yep in is much better, quicker too!
[EMAIL PROTECTED] writes:
cfquery datasoure=xxx name=listsQuery
SELECT this, that, theotherthing
FROM tblName
WHERE ID IN (#id#)
/cfquery
cfoutput query=listsQuery
#this#br#that#br#theotherthing#brbr
/cfoutput
~~
Kelly Matthews
Senior
You don't need multiple queries. Just run one query with WHERE ID IN
(#form.id#) and do a cfloop query = myQuery.
-Original Message-
From: Sorgatz, Rex [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 03, 2002 8:33 PM
To: CF-Talk
Subject: simple cfloop
Beginner CFer with an easy
4 matches
Mail list logo