[SPAM-5.7]- [FX.php List] Limiting fields returned

[DC]

you can even tell FMP7+ to send back fields on a different layout than 
the one you queried. that might help too in case your find parameters 
are something other than the data you want to use.

dan

Alex Gates had written:
> Hi Carl -
> 
> What about putting those 4 fields on a separate layout and querying that 
> instead?
> 
> As far as I know, you can't limit what fields are returned.
> 
> Carl Anderson 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
>