Thanks Aaron!
I'm still a bit unsure about referencing the individual items then.
after I have collection... how do I actually access each row/column?
I tried to find out the length or number of rows by going
collection.length... it didn't seem to like that at all.
-Daniel
On Mon, Mar 24, 2008 at 4:20 PM, Aaron Miller <
[EMAIL PROTECTED]> wrote:
> I always set the return result as Object in my handler then type it as
> the specific class later in the function. I'm not sure if I do this out of
> habit or necessity.
>
> # private function handleResult( result:Object ): void {
> # var collection:ArrayCollection = result as ArrayCollection;
> # }
>
> Also notice that I used ArrayCollection. If I remember correctly, record
> sets get returned as an ArrayCollection. If I am mistaken, try the above
> with a standard Array.
>
> Hope this helps,
> ~Aaron
>
>
> On Mon, Mar 24, 2008 at 3:07 PM, Daniel Tse <[EMAIL PROTECTED]> wrote:
>
> > Hi All,
> >
> > I have setup AMFPHP and it returns back the recordset object from a
> > MySQL query. I was wondering how I access that array/recordset from the flex
> > side.
> >
> > e.g. I have the following:
> >
> > <?php
> > //In the services directory of AMFPHP
> > class SimplePerson {
> > function getPeople() {
> > $mysql = mysql_connect(localhost, "root", "root");
> >
> > mysql_select_db( "people-test" );
> >
> > $sSQL = "SELECT * FROM `tblPeople`";
> >
> > $results = mysql_query($sSQL);
> >
> > return $results;
> > }
> > }
> >
> > ?>
> >
> > In Flex..
> > public function getPeople():void {
> > myService.connect(REMOTESERVERURL);
> >
> > var responder:Responder = new
> > Responder(getPeople_Result, onFault);
> > myService.call("SimplePerson.getPeople", responder);
> >
> > }
> >
> > public function
> > getPeople_Result(aoResults:WHAT_SHOULD_GO_HERE):void
> > {
> > //test;
> > //I'd like to access the result set e.g. iterate through
> > the rows looking at certain columns
> > }
> >
> > "Array" doesn't seem to work (the fact that it's a 1-dimensional array
> > doesn't help)
> > "XMLList" the object doesn't seem to map like that either
> >
> > Am I missing some kind of object?
> >
> > Thanks,
> > -Daniel
> > --
> > -------------
> > e: [EMAIL PROTECTED]
> > w: http://DanielTse.com/
> > -------------
> >
>
>
>
> --
> Aaron Miller
> Chief Technology Officer
> Open Base Interactive, LLC.
> [EMAIL PROTECTED]
> http://www.openbaseinteractive.com
>
>
--
-------------
e: [EMAIL PROTECTED]
w: http://DanielTse.com/
-------------
