[FX.php List] Boolean-type searches

[Gjermund Gusland Thorsen]

With a number field and precalculated values that resembles your
bolean extravaganza.

ggt667

On 9/25/07, DC <dan.cynosure at dbmscan.com> wrote:
> hey chris, just set up a wee wiki and we'll work on the FAQ.
>
> 1) How do I do a boolean AND with nested OR search (X=1 AND (Y=0 OR Y=""))
>
> 2) What can I do to really slow things down on my FMP web interface?
> (Flabby layouts, container fields, unstored calc fields, etc...)
>
> 3) Who made this wicked cool FX.php thing anyhow?
>
> ;-)
>
> dan
>
> Chris Hansen had written:
> > 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
> >
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>