[FX.php List] Search Syntx

[Dale Bengston]

My understanding is that an FX query performs and actual FMP search,  
so any of the search wild cards should work.

Back in the days of FMU6, you could actually double-check your  
queries by choosing "Modify last find" in the FMU client and looking  
at what was filled in. Any wild cards you hard-coded in the query  
were visible in when viewing modify the last find. Likewise, if you  
are using 'gt' or 'lt' or 'eq' in any of your db parameters, you  
could see the wild card added in FMU.

I have not tested every wild card. I know that ... (three periods)  
between two dates finds all the dates in that range, and searching on  
emails is tricky because they contain the @ symbol which is also a  
wild card.

That's a long way around to saying I think anything that works in FMP  
will work if passed by FX to FMP.

Dale

On Sep 2, 2006, at 10:51 AM, Jonathan Schwartz wrote:

> Is there a list of search syntax rules for users of an fx.php- 
> powered search web page?
>
> I'm learning by trial and error, for instance that "*" works as a  
> wildcard and the ">" sign works.
>
> I'm looking for the entire list, and I'm not sure if this is the  
> domain of fx.php or PHP or FileMaker.
>
> Thanks
>
> Jonathan
> -- 
>
> Jonathan Schwartz
> FileMaker 8 Certified  Developer
> Associate Member, FileMaker Solutions Alliance
> Schwartz & Company
> jonathan at eschwartz.com
> http://www.eschwartz.com
> http://www.exit445.com
> 415-381-1852
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list