Hi All,

I use the global pair and multi criteria rel method for dynamic filtered
portal results

g_text
c_textz = g_text & "z"

have the name Menzel in a Supplier db, and typing 'men' returns no
result, wheras 'me' does. While this is no real problem knowing the
limitation; it is a limitation however, and could be more so in some
user situations. Have tried a few variations on the theme, without
success. Any trick for this?

regards

Chris Brown
University of Adelaide

Chris Brown wrote:

Not completely clear on this. Are you saying that the related results
must be >= g_text and <= c_textz ?

'Menzel' is definitely between 'me' and 'mez'.
And 'Menzel' is greater than 'me' but it is also greater then 'menz'.

Try changing your 'z' to 'zzzz'

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

In article <11mlqnj89ir2174 (AT) corp (DOT) supernews.com>,
howard (AT) antispahm (DOT) fmprosolutions.com says...
Yep that should fix it. (Although it will break on the much more
unlikely supplier 'menzzzzel'

To fix it "properly" would require "rolling the character over"...e.g.
you type in me, and instead of searching:

me <= x <= mez

you'd search:

me <= x < mf (note that its strictly "less than" now)

rolling the final character 'e' into an 'f'. Unfortunately this is
difficult in filemaker because FM lacks good 'character' manipulation
functions. You'd have to build the substitution yourself.

Furthermore, you have to deal with "menz"... how do you roll it over?
The answer: to "meo", which is also a pain to do in filemaker. And it
would have to be recursive because "mezz" would need to rollover to
"mf", "mzzz" would roll over to "n", etc.

FWIW tacking on half a dozen extra z's is much easier and not likely to
cause you greif in the real world (and its probably what I'd even
recommend). But if you want to really "fix" it; see above

Howard Schlossberg wrote:
should have been clearer;

text global and calc
g_Text
c_textz = g_text & "z'

multi criteria rel:
g_text <= name
c_textz >= name

changing to c_textzzzz = g_text & "zzzz" fixed it. Thanks Howard.

regards

Chris