RE: [flexcoders] syntax issue

[Tracy Spratt]

When you run that query in Query Analyzer or its equivalent, do you get a table that looks like you expect?   If so, then move down the line and in a result handler function, inspect the actual structure and content of the result object.  You need to make sure you have the data you expect.   Tracy   From: flexcoders@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of bghoward3 Sent: Tuesday, September 19, 2006 1:29 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] syntax issue   i am trying to use a query as follows SELECT * FROM tblUserDirectory, tblUser, tblTeamMember WHERE tblUserDirectory.intUserID = tblUser.intUserID AND tblTeamMember.intUserID = tblUser.intUserID ORDER BY strUserLastName selecting everything form 3 differnt tables, using a master data grid and the SelectedItem command i am able to populate fields in a custom tab component, no problem, the problem is that only one table seems to be acceisble in using the "SelectedItem: command when i call <mx:GridItem width="100%" height="100%"> <mx:TextArea width="400" htmlText="{masterList.selectedItem.strUserFirstName}" height="19"/> </mx:GridItem> it works, but when it gets to another element; <mx:GridItem width="100%" height="100%"> <mx:TextArea width="400" htmlText="{masterList.selectedItem.strAddrLine1}" height="19"/> </mx:GridItem> i have no luck populating note: strAddrLine1 is fouind in table tblUserDirectory note: strUserFirstName is found in table tblUser any ideas? thanks __._,_.___ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Software development tool Software development Software development services Home design software Software development company Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___