cfajaxproxy / cfc Help Please

Answer 1

Without seeing an actual error, my guess is that your problem is with using an unscoped variable name the same as a function. Instead of and putting that just after the argument tag. Then later in your code use the countNew variable.

One other thing...please, plesae, plesae use cfqueryparam in your queries when you are passing in variables. This protects you from sql injection attacks (and improves performance). For instance:

<CFQUERY NAME="NoCountCK" DATASOURCE="MyDSN">
SELECT *
FROM Ideas
WHERE IdeaID = <cfqueryparam value="#arguments.VoteNo#">
</CFQUERY>

Answer 2

First, I think you're never calling the "NewCount" function in the MyCFC component. As the cfajaxproxy docs demonstrate (http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_a-b_3.html), you call cfajaxproxy, initialize a JavaScript object, and call a method on that object. So in your case it would be "cfc.NewCount(true)" (note this is case sensitive) after the "cfc.setCallbackHandler(getDataResult);".

Next, to check yourself, use Firefox with Firebug. This will allow you to easily JavaScript errors and AJAX requests. Load your page with Firebug running. Check the Firebug console for JavaScript errors. If it's complaining it can't find the library cfajax.js then you probably need to setup a web server mapping to the CFIDE directory - where ColdFusion keeps its various JavaScript files that it ships with.

Finally, click the "Vote" button. Check the AJAX requests in Firebug to see something's fired off. See what the response code is. Not 200? Open the request in the Firebug console to see the response HTML. You can right click the response to open in a new browser tab.

Answer 3

Ok I fixed the document.write overwriting the entire DOM by replacing document.write(result) with this var content = document.getElementById('NewCount').innerHTML=result;. This seems to keep the change within the <SPAN ID=" NewCount' > </SPAN> and not overwriting my page.

I fix why my cfc wouldn’t add the members vote in the CFQUERY “MemberVote" to the database. I was getting an “Error invoking CFC: Error Executing Database Query”. I had to re-label a field in the table. For some reason executing the table though the cfc didn’t work when it works outside the cfc.