Or, if possible, add a field to the vct file for include/exclude... ��� Tony
-----Original Message----- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:37 AM To: CF-Talk Subject: SOT: SQL Question - Could CF make this easier? I am creating a drop-down list of items, but I want to keep several items from appearing in the drop-down. Is there a more efficient way to accomplish this (there will be several more exclusions): <cfquery name=qCrop datasource="common_as"> SELECT DISTINCT Description FROM VCT ORDER BY Description WHERE description != 'ANISE' AND description != 'APPLES' AND description != 'ASPARAGUS' AND description != 'BEETS' AND description != 'BROCCOLI' </cfquery> -- Jillian ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
