Yes and no but mostly no. You will need to feed the grid the data and the way that most apps like this work is that you must feed it structured data in the form of XML or JSON. Technically you do not have the create a physical file and can pass it a "document" on the fly via <CFcontent>. But if you are asking: Can you feed it a raw record set from CFQuery with out an intermediary format the answer is no. It needs to be in a format that dhtmlxGrid will understand. In this case XML.
HTH G! On Tue, Mar 19, 2013 at 4:09 PM, Mallory Woods <[email protected]>wrote: > > Hi all, > > I'm trying to use dhtmlxGrid in one of my projects and I had a question. > > What I would like to do is run a query or stored procedure, get the > resulting data set and then have the results formatted for use in > dhtmlxGrid. I don't need to write data back to the DB I am just need to > display them. > > I have gotten the demo to work with basic text and the xml file > > (http://docs.dhtmlx.com/doku.php?id=tuto ... populating) > > However, is there a way to take the query results and pass them directly to > dhtmlxGrid directly without having to write the data to a file and then > reading it? > > I have tried something like this: > > var mygrid; > function doInitGrid(){ > > mygrid = new dhtmlXGridObject('mygrid_container'); > mygrid.setImagePath("codebase/imgs/"); > mygrid.setHeader("Model,Qty,Price"); > mygrid.setInitWidths("*,150,150"); > mygrid.setColAlign("left,right,right"); > mygrid.setSkin("light"); > mygrid.init(); > mygrid.parse(<cfoutput>#xmlString#</cfoutput>); > xmlString is a valid XML object but the grid does not format like this. The > source comes out like this: > > var mygrid; > function doInitGrid(){ > > mygrid = new dhtmlXGridObject('mygrid_container'); > mygrid.setImagePath("codebase/imgs/"); > mygrid.setHeader("Model,Qty,Price"); > mygrid.setInitWidths("*,150,150"); > mygrid.setColAlign("left,right,right"); > mygrid.setSkin("light"); > mygrid.init(); > mygrid.parse(<?xml version="1.0" encoding="UTF-8"?> > <users columns="3" rows="3"><user fname="Nathan" id="292B71DC-9DDD-BA4F- > A95BF84F85CAF661" lname="Dintenfass"/><user fname="Ben" > id="292B71DD-0893-326D- 79269A1DCFD46D37" lname="Archibald"/><user > fname="Raymond" id="292B71DE-E781-43FE- A4DCD955A1A5C044" > lname="Jones"/></users>); > > } > Thanks in advance! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:355114 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
