[FX.php List] Limit To Number of Queries

[Andy Gaunt]

Hi Gerry,

There is not a limit as such on the number of queries, although the more you
do the more load you put on FileMaker and run the risk of getting timeout
errors.

As to getting around the max 50 records the best thing is to create a
variable for the group size

$groupsize = 'x', where x is the number of records to display (you can also
say all)

Eg

Then, add the $groupsize to your query

$query -> SetDBData('databasename',$layout, $groupsize);


Andy Gaunt
T: 407.810.4722
andy at fmpug.com
http://www.fmpug.com    

Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award

For chapter locations, dates & times please visit the website at
http://www.fmpug.com If you can make it to a meeting, please RSVP at
http://www.fmpug.com/rsvp.php

-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of
gerry.charest at agfa.com
Sent: Monday, March 06, 2006 1:12 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Limit To Number of Queries

Hi Evereyone.

Is there a limit to the number of queries that can be passed in to FX from
a single page?
I'm trying to gather information from several queries then construct the
page from the results. My first two queries work fine then the third fails
with a message "Fatal error: Cannot use object of type FX_Error as array in
c:\Inetpub\wwwroot\bug\New.php on line 40".  When I switch things arround,
third query second, it works and the old second query does not.

Also is there a way to get arround the max found set of 50?

Gerry

_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list