tags:

views:

82

answers:

1
+1  Q: 

join table in Flex

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
Thank you for your answer, can you point me to any example/tutorial on how to do it?
Adnan
www.Flextras.com
Well that is OK, but how to use value objects for joining tables?
Adnan
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