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:

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 ... cfoutput cfloop index=ListIndex list=#FORM.id# delimiters=, cfquery name=listsQuery

Re: simple cfloop

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

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 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