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 *
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
