Hello.
I'm trying to exclude an ID from the WHERE in a query, by looping through a
list, but it's causing a lot of headaches. The list contains delimited list
of IDS (120,145,987,564 etc)
cfquery name="users_adverts" datasource="localads"
SELECT ID,email,subject,paid FROM advert_details
WHERE
Use NOT IN
WHERE featured = No AND
ID NOT IN (#ListofIDs#)
- Original Message -
From: "W Luke" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 01, 2001 9:48 AM
Subject: Excluding IDs in queries
Hello.
I'm trying to exclude
To: CF-Talk
|Subject: Excluding IDs in queries
|
|
|Hello.
|
|I'm trying to exclude an ID from the WHERE in a query, by
|looping through a
|list, but it's causing a lot of headaches. The list contains
|delimited list
|of IDS (120,145,987,564 etc)
|
| cfquery name="users_adverts" datasour
Thanks, working now..:/
Will
- Original Message -
From: ""Sean Renet"" [EMAIL PROTECTED]
Newsgroups: dotcom.lists.cftalk
Sent: Sunday, April 01, 2001 6:05 PM
Subject: Re: Excluding IDs in queries
Use NOT IN
WHERE featured = No AND
I
AND ID NOT IN #CLIENT.TROLL#
(The RDBMS will translate IN into multiple OR statements and NOT IN into
multiple AND statements.)
-David
On Sunday, April 01, 2001 9:48 AM, W Luke [SMTP:[EMAIL PROTECTED]] wrote:
Hello.
I'm trying to exclude an ID from the WHERE in a query, by looping through a
OR
/cfloop 1=2)
/cfquery
-Original Message-
From: W Luke [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 01, 2001 9:48 AM
To: CF-Talk
Subject: Excluding IDs in queries
Hello.
I'm trying to exclude an ID from the WHERE in a query, by looping through a
list, but it's causing a lot of head
314 Oakland Ave.
Rock Hill, SC 29730
(803) 327-0137 [111] (p)
(803) 328-2868 (f)
- Original Message -
From: "David Shadovitz" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 01, 2001 1:20 PM
Subject: RE: Excluding IDs in queries
AND ID
7 matches
Mail list logo