Filemaker: whose cell is... doesn't search exact
Filemaker: whose cell is... doesn't search exact
- Subject: Filemaker: whose cell is... doesn't search exact
- From: cris <email@hidden>
- Date: Wed, 11 Jul 2001 03:11:02 +0200
With the FM "whose cell x is y" statement i try do determine a record, but
the problem is that FM returns records which are not having the exact
requested value. For example:
<whose cell "bla" is "hello cris"> returns records with the cell value
"hello cris"
"cris hello"
"there cris hello"
FM doesn't care for the order of the words. Additionally it matches also
when another word is only partially in the whose statement:
<whose cell "bla" is "hello cr">
returns the same results.
I tried using the special search symbol for an exact search "==" with no
success. I guess that works only in the "find" command of FM.
I have to mention that i can't use the "find" command of FM since this needs
more than one statement (clearing and defining request) and the script is a
CGI, so another incoming call could override a current find which would lead
to false results or errors.
Does anybody know how to search exact with the "whose cell is" statement?
Greetings
cris :-)
--
English is my second language, please write slowly!
www.cooc.de