Jump to content

quick question about searching


clevow
 Share

This topic is 7188 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 ]

Link to comment
Share on other sites

This topic is 7188 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.