Re: simple cfloop

2002-03-03 Thread Paul Giesenhagen
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

Re: simple cfloop

2002-03-03 Thread Kelly Matthews
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

RE: simple cfloop

2002-03-03 Thread stas
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

RE: simple cfloop

2002-03-05 Thread Bill Killillay
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