Re: multiple find requests in a link -- impossible?

#1

Mark Bowron wrote:

Quote:

Is there any way to achieve multiple find requests in a link?

http://heifer.ucc.usyd.edu.au/cdf_fa...e==3h127&-find

The double = sign means exact match in this case.

Quote:

Larry Samberg asked this question here a few years ago
(Google link provided below), someone came back with a
non-reply, Larry asked again, and nobody replied.

http://groups.google.com/groups?q=gr...eee.org&rnum=2
??

Quote:

e.g. I need to find all records containing an exact match
to "John Smith" in either Field 1 or Field 2. Inside FMP
you'd specify this using two find requests, each searching
for the literal string "John Smith":

Request 1:
Field 1 = "John Smith"

Request 2:
Field 2 = "John Smith"

then you'd hit the "find" button.

Cheers

Webko

#2

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

Quote:

If you are talking about a CDML web link, then yes: you can include two
different fields as criterion using -lop=or

Yes I am talking about a CDML web link, and yes I was pretty sure
-lop=or is necessary. However it is not sufficient, because instead
of searching for "John Smith" in each separate field, FileMaker
searches for "John" OR "Smith" in each separate field.

I don't think -lop=or is to blame for this latter OR to happen,
because -lop applies to interfield logic, not intrafield logic.

I have tried various fixes to get what I need without success. I
tried storing the data in ASCII. I tried using double equal signs in
the link. I thought about putting quotes in the link around John
Smith but didn't even attempt this because a quote would have
terminated the quote in URL=".

Maybe I need to change the space characters in each of the fields to a
different space character that FileMaker doesn't regard as a word
separator, yet still matches an ordinary space character entered in
search criteria?

Mark Bowron
mbowrun (AT) att (DOT) net (spam can run -- call me ron)

#3

Tim Booth <tbooth (AT) usyd (DOT) edu.au> wrote

Quote:

Mark Bowron wrote:

Is there any way to achieve multiple find requests in a link?

http://heifer.ucc.usyd.edu.au/cdf_fa...e==3h127&-find

The double = sign means exact match in this case.

Okay great, but I can now see that it must be impossible to do a
logical OR search for exact matches to a multi-word string like "John
Smith" in more than one field at a time using a CDML link.

The next best thing, concatenating into a single field, is what I'll
use, but this represents a heavy compromise if you ask me.

Still appreciate the replies though -- thanks again.

Mark Bowron

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: multiple find requests in a link -- impossible?

comp.databases.filemaker comp.databases.filemaker

Re: multiple find requests in a link -- impossible? - 08-07-2003 , 05:51 PM

Re: multiple find requests in a link -- impossible? - 08-09-2003 , 09:56 AM

Re: multiple find requests in a link -- impossible? - 08-12-2003 , 03:00 PM