> >1) Add dataType:'json' as an attribute of your ajax call, or use $.
> getJSON
> >2) use Firebug / console.log to examine the response, make sure DATA
> is a
> >valid property of the response JSON
> >
> >-- Josh
> >
> >
> >
> >I am trying to call a query from a CFC using jQuery with the
> following code:
> >
> >$(document).ready(
> > function () {
> > $.ajax({
> > type: "GET",
> > url: "SpellChecker.cfc?method=getTextMemoFields&returnformat=json
> > &queryformat=column",
> > data: datastring,
> > success:
> > function(response) {
> > var resp = jQuery.trim(response);
> > alert(resp);
> > }
> > });
> >
> >});
> >
> >When I look at the data inside an alert it looks exactly like it
> should.
> >However, when I try to get to the values inside of it (e.g. resp.
> DATA) it is
> >always undefined. Do I need to perform an extra step? I appreciate
> any
> >advice I can get on this.
> >
> >Thanks,
> >
> >JW
>
> Josh,
>
> 1. I already am getting the results back in JSON format using the
> returnformat=json parameter. I tried $.getJSON without much success
> (If you know of a good CFC example using $.getJSON, I'd be happy to
> review it). I cannot even get results back using it, where as with
> the $.ajax I get results, I just can't seem to do much with them but
> print the whole json object(i.e. document.write) to a page or display
> the results in an alert box.
>
> 2. I am Firebug and I did verify that DATA is a valid parameter.
> Basically I am returning a db table and putting in JSON format. The
> code I have returns the following:
>
> {"ROWCOUNT":20,"COLUMNS":["SAVEDVALUE"],"DATA":{"SAVEDVALUE":["blah,
> blah,blah"]}}
>
> But when I try and access for instance resp.ROWCOUNT, it's undefined.
> So basically, I want to know how I can actually get to the values I
> can only seem to read.
>
> Thanks,
>
> James
>
>
>
>
>
>
Josh,
I tried datatype: 'json' and get back the same string. I did look at it on
Firebug and got back a black URL instread of the green one like you said. I
have tried converting the string using the eval method to no avail. Do you
know if there is a string to JSON conversation method out there?
Thanks,
James
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323640
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
