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: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>
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
- Visit your group "flexcoders" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.