Re: Where do i find CFGRID Code?
So here's my question: [A] do you think the cause of this problem is that the location of the CFGRID code is non-standard and therefore i need to use the scriptsrc= attibute of the CFFORM tag? Yes, I think that's the cause, although honestly I don't know whether changing SCRIPTSRC works with the Java grid. [B] If yes, where is it to be found? what am i looking for? /CFIDE/classes/* 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 ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Here is the relevant code: ! First collect the data from the database --- cfquery name=qtestquery datasource=#application.dsn# select EmployeeID, GivenName, Surname, Bundyno from dbo.tblEmployee /cfquery ! Do a dump of the data to prove the query object exists and there are records to display cfdump var=#qtestquery# label=TestQuery !--- Open the CFFORM tag, using the ScriptSrc attribute, using an absolute path, not a relative one cfform name=Form1 action=submit.cfm scriptsrc=/cfide/scripts cfinput type=text name=Testfield value=#application.applicationname# label=Test of the cfforms validate=email message=Checking the validation/ cfgrid name=employee_grid query=qtestquery selectmode=single cfgridcolumn name=EmployeeID cfgridcolumn name=GivenName cfgridcolumn name=Surname /cfgrid br cfinput name=submitit type=Submit value=Submit /cfform If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 22, 2010 at 2:18 AM, Dave Watts dwa...@figleaf.com wrote: So here's my question: [A] do you think the cause of this problem is that the location of the CFGRID code is non-standard and therefore i need to use the scriptsrc= attibute of the CFFORM tag? Yes, I think that's the cause, although honestly I don't know whether changing SCRIPTSRC works with the Java grid. [B] If yes, where is it to be found? what am i looking for? /CFIDE/classes/* 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 ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Well, first, a bit of clarification. shard.adcalpos.net is not a subdomain. adcalpos.net is a domain, and shard is a hostname (A record) within that domain. If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Each virtual host you have on your web server needs to have a virtual directory pointing to /CFIDE. If you visit the two links, and view source, you'll see something like this: embed type=application/x-java-applet;version=1.3 pluginspage=http://java.sun.com/j2se/1.3/jre/index.html; code=coldfusion.applets.CFGridApplet.class archive=/CFIDE/classes/cfapplets.jar mayscript=true width=300 height=300 autowidth=false griddata=1%02Les%02Mustafa%02%013%02Troy%02Heron%02 griddescription=3%022%02300%02300%020%020%020%02%03%02%03%02%03%02%03%02%03%02S%020%02%03%02%03%02%03%02%03%02Y%02Y%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02N%02insert%02delete%02SortAsc%02SortDesc%01EmployeeID%02Y%02N%02Employeeid%01GivenName%02Y%02N%02Givenname%01Surname%02Y%02N%02Surname cf_form_name=Form1 cf_param_name=__CFGRID__Form1__employee_grid noembedb Browser must support Java to view ColdFusion Java Applets/b/noembed /embed Note the archive path. That has to be a valid URL. This is a valid URL: http://adcalpos.net/CFIDE/classes/ This is not (yet): http://shard.adcalpos.net/CFIDE/classes/ 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333061 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
looks like virtual dir to /CFIDE folder is not configured properly on the sub-domain: cfform.js and masks.js files return 404 not found (both in http://shard.adcalpos.net/cfide/scripts/ dir) Azadi On 22/04/2010 01:08, Mike Kear wrote: Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Here is the relevant code: ! First collect the data from the database --- cfquery name=qtestquery datasource=#application.dsn# select EmployeeID, GivenName, Surname, Bundyno from dbo.tblEmployee /cfquery ! Do a dump of the data to prove the query object exists and there are records to display cfdump var=#qtestquery# label=TestQuery !--- Open the CFFORM tag, using the ScriptSrc attribute, using an absolute path, not a relative one cfform name=Form1 action=submit.cfm scriptsrc=/cfide/scripts cfinput type=text name=Testfield value=#application.applicationname# label=Test of the cfforms validate=email message=Checking the validation/ cfgrid name=employee_grid query=qtestquery selectmode=single cfgridcolumn name=EmployeeID cfgridcolumn name=GivenName cfgridcolumn name=Surname /cfgrid br cfinput name=submitit type=Submit value=Submit /cfform If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 22, 2010 at 2:18 AM, Dave Watts dwa...@figleaf.com wrote: So here's my question: [A] do you think the cause of this problem is that the location of the CFGRID code is non-standard and therefore i need to use the scriptsrc= attibute of the CFFORM tag? Yes, I think that's the cause, although honestly I don't know whether changing SCRIPTSRC works with the Java grid. [B] If yes, where is it to be found? what am i looking for? /CFIDE/classes/* 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 ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333062 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Where do i find CFGRID Code?
If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. === Your sub domain doesn't have a mapping for the cfide folder. If you use Firebug or MS Fiddler you can easily see the 404s happening when the non-working example attempts to load the JavaScript files required for the grid to work. ~Brad ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
Mike, Make sure you have the virtual directory cfide setup on your sub domain website. That virtual directory needs to be pointing to your cfide directory of your server. I've ran into that as well but just not cfgrid. it was all cfide components. Thanks, Dan - Original Message - From: Mike Kear afpwebwo...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Wednesday, April 21, 2010 1:08 PM Subject: Re: Where do i find CFGRID Code? Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Here is the relevant code: ! First collect the data from the database --- cfquery name=qtestquery datasource=#application.dsn# select EmployeeID, GivenName, Surname, Bundyno from dbo.tblEmployee /cfquery ! Do a dump of the data to prove the query object exists and there are records to display cfdump var=#qtestquery# label=TestQuery !--- Open the CFFORM tag, using the ScriptSrc attribute, using an absolute path, not a relative one cfform name=Form1 action=submit.cfm scriptsrc=/cfide/scripts cfinput type=text name=Testfield value=#application.applicationname# label=Test of the cfforms validate=email message=Checking the validation/ cfgrid name=employee_grid query=qtestquery selectmode=single cfgridcolumn name=EmployeeID cfgridcolumn name=GivenName cfgridcolumn name=Surname /cfgrid br cfinput name=submitit type=Submit value=Submit /cfform If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 22, 2010 at 2:18 AM, Dave Watts dwa...@figleaf.com wrote: So here's my question: [A] do you think the cause of this problem is that the location of the CFGRID code is non-standard and therefore i need to use the scriptsrc= attibute of the CFFORM tag? Yes, I think that's the cause, although honestly I don't know whether changing SCRIPTSRC works with the Java grid. [B] If yes, where is it to be found? what am i looking for? /CFIDE/classes/* 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 ons ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333064 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
Thanks for you help, as always Dave. I am always in admiration of your patience and helpful attitude whenever anyone asks a question. I dont think we say thanks enough. So thanks! Anyway, the structure is referred to in the HELM control panel of this shared hosting as a subdomain. I dont much care what it is really - it acts like a subdomain whether it's called that or not, so that'll do me. Shard.adcalpoetc behaves as though it's a domain of its own - the root of that site is inside a folder at wwwroot/shard. I guess what i need to do, is create a folder called CFIDE in the subdomain shard and put a copy of the classes and the form ajax scripts etc. The HELM control panel doesn't have the functionality to create virtual directories, so to create those involves a support ticket. I'd rather not do that if i can help it - so if each site or sub-site or virtual host has its own copy of the CFGRID in a folder called /CFIDE/classes, that should work, I hope. There is no point in creating a mapping because unless I'm mistaken, CF Creates a mapping called CFIDE when it installs doesn't it? So that will already be there. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Apr 22, 2010 at 3:38 AM, Dave Watts dwa...@figleaf.com wrote: Can anyone tell me why this happens?? If i run a page in the root of a site, the CFGRID works. If i run the precise same file in the same relative location of a subdomain of that site, it doesnt. Can anyone see what i've got wrong here? Well, first, a bit of clarification. shard.adcalpos.net is not a subdomain. adcalpos.net is a domain, and shard is a hostname (A record) within that domain. If you go to the working link: http://adcalpos.net/trygrid.cfm you'll see it works, therefore the CFGRID applet has been installed ok, then if you go to the subdomain version of the exact same file at http://shard.adcalpos.net/trygrid.cfm you'll see now it cant find the CFGRID applet. Any one see what i need to change in the subdomains to make CFGRID work? Each virtual host you have on your web server needs to have a virtual directory pointing to /CFIDE. If you visit the two links, and view source, you'll see something like this: embed type=application/x-java-applet;version=1.3 pluginspage=http://java.sun.com/j2se/1.3/jre/index.html; code=coldfusion.applets.CFGridApplet.class archive=/CFIDE/classes/cfapplets.jar mayscript=true width=300 height=300 autowidth=false griddata=1%02Les%02Mustafa%02%013%02Troy%02Heron%02 griddescription=3%022%02300%02300%020%020%020%02%03%02%03%02%03%02%03%02%03%02S%020%02%03%02%03%02%03%02%03%02Y%02Y%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02%03%02N%02insert%02delete%02SortAsc%02SortDesc%01EmployeeID%02Y%02N%02Employeeid%01GivenName%02Y%02N%02Givenname%01Surname%02Y%02N%02Surname cf_form_name=Form1 cf_param_name=__CFGRID__Form1__employee_grid noembedb Browser must support Java to view ColdFusion Java Applets/b/noembed /embed Note the archive path. That has to be a valid URL. This is a valid URL: http://adcalpos.net/CFIDE/classes/ This is not (yet): http://shard.adcalpos.net/CFIDE/classes/ 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Where do i find CFGRID Code?
So thanks! You're welcome! I guess what i need to do, is create a folder called CFIDE in the subdomain shard and put a copy of the classes and the form ajax scripts etc. The HELM control panel doesn't have the functionality to create virtual directories, so to create those involves a support ticket. I'd rather not do that if i can help it - so if each site or sub-site or virtual host has its own copy of the CFGRID in a folder called /CFIDE/classes, that should work, I hope. Yes, that should work. I would prefer to create a virtual directory, though, because if you have multiple copies of CFIDE in various places, security patches that replace files in one will not replace the copied files in another. There is no point in creating a mapping because unless I'm mistaken, CF Creates a mapping called CFIDE when it installs doesn't it? So that will already be there. CF's mappings aren't the same as your web server's virtual directories. CF mappings only affect CF tags with a TEMPLATE attribute (CFINCLUDE, CFMODULE, etc). For paths to resolve from the browser, you need either a physical or virtual directory. So, yes, there's no point in creating a mapping, but not for the reason you think. 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 on ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333077 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm