Skip to main content
Known Participant
May 10, 2008
Question

cfsprydataset with JSON; can't display data

  • May 10, 2008
  • 1 reply
  • 308 views
I've recently started working with the cfsprydataset tag and have gotten past a few hurdles. I'm prototyping an 'autosuggest' function against a JSON format spry dataset which is created in a CFC. Here's my cfsprydataset call:

<cfsprydataset
name="dsPeople"
type="JSON"
options='{method: "POST", path:"DATA", pathIsObjectOfArrays: "true"}'
bind="URL:IncrementalSearch.cfc?method=getPeople&partialName={frmSearch:search@keyup}&queryFormat=Column"
>

this does seem to be working as I can review the dataset returned in Firebug. It looks like this after I type in the letter "s" into the "search" input field.

"{\"COLUMNS\":[\"LCE_FAMILIES_ID\",\"LASTNAME\",\"INITIAL\",\"FIRSTNAME\"],\"DATA\":[[345,\"Schiralli

\",null,\"Evan\"],[423,\"Schiralli\",null,\"Evan\"],[603,\"Schiralli\",null,\"Evan\"],[754,\"Searcy\"

,null,\"Sean\"],[755,\"Searcy\",null,\"Sean\"],[176,\"Sibson\",\"E\",\"Thomas\"],[256,\"Simpson\",\"C

\",\"Harry\"],[614,\"Sinatra\",null,\"Kyle\"],[908,\"Sinatra\",null,\"Kyle\"],[637,\"Smith\",\"D\",\"Matthew

\"],[52,\"Sokolis\",\"R\",\"Wanda\"],[776,\"Spitzer\",null,\"Myrtle\"],[812,\"Stahler\",\"E\",\"Lauren

\"],[355,\"Stamps\",null,\"Sara\"],[469,\"Stefek\",\"M\",\"Sabrina\"],[481,\"Stephens\",\"S\",\"Ian\"

],[484,\"Street-Blume\",\"K\",\"Jordan\"],[618,\"Swager\",null,\"Quentia\"],[894,\"Swager\",null,\"Quentia

\"],[146,\"Sward\",\"E\",\"David\"]]}"

But when I use the following code, I cannot get any of the data in the dataset to display. Anyone know what I'm missing?
This topic has been closed for replies.

1 reply

lchalnickAuthor
Known Participant
May 12, 2008
Anyone doing cfsprydataset (bind to CFC/URL) successfully w/JSON ?

If so, could you please post an example?