search not working on one field

[mlindal]

Using a pop-up selection I can not get the search to do what we want.

For example: A publication is either a) English, : French or c) English/French

When the option for English publications is selected, we want to show all the a) English publications and c) English/French publications. (in other word search the field for all publications that contain english)

Currently here is the code:

<select name="LV PLID_Sort::PubLanguage_E" size="1">

<option></option>

<option value="English">English / Anglais</option>

<option value="French">French / Francais</option>

<option value="Other">Other / Autre</option>

</select> -->

When the selection English is picked - we get the English only pubs not the English/French pubs.

When searching in FMPro (rather than CDML on the web) we search the field and get both.

What am I missing and why wont it work from the web.

Other fields in the form seach fine.

[Justin Grewe]

It doesn't make sense. CDML uses webcompanion, and webcompanion performs everything in FileMaker in the same manner as you would do it yourself. FileMaker is really good in that you can perform a find with English and anything that CONTAINS English will be found. CDML is the same way. You should get back English/French when you search for English.

What is your rest of your code?

Is it:

<form method="post">

<input type="hidden" name="-db" value="databasename"/>

<input type="hidden" name="-lay" value="layoutname"/>

<input type="hidden" name="-format" value="html page that will display the results"/>

<select name="LV PLID_Sort::PubLanguage_E" size="1">

<option></option>

<option value="English">English / Anglais</option>

<option value="French">French / Francais</option>

<option value="Other">Other / Autre</option>

</select>

<input type="submit" name="-find" value="find records"/>

The only thing it could be is that somehow, i haven't really dealt with cdml in a while so I don't know, but maybe finds don't function correctly with relationship fields. Probably not though. Also, look at the html page that displays the results. Is there anything wrong with the cdml on that page?

Good luck,

Justin Grewe

[mlindal]

Here is what I have in addition to the pop-up selection:

<form action="FMPro" method="POST" name="searchform">

<input type="hidden" name="-token" value="[FMP-currenttoken]">

<input type="hidden" name="-DB" value="PUB_Publication_.fp5">

<input type="hidden" name="-LAY" value="ForWeb">

<input type="hidden" name="-format" value="hitlist.html">

<input type="hidden" name="-error" value="search.html">

<input type="hidden" name="-find" value="">

<input type="hidden" name="-script" value="Web_CheckFind">

<input type="hidden" name="-LOP" value="AND">

then... (Pop-up selections...)

<input class="button2" type="submit" name="Search" value="Search">

I am wondering if there might be some trouble with seaching on the field. Are there any settings from the Filemaker database side that might cause the field to search for exact rather than contains?

[Justin Grewe]

mlindal,

I don't understand your cdml and I don't know why it's working myself at the current moment. You should just have

<form action="fmpro" method="post" name="searchform">

<input type="hidden" name="-db" value="PUB_Publication_.fp5"/>

<input type="hidden" name="-lay" value="ForWeb"/>

<input type="hidden" name="-token" value="[FMP-currenttoken]">

<input type="hidden" name="-format" value="hitlist.html"/>

<select name="LV PLID_Sort::PubLanguage_E" size="1">

<option></option>

<option value="English">English / Anglais</option>

<option value="French">French / Francais</option>

<option value="Other">Other / Autre</option>

</select>

<input type="submit" name="-find" value="find records"/>

The find request is not a hidden type in the form. It goes with the submit button. You don't need a script in FileMaker to do the finds. Although, you might be using the script for other reasons. But you don't need the LOP AND in there I do not think. If all you are doing is just a simple find as you have described than just use my form and it will work. Also, the last input you have where there is button2, What is that doing?? to me that is doing nothing. If you had a php page and you were posting data onto a php page, then all you would need is a input type="submit" name="submit" or search as you have done, but with the FileMaker webcompanion CGI, you need to be specific at what you want it to do once you hit the submit button. Currently, search does nothing in FileMaker. Stick with -find.

Good luck,

Justin Grewe

[Garry Claridge]

I would remove this line:

<input type="hidden" name="-LOP" value="AND">

you could have this line before the <select>:

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

This will use the "contains" search. (I don't know exactly what your data looks like so this may not be appropriate.)

This is OK:

<input type="hidden" name="-find" value="">

because it caters for anybody just pressing the enter key rather than clicking on the "Submit" buton. However, you should still have:

<input type="submit" name="-find" value="Search">

Good Luck.

Garry

[mlindal]

Success!

It works! The keys changes needed were

1. Taking out the "-LOP" value="And"

2. Fixing the submit button so the name="-find" <!-- pretty dumb oversight on my part -->

3. this one may not be necessary - but... adding <input type="hidden" name="-OP" value="cn">

before the <select>

To answer the question from Justin about "button2" - that is a CCS style that I use to make the submit button look cool under most browsers. Unfortunately it doesn't do a thing under Apple's Safari - but works great under Explorer.

Thanks guys - some quick advice and I am back on track!

The next phase will be to convert the whole site to XML so we can use FM7...

[mlindal]

Back to square 1...

The search now only partly works.

Searching for "English" finds results that start with 'english' (ie. English, English/French, etc)

And search for 'French' will find results starting with 'French' (ie. French, French/English), however it will not find 'English/French' ...

Any more thoughts on what else can be done. It should work - but I am now thinking that I may need to do some work on the database field itself. Please provide input if you can.

[Unable]

You may or may not find the Sample File "CDML -Op values and Symbols demo" useful.

Be sure to also get the redacted page and make the change suggested in the 3rd message.

[mlindal]

Here is the answer:

The '/' was messing up the searching with the Filemaker database.

Ie) a publication was 'English/French' and the '/' was causing the indexing to go funny...

When we changed the value list to 'English / French' (spaces around the '/') it works fine and finds the publications we needed.

Thanks to all for you input.

[Steve T.]

Yeah, I believe FM only searches the beginning of words, not embedded strings. In our web search engines, we tell people they can use partial words but I think they're used to typical web search formats (whole words, +, -, " ", etc.). FM also has reserved characters that can complicate searches.

--ST