So I'm trying to use a grid component - either jqGrid of flexigrid.
Both seem very nice.

But both expect the JSON data to be returned in a specific format..

Example... flexigrid is looking for an object containing "page"
"total" and "rows" where rows is an array.

So my cfc does this:

        <cfset LOCAL.retVal = structNew()>
        <cfset LOCAL.retVal.page = 1>
        <cfset LOCAL.retVal.total = LOCAL.qry.recordCount >
        <cfset LOCAL.retVal.rows = 
application.udf.QueryToArrayOfStructures(LOCAL.qry)>
        <cfcontent type="text/plain" reset="yes">
        <cfreturn LOCAL.retVal />

and the problem here is that coldfusion upper cases the structure
elements, so I end up with "PAGE" "TOTAL" and "ROWS" which of course
it doesn't like because JS is case sensitive.

What do I do?


-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:325413
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to