I assume the insert is going directly into a table and not into a query?
[mailto:[EMAIL PROTECTED]
Sent: 19 June 2008 20:35
To: CF-Talk
Subject: Re: CFLOOP - why are there duplicates?
Thanks. I thought I was going crazy.
Not a cflocation somewhere else is there ? Is the page definitely only
I assume the insert is going directly into a table and not into a query?
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 19 June 2008 20:35
To: CF-Talk
Subject: Re: CFLOOP - why are there duplicates?
Thanks. I thought I was going crazy
I'm trying to us the output from a query to loop through and insert statement.
My original query has 100k for a recordcount. When I run it through the insert
statement below, I end up with 200k inserts. Just need another set of eyes.
Thanks.
CFLOOP query=getmailids
CFQUERY
dumb question but... gotta ask. are you inserting the 100 records
into the table that originally had 100 records (thus resulting in
200)?
how do you know that the getmailids query had 100 records? can you
verify? are you getting 200 inserts or are you just ending up with
200 records in the
What is the getmailids Query?
You don't have it inside a cfoutput Query=getmailids tag do you?
Rick
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2008 2:15 PM
To: CF-Talk
Subject: CFLOOP - why are there duplicates?
I'm trying to us
Not a dumb question ... could have been the issue. But it not in this instance.
dumb question but... gotta ask. are you inserting the 100 records
into the table that originally had 100 records (thus resulting in
200)?
how do you know that the getmailids query had 100 records? can you
verify?
Have you confirmed that the record set labeled 'getMailIds' does not
contain more records then you expect.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
CFQUERY name=getmailids datasource=stonyfieldcustom
SELECT DISTINCT mailprofiles.mailprofileID
FROM dbo.mailprofiles
INNER JOIN subscriptions ON mailprofiles.mailprofileID =
subscriptions.mailprofileID
WHERE (dateunsubscribed IS NULL OR datesubscribed dateunsubscribed)
AND newslettertypeID IN
That's why I'm showing the following after the first query and
it confirms that it's the 100k
cfoutput#getmailids.recordcount#/cfoutput
Strange isn't it?
Have you confirmed that the record set labeled 'getMailIds' does not
contain more records then you expect.
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
That's why I'm showing the following after the first query and
it confirms that it's the 100k
cfoutput#getmailids.recordcount#/cfoutput
Strange isn't it?
There isn't anything in the code you have shown so far that would
account for there to be
Thanks. I thought I was going crazy.
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
That's why I'm showing the following after the first query and
it confirms that it's the 100k
cfoutput#getmailids.recordcount#/cfoutput
Strange isn't it?
There isn't anything in the code you have shown so far
11 matches
Mail list logo
