How can I show a join table in a datagrid in Flex using LCDS
+1
A:
By table you mean a database table, right?
Join the tables in an SQL query on the server; then send that query back to Flex already joined. Many people will turn it into an array of value objects.
www.Flextras.com
2010-06-15 11:31:31
Thank you for your answer, can you point me to any example/tutorial on how to do it?
Adnan
2010-06-15 12:26:53
www.Flextras.com
2010-06-15 14:18:54
Well that is OK, but how to use value objects for joining tables?
Adnan
2010-06-15 15:40:32
You wouldn't use a Value Object for joining tables, you would use an SQL Join. Query your database using any SQL you prefer and you'll get back a recordset. Most people would turn that recordset into Value Objects using a loop. Return the finished array of Value Objects to Flex. If you're using ColdFusion; you can return the recordset (AKA Query Object) directly to Flex w/o turning it into a VO.
www.Flextras.com
2010-06-15 16:03:31