quick question about searching

[clevow]

Am I correct in understanding that there is no way to search for records where, for example:

First_Name=Jane AND Last_Name contains Smith?

It's either all or nothing, right? One operator per search? That's what I'm getting from the docs. Please correct me if I'm wrong.

Thanks,

Carrie

[tlsparker]

Enter Find Mode.

Type "Jane" in the First_Name field.

Type "Smith" in the Last_Name field.

Click "Find"

This will return all records for Jane Smith.

Tom

[clevow]

Well, I'm talking about doing this via the web, so it's not quite like that.

What I want to know is if that will find the records for Jane Smith and Jane Smithson, or will it just find Jane Smith. Like I said, I want the first name to be Jane but the last name to contain Smith.

Thanks,

Carrie

[Keith M. Davie]

Carrie, there is a potential problem with using the -op tags. Specifically, if you do not use JavaScript to require fields to contain data on submit a client can often enter just one of two fields and get a response, sometimes several records. There is a better way to handle your code than with the -op and -lop tags in link actions or form actions. Once understood, the other symbols of the FileMaker db find are easily incorporated into your code. That is why I strongly recommend:

http://www.filemaker.com/support/index.html

Search and read: Article Number: 104829, and Article Number: 105687

After you have read these two articles you should read the two recent threads in the cdml forum about currentdate. One was started by Turansky and the other was started by me.

SIMPLIFY ...

Keith

[Garry Claridge]

You can use:

&-op=eq&first_name=Jane&-op=cn&last_name=Smith&-find

The '-lop' can only be used once, hence mixing 'and' and 'or' is restricted.

Hope this helps.

Garry

[clevow]

How does that work on a form then?

That is, how do you specify a different operator for each field on a form?

Or doesn't it?

Thanks,

Carrie

[Garry Claridge]

Carrie,

Here is the form version:

<input type="hidden" name="-op" value="eq">

<input type="text" name="first_name" value="Jane">

<input type="hidden" name="-op" value="cn">

<input type="text" name="last_name" value="Smith">

All the best.

Garry

[ February 13, 2002, 12:31 PM: Message edited by: Garry Claridge ]

[clevow]

Thanks for your help, Garry. I appreciate it.