John,
You should be able to say:
AND NOT omit = 'yes'
That's assuming that omit is a text field and not a boolean (yes/no)
field. If its boolean you could just say:
AND omit = false
hth,
Kevin
At 01:33 PM 8/11/00 -0700, you wrote:
>Hi all
>
>Here the query I'm trying to edit:
>
><CFQUERY NAME="LookUpResults" DATASOURCE="WebData">
> SELECT CompanyName, City, State, CompanyURI
> FROM Main (Index=ix_Main_CompanyURI)
> WHERE CompanyURI IN (#QuotedValueList(CompanyNameSearch.Custom1)#)
> ORDER BY CompanyName
> </CFQUERY>
>
>
>I would like to add "omit <> 'yes' " to the WHERE clause. When I do this, the
>query returns 0 records (unmodified, it returns 25 records).
>
>Any ideas are greatly appreciated.
>
>* John *
--------------------------
Kevin Marshall
Web Application Developer
eCalton.com, Inc.
Vero Beach, FL
www.ecalton.com
[EMAIL PROTECTED]
561.569.4500
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.