This should have everything you need. When I use the CFC the page just
runs and never loads. I end up with a error because it exceeded the time
limit. When I switch to a cfm page it loads instantly.
//Using CFC call - This does not work
<script type="text/javascript">
var XML_URL =
"../FunctionPages/Employers.cfc?method=GetEmployerResults";
//create a basic Spry DataSet
var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, "dataset/row", {
useCache: false });
//create a page-enabled view of the Spry DataSet var pvEmployers = new
Spry.Data.PagedView(dsEmployers, { pageSize: 12 });
</script>
//This is my CFC
<CFFUNCTION name="GetEmployerResults" access="remote" returntype="xml"
output="false">
<CFARGUMENT name="EmployerName" default="" />
<CFQUERY datasource="#request.dsource#" name="EmployerQry">
SELECT rtrim(FirstName) as FirstName, rtrim(LastName) as
LastName, rtrim(EmailAddress) as EmailAddress
FROM AMP_Employers
WHERE EmployerID > 0
</CFQUERY>
<cfset toXML = createObject("component", "toXML")>
<cfset EmployerXML = toXML.queryToXML(EmployerQry,
"dataset","row")>
<cfset parsedEmployerXML = xmlParse(EmployerXML) >
<cfcontent type="application/xml; charset=UTF-8">
<cfreturn parsedEmployerXML >
</CFFUNCTION>
//Using CFM call - This works
<script type="text/javascript">
var XML_URL = "../FunctionPages/Employers.cfm";
//create a basic Spry DataSet
var dsEmployers = new Spry.Data.XMLDataSet(XML_URL, "dataset/row",
{useCache: false });
//create a page-enabled view of the Spry DataSet var pvEmployers = new
Spry.Data.PagedView(dsEmployers, { pageSize: 12 });
</script>
//This is my cfm page
<CFQUERY datasource="#request.dsource#" name="EmployerQry"> SELECT
rtrim(FirstName) as FirstName, rtrim(LastName) as LastName,
rtrim(EmailAddress) as EmailAddress
FROM AMP_Employers
WHERE EmployerID > 0
</CFQUERY>
<cfset toXML = createObject("component", "toXML")>
<cfset EmployerXML = toXML.queryToXML(EmployerQry, "dataset", "row")>
<cfset parsedEmployerXML = xmlParse(EmployerXML) >
<cfcontent type="application/xml; charset=UTF-8">
<CFOUTPUT>#parsedEmployerXML#</CFOUTPUT>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275099
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
