title: How to format a json feed from coldfusion to jquery fullcalendar?
body: <p>I am trying to get a json feed working for the jquery Full Calendar plugin but I am not having much luck.  The data I get back from coldfusion is not formatted correctly (at least that is my guess).  Here is what I am getting back:</p>
  
  <pre><code>{"COLUMNS":["TITLE","START","END","REQUEST_TYPE_ID"],"DATA":[["duration of a VTC ","2012-03-15T12:00:00Z","2012-03-15T15:00:00Z",1],["a new vtc overlap","2012-03-15T11:45:00Z","2012-03-15T14:15:00Z",1]]} 
  </code></pre>
  
  <p>I am pretty sure full calendar does not know how to read this data type.  So the question is, can I get CF to pass back the data in a format that full calendar will accept?  Is there something else going on here?</p>
  
  <p>Here is my component:</p>
  
  <pre><code>&lt;cfquery datasource="#arguments.dsn#" name="eventlist"&gt;
  select title, to_char(start_time,'YYYY-MM-DD')||'T'||to_char(start_time,'HH24:MI:SS')||'Z' as "start", 
  to_char(start_time,'YYYY-MM-DD')||'T'||to_char(start_time + (duration/1440),'HH24:MI:SS')||'Z' as "end", request_type_id
  from ((request r join event_schedule es on es.request_id = r.id)left join location_ref loc on loc.location_id = r.location_id) 
  where site_id = &lt;cfqueryparam value="#arguments.site_id#" cfsqltype="cf_sql_varchar" /&gt;
  and request_type_id = &lt;cfqueryparam value="#arguments.evnttype#" cfsqltype="cf_sql_varchar" /&gt;
  and start_time between to_date('#sdate#', 'mon dd yyyy') and to_date('#edate#', 'mon dd yyyy')
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>and the return format is json.</p>
  
  <pre><code>returnformat="json"
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks!</p>