Hi Ray,
i have tried another method where i hardcoded the data but still showing that
wiered message of dev environement : " <META NAME="ColdFusionMXEdition"
CONTENT="ColdFusion DevNet Edition - Not for Production Use."> "
so i have used the following in ajax :
$.ajax({
url: 'hardcoded-jsondata.cfm',
dataType: 'json',
type: 'GET',
success: function(res){
$("#example6grid").handsontable("loadData", res.data);
}
});
and my hardcoded-jsondata.cfm looks like :
<cfquery name="result" datasource="#dsn1#">
SELECT PROJECT_ID,PROJECT_NAME FROM TBL_PROJECT WHERE PROJECT_ID='20'
</cfquery>
<cfsavecontent variable="json">
{"data": [
<cfoutput query="result"> ["#PROJECT_ID#","#PROJECT_NAME#"], </cfoutput>
]}
</cfsavecontent>
<!--- output saved content and remove the final unnecessary comma --->
<cfoutput>#Reverse(Replace(Reverse(json),",","","one"))#</cfoutput>
Other thing is when i use a file with raw data example this works..
Any thought ?
>i put the 3 files under gist.github.com.
>https://gist.github.com/4119669
>
>Please let me know.
>
>
>
>>Use Pastebin or gist.github.com and I'll take a look. Also - is it online
>>where I can run it?
>>
>>
>>
>>
>>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5987
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
