You can do it easier with SQL by using NOT IN
... WHERE Description NOT IN ('ANISE', 'APPLES',.....)
HTH
Dick
On Wednesday, June 11, 2003, at 11:37 AM, Jillian Carroll wrote:
> 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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
