Global Search

[Addam]

Does anyone know how to do a "Global Search" of a database via the web?

I want to create 1 "Search" field that will check every field in that database (or layout) for whatever the criteria and display it back to the user.

Not quite sure how to tackle that one.

Any help would be greatly appreciated!

Thanks!

~Addam~

[Garry Claridge]

Addam,

This is a bit of hack work however you will end-up with a "-lop" of "OR" and a list of all the fields as <input> tags. You can then use Javascript to fill-in the values of all the fields to be searched.

Another method is to create a Calculation field which concatenates all of the fields to be searched. You would then use a "-op" of "Contains" for the search on that field.

Hope this helps.

Garry

[Anatoli]

We are doing that with Calc field and it is sort of dictionary.

It is work for 5 minutes.

[Addam]

COOL! Thanks for the reply!

Ok...

I seem to be in the right direction...

Now reg. the calculation field...

It is:

webFind - FieldNames (Status(CurrentDatabase), "profile")

This will give me the field names in the database.

Should the HTML look like this:

<input type="hidden" name=" [FMP-Field: webFind]" >

or am I missing something here. (BTW, this does not work).

Thanks!

~Addam~

[Garry Claridge]

Addam,

In the Calculation field I would have something like this:

webFind - myfield1 & myfield2 & myotherfield .... etc

An efficient method, of using FieldNames(), may exist however, I haven't used that function.

The html/cdml would look like this:

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

Enter a String to search for:<input type="text" name="webFind" value="">

<input type="submit" name="-find" value="Find String">

Hope this helps.

Garry

[Addam]

Thank you Soo Much!

It works like a charm!

Cheers!