RE: [flexcoders] Use two DataBase tables values in a Datagrid

2007-09-30 Thread Terri J.
I did this by combining my tables, joined via SQL query and then passed the
results back to the datagrid. 

-Terri J.

 -Original Message-
 From: flexcoders@yahoogroups.com 
 [mailto:[EMAIL PROTECTED] On Behalf Of jack4sol
 Sent: Wednesday, September 19, 2007 5:18 AM
 To: flexcoders@yahoogroups.com
 Subject: [flexcoders] Use two DataBase tables values in a Datagrid
 
 The issue is I need to populate values from 2 tables, one 
 needs to be a list of names(from 1 table) and the other a 
 dropdown box containing dynamic values(and this needs to be 
 done from another table)
 
 Mainly, gettin 2 columns from different tables in one 
 grid...is this possible firstly?
 
 Please suggest ways to do the same..  

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.488 / Virus Database: 269.13.33/1036 - Release Date: 9/28/2007
3:40 PM
 



--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com 
Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/

* Your email settings:
Individual Email | Traditional

* To change settings online go to:
http://groups.yahoo.com/group/flexcoders/join
(Yahoo! ID required)

* To change settings via email:
mailto:[EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]

* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]

* Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
 


Re: [flexcoders] Use two DataBase tables values in a Datagrid

2007-09-19 Thread Giles Roadnight
I think the best way around that is to combine both sets of data into 1
ArrayCollection tha tpopulates the dtagrid.

On 9/19/07, jack4sol [EMAIL PROTECTED] wrote:

   The issue is I need to populate values from 2 tables, one needs to be
 a list of names(from 1 table) and the other a dropdown box containing
 dynamic values(and this needs to be done from another table)

 Mainly, gettin 2 columns from different tables in one grid...is this
 possible firstly?

 Please suggest ways to do the same..

  




-- 
Giles Roadnight
0797 4340702
http://giles.roadnight.name


Re: [flexcoders] Use two DataBase tables values in a Datagrid

2007-09-19 Thread Paul Andrews
- Original Message - 
From: jack4sol [EMAIL PROTECTED]
To: flexcoders@yahoogroups.com
Sent: Wednesday, September 19, 2007 10:18 AM
Subject: [flexcoders] Use two DataBase tables values in a Datagrid


 The issue is I need to populate values from 2 tables, one needs to be
 a list of names(from 1 table) and the other a dropdown box containing
 dynamic values(and this needs to be done from another table)

 Mainly, gettin 2 columns from different tables in one grid...is this
 possible firstly?

 Please suggest ways to do the same..

You don't say how the data is getting from the database to the flex app.

You could have a view on the database that includes the columns from two 
tables.
Server-side you could read from the two tables and amalagmate the data 
before passing to flex.
You could pass the data separately to flex from the server and amalgamate it 
there.

or

You could..


Paul