Scott Stroz put a function on CFLib.org that can help. http://cflib.org/udf/queryConvertForjqGrid
He wrote it to convert a query to a json format for jQuery's jqGrid plugin, but I started using it this week to send json data for jQuery templates. It only took a slight tweak since the jQuery template did not need the extra page and total record information that jqGrid needs. Geoffrey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
