[FX.php List] Search Syntx

Andrew Denman adenman at tmea.org
Tue Sep 5 12:34:52 MDT 2006


>From my experience with searches, if it works in FileMaker it works on the
web.  For a full list just click the little triangle next to "Symbols" on
the status area in find mode.

Andrew Denman

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Saturday, September 02, 2006 12:07 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Search Syntx

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

_______________________________________________
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