Hi,
     This is Sreedhar. I am working with Flex Builder 2, 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 results. I am having a problem when displaying these results in a Flex DataGrid. If my search yields only one result, the result is displayed in the DataGrid properly. However, if there are multiple results, the DataGrid is blank. I was able to get this to work in Beta 3, but after migrating to the final version, it no longer works. I am pretty sure that the problem has to do with this change that is listed on the changes page: Arrays are wrapped in mx.utils.ArrayCollection instances. However, taking this into account, I still can't fix the problem.
 
/*********FlexCode********************/
<mx:HTTPService id="selectdata" url=""http://localhost:8080/Essential2/SelectData.jsp">http://localhost:8080/Essential2/SelectData.jsp">
      <mx:request>
        <key1>{key1.text}</key1>
      </mx:request>
    </mx:HTTPService> 
     <mx:ArrayCollection id="emp"
        source="{mx.utils.ArrayUtil.toArray(selectdata.lastResult.userinfo)}"/>
 
<mx:DataGrid x="10" width="731" showHeaders="true"  bottom="10" top="210" id="filteredGrid" dataProvider="{emp}" click="displayimg();"
                dropEnabled="false"
                dragEnabled="true" >
    
    
   
    <mx:columns>
                    <mx:Array>
                   
                    <mx:DataGridColumn dataField="title" headerText="Title"/>
                    <mx:DataGridColumn dataField="rating" headerText="Rating"/>
                    <mx:DataGridColumn dataField="category" headerText="Category"/>
                    <mx:DataGridColumn dataField="filetype" headerText="File Type"/>
                    <mx:DataGridColumn dataField="price" headerText="Price"/>
                    <mx:DataGridColumn dataField="logopath" headerText="LogoPath" visible="false"/> 
                    <mx:DataGridColumn dataField="subcategory" headerText="SubCategory" visible="false"/>
                    <mx:DataGridColumn dataField="websiteurl" headerText="WebsiteUrl" visible="false"/>
                    <mx:DataGridColumn dataField="feeddescription" headerText="FeedDescription" visible="false"/>
                    <mx:DataGridColumn dataField="filepath" headerText="FilePath" visible="false"/>
                    <mx:DataGridColumn dataField="keywords" headerText="Keywords" visible="false"/>
                    <mx:DataGridColumn dataField="contentrating" headerText="ConentRating" visible="false"/>
                  
                    </mx:Array>
            </mx:columns>
   </mx:DataGrid>
/***************************************/
/*********JSP Code******************/
 
<%
while (rs.next())
   {
  
       str1 = rs.getString(1);
    str2 = rs.getString(2);
    str3 = rs.getString(3);
       str4 = rs.getString(4);
    str5 = rs.getString(5);
    str6 = rs.getString(6);
    str7 = rs.getString(7);
    str8 = rs.getString(8);
    str9 = rs.getString(9);
    str10 = rs.getString(10);
    str11 = rs.getString(11);
    str12 = rs.getString(12);
    str13 = rs.getString(13);
    
  
 
 %>

<userinfo>
<author><%=str1%> <%=str2%></author>
<title><%=str3%></title>
<rating><%=str4%></rating>
<category><%=str5%></category>
<filetype><%=str6%></filetype>
<price><%=str7%></price>
<logopath><%=str8%></logopath>
<subcategory><%=str9%></subcategory>
<websiteurl><%=str10%></websiteurl>
<feeddescription><%=str11%></feeddescription>
<filepath><%=str12%></filepath>
<keywords><%=keyword%></keywords>
<contentrating><%=str13%></contentrating>
</userinfo>

<%
}
%>
/****************************************/

If anyone can help out, I would greatly appreciate it.
 
Thanks & Regards,
                     Sreedhar


Thanks & Regards,
Sreedhar


Find out what India is talking about on Yahoo! Answers India.
So, whatÂ’s NEW about the NEW Yahoo! Messenger? Find out. __._,_.___

--
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