Hi there.

I have a remoting app in which i use PHP/amfphp to get data into my app.

Now in my PHP I have the following SQL query performed to create a join on 2 tables...

SELECT dkcms_photo.*, dkcms_profiles.uFname FROM dkcms_photo LEFT JOIN dkcms_profiles ON dkcms_profiles.uId = dkcms_photo.phUsername ORDER BY phMod DESC

Now when I test the query (by running at the mysql command line), all the data is returned as expected.

I then test the php in the amfphp service browser and again - same thing all data is returned as expected.

Now - in flash....

When I try to access the one column name returned by the join - I get undefined. So I then used the "getColumnNames" function (and trace the results) to see what is actually being listed in flash.... Well as expected, none of the columns from the second table are actually making it into flash.

Does anyone have any ideas?

d
_______________________________________________
[email protected]
To change your subscription options or search the archive:
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Brought to you by Fig Leaf Software
Premier Authorized Adobe Consulting and Training
http://www.figleaf.com
http://training.figleaf.com

Reply via email to