Re: Coldfusion and dhtmlxGrid
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 mallory.wo...@gmail.comwrote:
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=3user 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
Re: Coldfusion and dhtmlxGrid
Thanks for the reply. I think I'm on the XML bus for now.
On Wed, Mar 20, 2013 at 1:14 PM, Gerald Guido gerald.gu...@gmail.comwrote:
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 mallory.wo...@gmail.com
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=3user 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:355115
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF JasperSoft 5 integration via web services
We're integrating JasperReports Server 5 into our sites. There's two ways to do this, via iFrame and via web services. The iFrame method has some issues that make it less than ideal for us for most pages, which I can get around using the web services instead. There's a downloadable wrapper for the web services for PHP and having watched the tutorial on integration with PHP, something similar seems necessary for CF as well. There's no CF wrapper on the Jaspersoft Exchange, so I'm hoping that someone here has built one that he/she/it can share. I've searched the Jaspersoft support forums and most of the CF questions predate the existence of the web services that we need to leverage; most CF posts are from 2006 or earlier. ;) Has anyone built a wrapper or even a sample of CF-JasperReports 5 integration that I could mooch or otherwise use as a launching point? I can rebuild the PHP wrapper in CF but that would require looking at a whole lot of PHP, which totally has cooties. Thanks! -- My wrench of vengeance awaits! ~| 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:355116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Adobe CTO Kevin Lynch leaving company for Apple
Huh, well how 'bout that? Adobe has sent word to The Next Web that effective March 22, Lynch will be exiting the company for a position at Apple: http://appleinsider.com/articles/13/03/19/adobe-cto-kevin-lynch-reportedly-l eaving-company-for-apple Also, a follow up article: http://appleinsider.com/articles/13/03/19/why-did-apple-hire-adobe-cto-kevin -lynch ~| 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:355117 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: same URL if moving app to new CF instance ?
Thanks, all. Good ideas for testing. Regards, Chris On Fri, Mar 15, 2013 at 6:05 PM, Dave Watts dwa...@figleaf.com wrote: We have a number of applications running on one instance of CF9, coming through three IIS v6 Web Sites (host headers separate the requests which are to three different Fully Qualified Domain Names(FQDNs)). As I understand, with the Web Server Configuration Tool I'm mapping one or more IIS Web Sites to one and only one CF instance. So if we move the high-resource app from its current CF instance to a new instance, I need to do something so the IIS Web Site knows which CF instance to send the request. But if the IIS Web Site is mapped to only one CF instance, I can't do that. Our customer would like the URL (FQDN and directories) to remain the same. You'll have to run the Web Server Configuration tool (wsconfig) to disconnect your IIS virtual server from the existing CF instance, and connect it to the new CF instance. Nothing else needs to change in IIS, including URLs. It's possible that you currently have your existing instance connected using the All web sites option with IIS, in which case you'll need to use wsconfig to delete that configuration and create individual connections for each IIS virtual server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| 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:355118 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
