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
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
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
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
5 matches
Mail list logo