Use the IN operator
<cfquery name="users_adverts" datasource="localads">
SELECT ID,email,subject,paid FROM advert_details
WHERE featured IN (120,145,987,564)
</cfquery>
|-----Original Message-----
|From: W Luke [mailto:[EMAIL PROTECTED]]
|Sent: Sunday, April 01, 2001 12:48 PM
|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" 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
