return object data size : FCS and AMF

[Rafique]

Hi Guys,
I  am facing this problem while working with FCS and AMF on a Linux box

this does not work (i am quering for all the recordset):
$get_mb=mysql_query("SELECT Username,Balance,isOnline,LastLoggedIp from users");

This works(i am quering for limited reords):
get_mb=mysql_query("SELECT Username,Balance,isOnline,LastLoggedIp from users limit 0,100");

again this works(here again the data is less)
$get_mb=mysql_query("SELECT Username from users");

Is there any size restriction to the return object

Both work perfectly fine if i make a call from Flash but does not work with Flash Communication Server

Also if i have AMF on an IIS server , FCS and MySql on a Linux box the above queries work perfectly fine and I am able to get the complete recordset in FCS


Thanks
Raf

[Jorge Solis]

Hi Rafique, welcome to the Boards !

Yep, this i a size issue, but don't know exactly the limit (should test by yourself, could be interesting to know your results)

Here's some report to the amfphp list:

Flash talks to FlashComm, Flash talks to AMFPHP, FlashComm talks to
AMFPHP. No problem. AMFPHP replies to FlashComm, and sometimes
there"s a problem.

The AMF object queries MySQL, gets a recordset, packages it nicely
for FlashComm, and sends it back. The return object is an array with
two fields: a name and an array of records. FlashComm gets it, the
name is always there, but sometime the array of records is undefined.

Tracking this down more shows that this only happens when there is a
lot of data in the array of records. This is true for arrays of many
records, as well as for arrays of fewer, fatter records. I"m not
enough of either a PHP whiz nor a FlashComm whiz to find out exactly
how big--in bytes--the arrays are, but it definitely depends on the
total data size, as opposed to the number of records.

If I call the same PHP object from another PHP file and send its
results to a web page, everything works fine. The PHP is packaging
the data with no problem, but AMF is failing to send it along
properly to FlashComm. I haven"t tried calling the AMF object from a
Flash movie directly. That"s the next step, I suppose, but I thought
I"d mention this problem here, and see if anybody has run into it.

- Henry

Jorge

[Benjamin]

well i have been into flash for a very long time now and i need to do things likeyou
so i decided that i was going to study on my own but then i got to a point that i got stucked
the problem i have is that i have installed php 5, mysql, apache on my machine and now i want that guest book stuff to work on my machine please what are the configurations that
i need to do so that the php will connect to mysql and send the recordset to flash?
 and actually my os is win 2000 pro and i want to use apache server just like you
i will be very greatfull if you can help me
thank you Master.
Benjamin student

[Jorge Solis]

Post a new question, this is not related to this thread.

Jorge