I created a search page that allows the admin to search for accounts in
the database. When they first come to the search screen all accounts in
the database are returned and presented to them. The xml document that
SPRY reads gets generated with all accounts in the DB. When the admin
conducts a search, I create a XML document only with the results
returned and then overwrite the original XML document. Works Perfectly.
The problem is the browser after the search is conducted still sees all
accounts even though the XML document only shows the results searched
for. Below is some code:
I am running a cf component that returns a list of accounts and puts it
into and XML document like below.
<CFQUERY>
SELECT BLAH
FROM BLAH
WHERE BLAH = BLAH
</CFQUERY>
<CFXML VARIABLE="RecruitmentResults">
<Recruitments>
<CFOUTPUT query="Recruitments" >
<Recruitment ID="#RecruitmentID#">
<firstname>#htmleditformat(trim(FirstName))#</firstname>
<lastname>#htmleditformat(trim(LastName))#</lastname>
<company>#trim(CompanyName)#</company>
<country>#trim(Country)#</country>
<WantedPosition>#trim(WantedPosition)#</WantedPosition>
</Recruitment>
</CFOUTPUT>
</Recruitments>
</CFXML>
<CFFILE ACTION="write"
FILE="#Request.XMLRoute#/Administrator_#Session.AdminID#/Recruitments.xm
l" OUTPUT="#ToString(RecruitmentResults)#" nameconflict="overwrite">
This is the part of my result page that is outputting the results.
<!--
var pageOffset = 0;
var pageSize = 50;
var pageStop = pageOffset + pageSize;
<CFOUTPUT>
var dsRecruitments = new
Spry.Data.XMLDataSet("../DisplayPages/admin/Administrators/Administrator
_#Session.AdminID#/Recruitments.xml","Recruitments/Recruitment", {
filterFunc: MyPagingFunc }, {useCache:false});
</CFOUTPUT>
function MyPagingFunc(ds, row, rowNumber)
{
if (rowNumber < pageOffset || rowNumber >= pageStop)
return null;
return row;
}
function UpdatePage(offset)
{
var numRows = dsRecruitments.getUnfilteredData().length;
if (offset > (numRows - pageSize))
offset = numRows - pageSize;
if (offset < 0)
offset = 0;
pageOffset = offset;
pageStop = offset + pageSize;
// Re-apply our non-destructive filter on dsStates1:
dsRecruitments.filter(MyPagingFunc);
}
-->
</script>
<div id="Recruitment_Div" spry:region="dsRecruitments">
<table id="Recruitment_Table" class="datagrid" width="100%"
border="0" cellspacing="0" cellpadding="0">
<tr class="FormBar">
<th onclick="dsRecruitments.sort('lastname','toggle');"
align="left" class="LeftBorder" style="cursor:pointer"> Contact
Name</th>
<th onclick="dsRecruitments.sort('company','toggle');"
width="350" align="left" style="cursor:pointer">Company Name</th>
</tr>
<tbody>
<tr bgcolor="#Request.Row1Color#" spry:repeat="dsRecruitments"
class="FormBody2">
<td width="125" align="left" valign="middle" class="LeftBorder">
{firstname} {lastname}
</td>
<td width="350" valign="middle">
{company}
</td>
</tr>
</tbody>
</table>
</div>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266799
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
