[FX.php List] Choking on data returned

[Jonathan Schwartz]

Sorry.

In fx.php, it's called FMSkipRecords($skipsize).

FMSkipRecords ($skipSize)
This function is used to specify which record in the found set should 
be the first returned to FX. FMSkipRecords() is optional.
>>  $skipSize is the only parameter taken by FMSkipRecords(). By 
>>incrementing or decrementing this value, records in the found set 
>>could be paged through in groups whose size was specified with the 
>>$groupSize parameter in SetDBData(). For example:
$skipSize = $skipSize + $groupSize; $InstanceName->FMSkipRecords($skipSize);
This would increment the number of records skipped by the value 
stored in $groupSize, and then pass that parameter to FX so that 
$skipSize records will be skipped and the next $groupSize number of 
records will be returned by the current query.

Just add $request->FMSkipRecords(60);


With the, data will start on records 61 and you will see if it chokes 
from the data or the size of the data.

J

>I'm using FX.php.
>
>What does setRange do? I don't see it in the FX docs.
>
>When I used it, the page failed to load, which makes me think it's 
>not supported in FX.
>
>I tried these 2 searches:
>
>1) (the search I want) balance-due>0, qty-shipped>0; this geeks with 
>133 records found
>
>2) a test query finding a date range, returns 113 records, geeks too...
>
>Question I have is, how do I find the problematic record (if one 
>exists)? This is really old data, no telling what he has in there...
>
>BP
>
>Bob Patin
>Longterm Solutions LLC
><mailto:bob at longtermsolutions.com>bob at longtermsolutions.com
>615-333-6858
><http://www.longtermsolutions.com>http://www.longtermsolutions.com
>FileMaker 9, 10 & 11 Certified Developer
>Member of FileMaker Business Alliance and FileMaker TechNet
>--
>Twitter: bobpatin
>Google+: 
><http://www.longtermsolutions.com/plus>http://www.longtermsolutions.com/plus
>AIM: longterm1954
>iChat: bobpatin
>--
>Expert FileMaker Consulting
>FileMaker Hosting for all versions of FileMaker
>
>
>
>On Sep 28, 2012, at 11:48 AM, Jonathan Schwartz 
><<mailto:jschwartz at exit445.com>jschwartz at exit445.com> wrote:
>
>>Throw in a $request->setRange(60, whatever)   to see if this is the 
>>case. Are we talkinh fx.php ot API?
>>
>>J
>>
>
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 
Jonathan Schwartz
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120928/ea1a0b55/attachment.html