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
> 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 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 featured = No
> > AND (
> > <cfloop index="i" list="#client.troll#">
> > OR ID <> #i#
> > </cfloop>)
> > </cfquery>
> >
> > I know the above is glaringly wrong, but I've tried everything - is it
the
> > positioning of ANDs and ORs?
> >
> > Any advice would be muuuch appreciated.
> >
> > Will
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
