[FX.php List] Search Syntx

[Jonathan Schwartz]

Thanks Dale and Andrew.

That was a "DOH!" moment. ;-)

Jonathan


At 1:34 PM -0500 9/5/06, Andrew Denman wrote:
>  >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
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 

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