Like I said Chrisyou need the IN clause...will work with single or
multiple IDs passed in ;-)
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electriced
On Mon, 31 Jan 2005 19:25:36 +, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:
>
> > are you sure your query is returning records? do a
> > #get_people.recordcount# after your to
> > make sure.
>
> Ah! Now we're getting somewhere. No: when I
:D it now loops. The IN clause fixed it. Thanks everybody.
- ck.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
clien
On 31 Jan 2005, at 7:12 pm, Charlie Griefer wrote:
> are you sure your query is returning records? do a
> #get_people.recordcount# after your to
> make sure.
Ah! Now we're getting somewhere. No: when I check multiple boxes on
the form that gets me here, it sends one value, like this:
1,7
W
anagh [mailto:[EMAIL PROTECTED]
...Sent: Monday, January 31, 2005 11:07 AM
...To: CF-Talk
...Subject: CFLOOP not looping
...
...Dear list,
...
...My CFLOOP doesn't seem to be looping my INSERTS.
...
...A form passes the variables #person_id# & #project_id# to this page:
...
...
...
...
Your person_IDs var probably holds a list of IDs (or a single ID)so you
need to use an IN cluse in your first SELECT to get multuple records to then
use to loop over and do your inserts.
like so:
SELECT person_id FROM people
WHERE person_id IN ()
INSERT INTO people_project (pers
are you sure your query is returning records? do a
#get_people.recordcount# after your to
make sure.
On Mon, 31 Jan 2005 19:07:13 +, Chris Kavanagh <[EMAIL PROTECTED]> wrote:
> Dear list,
>
> My CFLOOP doesn't seem to be looping my INSERTS.
>
> A form passes the variables #person_id# & #p
Dear list,
My CFLOOP doesn't seem to be looping my INSERTS.
A form passes the variables #person_id# & #project_id# to this page:
SELECT person_id FROM people
WHERE person_id = '#Form.person_id#'
INSERT INTO people_project (person_id, project_id)
8 matches
Mail list logo