[flexcoders] Problem with displaying exactly one item in a DataGrid.

Tue, 20 Jun 2006 07:36:06 -0700

Hi,
 
  This is Sreedhar. I am working with Flex Builder 2 Beta 3, Java Server Pages, and SQL Server 2005. Currently, I am working on "Search based on Keyword". When I execute the search through the JSP, I am able to see the proper results. I am having a problem when displaying these results in a Flex DataGrid. If my search yields more than one result, the results are displayed in the DataGrid properly. However, if there is only one result, the DataGrid is blank.
 
/******************The Query in JSP *************************/
ResultSet rs = st.executeQuery("select User_FirstName, User_LastName, Podcast_Name, Rating, Category, FileType, Subscription_Fee, LogoPath, Sub_Category, Website_Url, FeedDescription, FilePath, Keywords  from User_Info U, Podcast_Info P where U.User_ObjId = P.User_ObjId and P.Keywords like '%" +keyword+ "%'");
 
/*************************************************************/
 
We are using an ArrayCollection as follows:
 
<mx:HTTPService id="selectdata" url=""http://localhost:8080/Essential2/SelectData.jsp">http://localhost:8080/Essential2/SelectData.jsp"
   result="emp = new ArrayCollection(selectdata.lastResult.userinfo)">
     <mx:request>
        <key1>{key1.text}</key1>
      </mx:request>
    </mx:HTTPService>
 
*Emp is the DataProvider for the DataGrid.
 
I suspect the error is in the MXML, as the query executes correctly in JSP. If anyone has any suggestions, it would be greatly appreciated.


Thanks & Regards,
Sreedhar

Yahoo! India Answers: Share what you know. Learn something new Click here
Send free SMS to your Friends on Mobile from your Yahoo! Messenger Download now __._,_.___

--
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
Web site design development Computer software development Software design and development
Macromedia flex Software development best practice

YAHOO! GROUPS LINKS



__,_._,___

Reply via email to