Question
cfsprydataset with JSON; can't display data
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?
<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?
