simple cfloop

2002-03-03 Thread Sorgatz, Rex
Beginner CFer with an easy question. The situation: the user selects the rows to query based upon ticking checkboxes. So, this is the first page: Using a list and a cfloop to return multiple columns in only the rows the user selects, what would the tally.cfm page look like? I'm looking a

Re: simple cfloop

2002-03-03 Thread Paul Giesenhagen
this##that##theotherthing# You could also do "IN" SELECT this, that, theotherthing FROM tblName WHERE ID IN (#id#) #this##that##theotherthing# - Original Message - From: "Sorgatz, Rex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: S

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

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