[FX.php List] Boolean-type searches

[Carl Anderson]

Thanks, Chris/Dan/Derrick/Dale (and Alex for pointing out a search--I found
the archives, but couldn't search therein very effectively).

I don't really have the ability to do a script or add additional
fields--essentially we're running college course databases, all modeled
after a "template" as it were, but there are too many to modify at this
point, especially late in the semester.

I suspect I'll go with some sort of PHP solution (like options 2 or 3), to
take the load off of FileMaker...it's just a pity that something basic (to
me) isn't built in to FileMaker as it stands.

I'll see what all I can come up with.  Thanks again.

-- 
Carl Anderson 
Technical Support Analyst
Distance Learning 
Herberger College of the Arts
Arizona State University
http://herbergeronline.asu.edu


> From: Chris Hansen <chris at iViking.org>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Tue, 25 Sep 2007 12:59:22 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: Re: [FX.php List] Boolean-type searches
> 
> Dan,
> 
> I think you hit the highlights.  (Though Derrick brings up another
> interesting possibility.)  Note that if you want to use a global for
> option 1, that globals in FM7 and up require some special handling --
> use the SetFMGlobal() function within FX.php, not the generic
> SetDBParam() function.  Also note that this logical AND/OR thing is a
> limitation of using FileMaker's XML interface (so you may bump into
> this elsewhere), just a heads up.
> 
> On another note, okay there should be a FAQ...  Any other suggestions
> for FAQ questions?  And okay, I'll look into making the archives
> searchable (sheesh Dan, way to rock my boat ;-p )
> 
> --Chris Hansen
>    FileMaker 8 Certified Developer
>    FileMaker 7 Certified Developer
>    Creator of FX.php
>    "The best way from FileMaker to the Web."
>    www.iViking.org
> 
> 
> On Sep 25, 2007, at 12:50 PM, DC wrote:
> 
>> is there a FAQ? this should be question #1. also, is there a list
>> archive? ah yes, there it is:
>> 
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> oh shit. it's not searchable.
>> 
>> well....
>> 
>> there is no simple way to do this. choose your poison.
>> 
>> 1. write a script in FMP and run the script from FX.php. the result
>> set after the script runs should be your set.
>> 
>> 2. return one set of results from a wider search and cull the
>> results in a foreach loop in PHP.
>> 
>> 3. return two sets of results and merge/cull them in PHP.
>> 
>> 4. do a combination.
>> 
>> hey guys, did i forget anything?
>> 
>> dan
>> 
>> Carl Anderson had written:
>>> Good day, list.
>>> I apologize if this is academic, or is written in some obvious
>>> place that
>>> I've overlooked.
>>> I'm trying to query a database with two fields, let's say: Points and
>>> Status.
>>> I'm looking to search for something like the following (pseudo-
>>> codish):
>>> Status = 1 AND (Points = 0 OR Points = "")
>>> Sadly, I have no clue how to do this with FX.php--seems if I do a
>>> logical
>>> OR, then I end up with:
>>> Status = 1 OR Points = 0 OR Points = ""
>>> Can someone point me in the right direction?  I really need it to be
>>> X=1 AND (Y=0 OR Y="")
>> _______________________________________________
>> 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