[FX.php List] Limit To Number of Queries

[gerry.charest at agfa.com]

Andy,

Thanks for the $groupsize tip.  Is there a way to determine if the server
is timming out or if there is another problem?  Most of the queries are
only returning a few records.

Gerry Charest




|---------+------------------------------------>
|         |           "Andy Gaunt"             |
|         |           <andy at fmpug.com>         |
|         |           Sent by:                 |
|         |           fx.php_list-bounces at mail.|
|         |           iviking.org              |
|         |                                    |
|         |                                    |
|         |           03/06/2006 01:15 PM      |
|         |           Please respond to andy;  |
|         |           Please respond to "FX.php|
|         |           Discussion List"         |
|         |                                    |
|---------+------------------------------------>
  >-----------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                             |
  |       To:       "'FX.php Discussion List'" <fx.php_list at mail.iviking.org>                                                   |
  |       cc:       (bcc: Gerry Charest/MJVYN/AGFA)                                                                             |
  |       Subject:  RE: [FX.php List] Limit To Number of Queries                                                                |
  >-----------------------------------------------------------------------------------------------------------------------------|




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


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