[FX.php List] Google-Like search?

Ernest Cunningham ernest.cunningham at gmail.com
Mon Dec 1 16:40:05 MST 2008


Why concatenate and search an unstored calc in FM when you can use the  
logical or operator it in FX?

Ernest



On 2/12/2008, at 4:08 AM, Bob Patin wrote:

> Jonathan,
>
> I've used the concatenated-field approach many times; if you don't  
> store the calculated results, the "search field" will always contain  
> current data. For example, with a shopping cart, I combine product  
> name, catalog number, description, and any keywords the client  
> enters into a keyword field. Works well, easy to implement, only  
> needs one search field.
>
> You can see it on http://www.margem.com; try entering the word  
> "diamond" or "bracelet," for example.
>
> Best,
>
> Bob Patin
> Longterm Solutions LLC
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> iChat/AIM: bobpatin
> FileMaker 9 Certified Developer
> Member of FileMaker Business Alliance
> --------------------------
> FileMaker hosting and consulting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>
> On Nov 30, 2008, at 2:49 PM, Jonathan Schwartz wrote:
>
>> Hi Folks,
>>
>> Have been running into web users who don't quite understand the the  
>> "one-search-field-per-data-column" approach that I often implement.  
>> They seem to be wanting for a single filed search, ala Google.
>>
>> I can think of two approaches:
>> 	1) Combining fields in FMP and searching this new mega-field.  
>> Could get ugly.
>> 	2) Issuing multiple fx.php searched and combining.  This doesn't  
>> smell right, though.
>>
>> Anyone else approached this challenge?
>>
>> Thanks
>>
>> Jonathan
>> -- 
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> http://www.exit445.com
>> 415-370-5011
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list