Title: RE: thickbox + ajaxproxy.cfc
Thread: thickbox + ajaxproxy.cfc
Forum: Need Help?
Conference: ColdBox
User: bash Still no joy. I took thickbox out of the equation and it still doesn't work.
Does the ajaxproxy have to invoke the same handler used to call the view?
Here is the modified code I'm using:
[code]
<script type="text/javascript"
src="/includes/js/ajax/jquery.js"></script>
<script type="text/javascript"
src="/includes/js/ajax/jquery.cfjs.js"></script>
<script type="text/javascript"
src="/includes/js/ajax/jquery.AjaxCFC.js"></script>
<script
type="text/javascript">
$.AjaxCFCHelper.setDebug(false);
$.AjaxCFCHelper.setBlockUI(false);
$.AjaxCFCHelper.setUseDefaultErrorHandler(false);
$.AjaxCFCHelper.setSerialization('json');
</script>
<script
language="javascript">
<!--
// Machines
function wmt_getMachines() {
var
wcData = $('#workcenter').val();
wmt_hideError();
if (wcData != 0) {
var
_Obj = {"wc":wcData};
$.AjaxCFC({
url: "ajaxproxy.cfc",
method:
"station.getMachineList",
data: _Obj,
unnamedargs: false,
serialization: "json",
success: function(myQuery) {
$.dump(myQuery);
}
});
} else {
wmt_disableForm();
wmt_showError('You must pick a
lean code');
}
}
[/code]
Here is the station.getMachineList code:
[code]
<cffunction name="getMachineList" access="public" returntype="void"
output="false">
<cfargument name="Event"
type="coldbox.system.beans.requestContext">
<cfset var result = '' />
<cfset result =
createobject('component','model.hour').getMachineList(event.getValue('wc')) />
<cfreturn result />
</cffunction>
[/code]
Here is the model.hour
getMachineList code:
[code]
<cffunction name="getMachineList" access="public"
output="no" returntype="query">
<cfargument name="wc" required="yes">
<cfset var machines = '' />
<cfquery name="machines"
datasource="wmtScoreboard">
SELECT mID,mDescription
FROM tbl_machine
WHERE mWorkcenterID = #arguments.wc#
ORDER BY mDescription
</cfquery>
<cfreturn machines>
</cffunction>
[/code]
Here is the error
being thrown:
Invalid data ajaxproxy.cfc for CFSQLTYPE CF_SQL_INTEGER.
Here
is the post info from firebug:
c0-id 8309_1201207841069
c0-methodName
station.getMachineList
c0-param0 {"wc":"1"}
c0-serialization0 json
engine
jquery
method __initialize_AjaxCFC
serialization json
As I said, I'm
complete noob to Coldbox and OO so it is probably something stupid I'm doing. At
any rate, I greatly appreciate any and all help.
http://www.luismajano.com/forums/index.cfm?event=ehMessages.dspMessages&threadid=A906D9AE-FF65-CEF6-659C88F3948B39EC