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 ...
SELECT this, that, theotherthing
FROM tblName
WHERE ID = #id#
#this##that##theotherthing
Yep in is much better, quicker too!
[EMAIL PROTECTED] writes:
>
>SELECT this, that, theotherthing
>FROM tblName
>WHERE ID IN (#id#)
>
>
>
>#this##that##theotherthing#
>
~~
Kelly Matthews
Senior Programmer
[EMAIL PROTECTED]
http://www.allsoldout.net
703.387.4000 x 35
You don't need multiple queries. Just run one query with WHERE ID IN
(#form.id#) and do a .
-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 u
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: th
4 matches
Mail list logo