[FX.php List] Limiting fields returned

[Carl Anderson]

John:

As I mentioned, we're probably going that route, so perhaps you can help: Is
there a way to tell FileMaker that, for example, when exam1 field gets
updated on layout X, that exam1totalScore on layout Y should get updated?  I
don't know if I'm using the correct term, but sort of like a database
trigger or something.

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


> From: John Funk <csinfo at comcast.net>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Thu, 15 Nov 2007 12:54:45 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Conversation: [FX.php List] Limiting fields returned
> Subject: Re: [FX.php List] Limiting fields returned
> 
> Any query will only return the fields in the XML data that are on the
> database layout. I use "web" layouts and many quries are simplified using
> FileMaker Calculations to create "flags" so I only have to make simple
> queries, FileMaker does all the work before hand.
> 
> John Funk
> Critical Solution
> 
> 
> 
> On 11/15/07 12:39 PM, "Carl Anderson" <Carl.Anderson at asu.edu> wrote:
> 
>> Good day, list:
>> 
>> Is there any way, whatsoever, of limiting which fields are returned from an
>> FX.php query?
>> 
>> The reason I ask is that we have a table/layout that has a bunch of related
>> fields, and calculations, and all sorts of nonsense...but it happens to be
>> the only place that certain data lie.
>> 
>> Right now, I'm trying to calculate an average on four numeric fields that
>> are in every record (they're exam scores), so what I'm doing is pulling in
>> every record, then looping through that result set, and on each record I
>> loop through to see if the fields have data--if so, I add the score to a
>> temp array, increment a counter, and so on.
>> 
>> On a result set of roughly 600, it's taking between 2.5 and 5 minutes (I
>> suspect it's dependent upon what else is going on, on the server).
>> Thankfully I'm using FXneoCache to deal with subsequent loads, but the
>> initial one is killing me.
>> 
>> Thus the crux of the question: Is there any way to limit what I get back
>> from FileMaker, to only the four (or so) fields that contain the scores?
>> I'm guessing that would seriously cut down on the processing time.
>> 
>> Thanks for any tips.
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list