spry and ColdFusion

I am about to pull my hair out.  What am I doing wrong?  The page returns with no errors and the table is empty of data.  All I have on the page is the table headers and no table rows after it. Firebug says I am returning data: {"COLUMNS":["JOBNUM","EMPLOYEENUM"],"DATA":[[1049,3010],[1049,3160],[1049,3170],[1049,3170],[1049,3170 ],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049 ,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170]]}   <script type="text/javascript" src="SpryAssets/xpath.js"></script> <script type="text/javascript" src="SpryAssets/SpryData.js"></script> <script type="text/javascript" src="SpryAssets/SpryJSONDataSet.js"></script> <cfsprydataset name="mydata2" type="json" bind="cfc:jobNotes.getSteps()"> <div spry:region="mydata2"> <table width="100%" border="1">   <tr>     <th>Job Num</th>     <th>Employee Num</th>   </tr>   <tr spry:repeat="mydata2" >     <td>{mydata2::JOBNUM}</td>     <td>{mydata2::EMPLOYEENUM}</td>   </tr> </table>   </div>

What is up with this? If I use <cfsprydataset> to get the json data, the data starts off with ] {"COLUMNS":["DEPT",.... etc. If I use javascript to get the data ie. var mydata = new Spry.Data.JSONDataSet The page works and the json data starts with "ROWCOUNT". {"ROWCOUNT":3,"COLUMNS":["DEPT",.... etc. Why no ROWCOUNT when using cfsprydataset? <cfsprydataset name="mydata2" type="json" bind="cfc:jobNotes.getSteps()"> I am about to pull my hair out.  What am I doing wrong?  The page returns with no errors and the table is empty of data.  All I have on the page is the table headers and no table rows after it. Firebug says I am returning data: {"COLUMNS":["JOBNUM","EMPLOYEENUM"],"DATA":[[1049,3010],[1049,3160],[1049,3170],[1049,3170],[1049,3170 ],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049 ,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170],[1049,3170]]}   <script type="text/javascript" src="SpryAssets/xpath.js"></script> <script type="text/javascript" src="SpryAssets/SpryData.js"></script> <script type="text/javascript" src="SpryAssets/SpryJSONDataSet.js"></script> <cfsprydataset name="mydata2" type="json" bind="cfc:jobNotes.getSteps()"> <div spry:region="mydata2"> <table width="100%" border="1">   <tr>     <th>Job Num</th>     <th>Employee Num</th>   </tr>   <tr spry:repeat="mydata2" >     <td>{mydata2::JOBNUM}</td>     <td>{mydata2::EMPLOYEENUM}</td>   </tr> </table>   </div>

When it comes to queries and JSON, CF supports two forms. See the SerializeJSON function for more info. When you just use Spry (I mean on the client, no CF8 Ajax stuff), you can specify the type hen you create the data set. For an example, see Lighthouse Pro (lighthousepro.riaforge.org). On Wed, Apr 9, 2008 at 2:50 PM, Chad Gray <cgray@careyweb.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

Find any solutions Chad? I too have not had luck using cfsprydataset with JSON data. I'm binding to the CFC via the URL rather than directly to the CFC. ----- Excess quoted text cut - see Original Post for more ----- , ----- Excess quoted text cut - see Original Post for more -----    > <tr>      > <th>Job Num</th>      > <th>Employee Num</th>    > </tr>    > <tr spry:repeat="mydata2" >      > <td>{mydata2::JOBNUM}</td>      > <td>{mydata2::EMPLOYEENUM}</td>    ----- Excess quoted text cut - see Original Post for more -----

I had the same result. I was working w/ Todd back at cfobjective and for the life of me, I couldn't get it to work. When I switched to _not_ using cfsprydataset, it worked like a charm. I'm thinking it's a bug. On Tue, May 13, 2008 at 12:57 PM, Le ----- Excess quoted text cut - see Original Post for more ----- -- =========================================================================== Raymond Camden, VP of Software Dev, Broadchoice Email : ray@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org

Hi, I have a similar combination which works fine for me. What are you doing in the cfc exactly? If you can give me the entire repro case it will be easier to fix the issue. Thanks, Bhakti ________________________________ Sent: Wed 5/14/2008 12:14 AM To: CF-Talk Subject: Re: spry and cf I had the same result. I was working w/ Todd back at cfobjective and for the life of me, I couldn't get it to work. When I switched to _not_ using cfsprydataset, it worked like a charm. I'm thinking it's a bug. On Tue, May 13, 2008 at 12:57 PM, Le ----- Excess quoted text cut - see Original Post for more ----- -- =========================================================================== Raymond Camden, VP of Software Dev, Broadchoice Email : ray@camdenfamily.com Blog : www.coldfusionjedi.com AOL IM : cfjedimaster Keep up to date with the community: http://www.coldfusionbloggers.org <http://www.coldfusionbloggers.org/>;

I don't have the code right now. I do know it was hitting a CFC that returned a query object. Can you perhaps post your code for now, and later on I'll compare to mine? On Wed, May 14, 2008 at 2:21 AM, Bhakti Pingale <bhakti@adobe.com> wrote: ----- Excess quoted text cut - see Original Post for more -----