CFGrid and CSS collisions.
Is there a way you can wrap a cfgrid or protect it from getting it's css overridden? I'm working on reskinning a legacy application and we're trying to minimize the impact of this new design that has essentially hosed everything. ~| 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:359926 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Submitting form with file and CFGRID - Exception in The submitted cfgrid form field is corrupt
I have a form with a file upload and a CFGRID. When submitted the following error occurs: Exception in The submitted cfgrid form field is corrupt This works with CF10 Update 13. When we upgraded to Update 14 this error started occurring. ~| 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:359507 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 5:06 PM, Andrew Scott wrote: > > It will be in the variables scope for the query, but as this is an issue > with the Ajax sending rather than receiving I doubt that is the issue. Thanks, Andrew - I confused var & variables. And none of that scoping of the return values made any difference. ~| 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:358978 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
It will be in the variables scope for the query, but as this is an issue with the Ajax sending rather than receiving I doubt that is the issue. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 7:02 AM, Stephen Hait wrote: > > On Tue, Jul 22, 2014 at 4:51 PM, Maureen wrote: > > > > > I didn't see scopes on the variables in your return statement. > > > > > > Not sure if that matters, but I would scope them just in case. > > > I'm not sure how to correctly scope pilots. It's the name of the query but > if it try query.pilots or var.pilots the grid doesn't receive any data. I > was able to change page and pagesize to arguments.page and > arguments.pagesize without causing any noticeable problems but also without > resolving the main issue. If you know how I should correctly scope the > query name, pilots, let me know and I can see if that makes any difference. > > Regards, > Stephen > > > ~| 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:358977 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:51 PM, Maureen wrote: > > I didn't see scopes on the variables in your return statement. > > > Not sure if that matters, but I would scope them just in case. I'm not sure how to correctly scope pilots. It's the name of the query but if it try query.pilots or var.pilots the grid doesn't receive any data. I was able to change page and pagesize to arguments.page and arguments.pagesize without causing any noticeable problems but also without resolving the main issue. If you know how I should correctly scope the query name, pilots, let me know and I can see if that makes any difference. Regards, Stephen ~| 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:358976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
Not sure what you're thinking their Maureen but what he has looks fine, he has nothing that needs var scoping in the function. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 6:51 AM, Maureen wrote: > > I didn't see scopes on the variables in your return statement. > > > Not sure if that matters, but I would scope them just in case. > > On Tue, Jul 22, 2014 at 4:47 PM, Stephen Hait > wrote: > > > > On Tue, Jul 22, 2014 at 4:40 PM, Maureen wrote: > > > >> > >> I know some things have changed with scope over the last few versions > >> but not sure what changed when. Local scope for functions was added at > >> some point. Make sure you are scoping all variables and declaring any > >> that need to be with var. > > > > > > Thanks, Maureen. I believe I am explicitly scoping all variables in this > > case. > > > > > > > > ~| 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:358975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
I didn't see scopes on the variables in your return statement. Not sure if that matters, but I would scope them just in case. On Tue, Jul 22, 2014 at 4:47 PM, Stephen Hait wrote: > > On Tue, Jul 22, 2014 at 4:40 PM, Maureen wrote: > >> >> I know some things have changed with scope over the last few versions >> but not sure what changed when. Local scope for functions was added at >> some point. Make sure you are scoping all variables and declaring any >> that need to be with var. > > > Thanks, Maureen. I believe I am explicitly scoping all variables in this > case. > > > ~| 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:358974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:40 PM, Maureen wrote: > > I know some things have changed with scope over the last few versions > but not sure what changed when. Local scope for functions was added at > some point. Make sure you are scoping all variables and declaring any > that need to be with var. Thanks, Maureen. I believe I am explicitly scoping all variables in this case. ~| 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:358973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
I know some things have changed with scope over the last few versions but not sure what changed when. Local scope for functions was added at some point. Make sure you are scoping all variables and declaring any that need to be with var. On Tue, Jul 22, 2014 at 2:53 PM, Stephen Hait wrote: > > Apparently something is different in CF11 when it comes to passing > additional arguments/parameters to a .CFC to serve as filters for the data > grid. Any idea what has changed since CF10 or how to deal with this? ~| 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:358972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 4:10 PM, Andrew Scott wrote: > > Stephen, > > Is this what you're experiencing? > > https://forums.adobe.com/thread/1490328 Andrew, I don't think this is the same problem but it might be related. I had not noticed any javascript errors. Just to test, removed 2 of the 3 arguments leaving just a single argument being passed to the .CFC and referenced there. I still did not see the argument getting passed and a dump of the arguments scope still showed [empty string] as the value of the single argument, even though I entered a value. Thanks, Stephen ~| 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:358971 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
Stephen, Is this what you're experiencing? https://forums.adobe.com/thread/1490328 Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 5:38 AM, Stephen Hait wrote: > > On Tue, Jul 22, 2014 at 3:04 PM, Andrew Scott > wrote: > > > > > You could check your Chrome developer tools, to then see what ColdFusion > > via its Ajax / JS stuff is actually sending across as parameters as well. > > This would help to see what is actually being passed. > > > Andrew, That's a good suggestion, too. With Chrome developer tools and > inspecting pilot_search.cfc, when using CF10, under Headers, Query String > Parameters, it reports argumentCollection which includes a list of all the > arguments and values passed from the CFGRID tag. When using CF11, under > Headers, Query String Parameters, there is no argumentCollection item > displayed. Instead, the four main built-in CFGRID arguments are each > displayed on separate lines along with their values - page, pagesize, > gridsortcolumn, gridsortdirection. > > I'm not sure what this means but it does seem to indicate that in CF11, the > 3 additional arguments are not making it to the .cfc to be used there using > the method that accomplishes this in CF10. > > If I can't get this sorted out soon, I may see if simply moving our app to > a CF10 instance would resolve this for now. I could then concentrate on a > longer term fix before CF10 is no longer supported. > > Thanks, > Stephen > > > ~| 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:358970 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 3:04 PM, Andrew Scott wrote: > > You could check your Chrome developer tools, to then see what ColdFusion > via its Ajax / JS stuff is actually sending across as parameters as well. > This would help to see what is actually being passed. Andrew, That's a good suggestion, too. With Chrome developer tools and inspecting pilot_search.cfc, when using CF10, under Headers, Query String Parameters, it reports argumentCollection which includes a list of all the arguments and values passed from the CFGRID tag. When using CF11, under Headers, Query String Parameters, there is no argumentCollection item displayed. Instead, the four main built-in CFGRID arguments are each displayed on separate lines along with their values - page, pagesize, gridsortcolumn, gridsortdirection. I'm not sure what this means but it does seem to indicate that in CF11, the 3 additional arguments are not making it to the .cfc to be used there using the method that accomplishes this in CF10. If I can't get this sorted out soon, I may see if simply moving our app to a CF10 instance would resolve this for now. I could then concentrate on a longer term fix before CF10 is no longer supported. Thanks, Stephen ~| 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:358969 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
You could check your Chrome developer tools, to then see what ColdFusion via its Ajax / JS stuff is actually sending across as parameters as well. This would help to see what is actually being passed. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 4:53 AM, Stephen Hait wrote: > > On Tue, Jul 22, 2014 at 2:01 PM, Maureen wrote: > > > > > On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait > > wrote: > > > Or does anyone have a suggestion of how to best debug this? I can't > seem > > to > > > figure out how to view the contents of the 3 arguments used in the > WHERE > > > clauses to see why they might be being ignored or why the result set is > > not > > > limited by the filters on CF11. > > > > > > I would dump the argument scope to see if the arguments are actually > > being set. You might also use a variable and build your query are a > > > Thanks, Maureen! You helped be figure out how to see what the values of the > arguments were. I dumped the arguments scope to a file and found that the > three arguments I am passing into the function for filters were showing as > [empty string] when using CF11 but were displaying as expected in CF10. > > Apparently something is different in CF11 when it comes to passing > additional arguments/parameters to a .CFC to serve as filters for the data > grid. Any idea what has changed since CF10 or how to deal with this? > > Thanks, > Stephen > > > ~| 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:358967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 2:01 PM, Maureen wrote: > > On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait > wrote: > > Or does anyone have a suggestion of how to best debug this? I can't seem > to > > figure out how to view the contents of the 3 arguments used in the WHERE > > clauses to see why they might be being ignored or why the result set is > not > > limited by the filters on CF11. > > I would dump the argument scope to see if the arguments are actually > being set. You might also use a variable and build your query are a Thanks, Maureen! You helped be figure out how to see what the values of the arguments were. I dumped the arguments scope to a file and found that the three arguments I am passing into the function for filters were showing as [empty string] when using CF11 but were displaying as expected in CF10. Apparently something is different in CF11 when it comes to passing additional arguments/parameters to a .CFC to serve as filters for the data grid. Any idea what has changed since CF10 or how to deal with this? Thanks, Stephen ~| 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:358966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait wrote: > Does anyone know why the WHERE clauses in the query appear to be ignored > when running the app with CF11 but work correctly with CF10? > > Or does anyone have a suggestion of how to best debug this? I can't seem to > figure out how to view the contents of the 3 arguments used in the WHERE > clauses to see why they might be being ignored or why the result set is not > limited by the filters on CF11. > > Any insight or suggestions appreciated. I would dump the argument scope to see if the arguments are actually being set. You might also use a variable and build your query are a text string, then dump that string to see what it contains. ~| 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:358965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 1:38 PM, John M Bliss wrote: > > Here's the "official" replacement for cfgrid. Double-quotes because > there're many way to replace cfgrid...this is just one suggestion. > > > https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md Thanks, John. That looks like an interesting approach. I will definitely check into that if I can't get this issue resolved fairly quickly. Regards, Stephen ~| 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:358964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott wrote: > > where 0 = 0 looks like its obsolete in that query, in other words it > shouldn't be needed if you have no if statements there. As you said it > works on ColdFusion 10, what would happen if you removed the 0 = 0 or > replaced it with 1 = 1? > There were originally "if" statements checking each filter value for existence before adding to the WHERE clause which explains why the 0 = 0 was there. I tried removing the 0 = 0 as well as replacing it with 1 = 1 and the behaviour remained the same. > When you say is ignored, are you saying records are returning or no records > are being returned? You also don't indicate whether you have an error, so > we can assume that what is calling this is working to some degree with > records in the grid? > When I say is ignored, I mean that if a value is entered in one or more of the filter fields, the result set is the same as if there were no WHERE clause at all. There is no error that I'm seeing. So yes, records are successfully populating the grid, there's just no longer an ability to limit the number of rows returned based on the filter criteria. > > Also there is a huge push to remove any UI tags from Application code, it > might pay to think about moving away from the likes of the current CF UI > stuff. I can understand this but I'm primarily interested at the moment with getting the previously working functionality back before I start looking at implementing a replacement. Thanks for your suggestions. ~| 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:358963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
Here's the "official" replacement for cfgrid. Double-quotes because there're many way to replace cfgrid...this is just one suggestion. https://github.com/cfjedimaster/ColdFusion-UI-the-Right-Way/blob/master/chapters/cfgrid/index.md On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott wrote: > > where 0 = 0 looks like its obsolete in that query, in other words it > shouldn't be needed if you have no if statements there. As you said it > works on ColdFusion 10, what would happen if you removed the 0 = 0 or > replaced it with 1 = 1? > > Other than that I really can't see any other issue with it. > > When you say is ignored, are you saying records are returning or no records > are being returned? You also don't indicate whether you have an error, so > we can assume that what is calling this is working to some degree with > records in the grid? > > Also there is a huge push to remove any UI tags from Application code, it > might pay to think about moving away from the likes of the current CF UI > stuff. > > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411 > > > > On Wed, Jul 23, 2014 at 3:08 AM, Stephen Hait > wrote: > > > > > We have a CF app that uses a CF_GRID with some filters to allow limiting > > the data retrieved. After moving the app from a host running CF10 to > > another host running CF11, the filters stopped working even though the > > other grid functions did not - grid still display data correctly and > > clicking column headers correctly sorts the grid. > > > > This is the contents of the cfgrid tag: > > > > > format="html" > > name="pilotGrid" > > pagesize="10" > > autowidth="yes" > > selectmode="row" > > appendKey="yes" > > href="index.cfm?fuseaction=dsp_adm-pilot-detail" > > hrefKey="userid" > > > > > > bind="cfc:pilot_search.getPilots({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, > > '#attributes.pil_email#', '#attributes.pil_lname#', > > '#attributes.pil_n_number#')"> > > > > The bind parameter specifies a function, getPilots, in pilot_search.cfc. > It > > passes 3 attributes/parameters to the function which are the contents of > > the 3 text filters - pil_email, pil_lname, pil_n_number. The function > > contains a query to retrieve the requested data including WHERE clauses > > based on the filter text entered. > > > > This is the content of the function and query contained in > > pilot_search.cfc: > > > > > > > > > > > > > > > > > > /> > > > > > > > > > > > > > > select userid, pil_n_number, pil_email, pil_lname, pil_fname, > > pil_password, last_login > > from pilots > > where 0=0 > > and pil_email like > value="%#arguments.pil_email#%"> > > and pil_lname like > value="%#arguments.pil_lname#%"> > > and pil_n_number like > value="%#arguments.pil_n_number#%"> > > > > order by #arguments.gridsortcolumn# #arguments.gridsortdirection# > > > > > > > > > > > > Does anyone know why the WHERE clauses in the query appear to be ignored > > when running the app with CF11 but work correctly with CF10? > > > > Or does anyone have a suggestion of how to best debug this? I can't seem > to > > figure out how to view the contents of the 3 arguments used in the WHERE > > clauses to see why they might be being ignored or why the result set is > not > > limited by the filters on CF11. > > > > Any insight or suggestions appreciated. > > > > Regards, > > Stephen > > > > > > > > ~| 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:358962 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid filter stops working after move from CF10 to CF11
where 0 = 0 looks like its obsolete in that query, in other words it shouldn't be needed if you have no if statements there. As you said it works on ColdFusion 10, what would happen if you removed the 0 = 0 or replaced it with 1 = 1? Other than that I really can't see any other issue with it. When you say is ignored, are you saying records are returning or no records are being returned? You also don't indicate whether you have an error, so we can assume that what is calling this is working to some degree with records in the grid? Also there is a huge push to remove any UI tags from Application code, it might pay to think about moving away from the likes of the current CF UI stuff. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jul 23, 2014 at 3:08 AM, Stephen Hait wrote: > > We have a CF app that uses a CF_GRID with some filters to allow limiting > the data retrieved. After moving the app from a host running CF10 to > another host running CF11, the filters stopped working even though the > other grid functions did not - grid still display data correctly and > clicking column headers correctly sorts the grid. > > This is the contents of the cfgrid tag: > > format="html" > name="pilotGrid" > pagesize="10" > autowidth="yes" > selectmode="row" > appendKey="yes" > href="index.cfm?fuseaction=dsp_adm-pilot-detail" > hrefKey="userid" > > > bind="cfc:pilot_search.getPilots({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection}, > '#attributes.pil_email#', '#attributes.pil_lname#', > '#attributes.pil_n_number#')"> > > The bind parameter specifies a function, getPilots, in pilot_search.cfc. It > passes 3 attributes/parameters to the function which are the contents of > the 3 text filters - pil_email, pil_lname, pil_n_number. The function > contains a query to retrieve the requested data including WHERE clauses > based on the filter text entered. > > This is the content of the function and query contained in > pilot_search.cfc: > > > > > > > > > > > > > > > > select userid, pil_n_number, pil_email, pil_lname, pil_fname, > pil_password, last_login > from pilots > where 0=0 > and pil_email like value="%#arguments.pil_email#%"> > and pil_lname like value="%#arguments.pil_lname#%"> > and pil_n_number like value="%#arguments.pil_n_number#%"> > > order by #arguments.gridsortcolumn# #arguments.gridsortdirection# > > > > > > Does anyone know why the WHERE clauses in the query appear to be ignored > when running the app with CF11 but work correctly with CF10? > > Or does anyone have a suggestion of how to best debug this? I can't seem to > figure out how to view the contents of the 3 arguments used in the WHERE > clauses to see why they might be being ignored or why the result set is not > limited by the filters on CF11. > > Any insight or suggestions appreciated. > > Regards, > Stephen > > > ~| 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:358961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGrid filter stops working after move from CF10 to CF11
We have a CF app that uses a CF_GRID with some filters to allow limiting the data retrieved. After moving the app from a host running CF10 to another host running CF11, the filters stopped working even though the other grid functions did not - grid still display data correctly and clicking column headers correctly sorts the grid. This is the contents of the cfgrid tag: The bind parameter specifies a function, getPilots, in pilot_search.cfc. It passes 3 attributes/parameters to the function which are the contents of the 3 text filters - pil_email, pil_lname, pil_n_number. The function contains a query to retrieve the requested data including WHERE clauses based on the filter text entered. This is the content of the function and query contained in pilot_search.cfc: select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like and pil_lname like and pil_n_number like order by #arguments.gridsortcolumn# #arguments.gridsortdirection# Does anyone know why the WHERE clauses in the query appear to be ignored when running the app with CF11 but work correctly with CF10? Or does anyone have a suggestion of how to best debug this? I can't seem to figure out how to view the contents of the 3 arguments used in the WHERE clauses to see why they might be being ignored or why the result set is not limited by the filters on CF11. Any insight or suggestions appreciated. Regards, Stephen ~| 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:358960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
form design issues; cfinput autosuggest vs cfgrid
(sorry in advance is this is a double post) I've got a form layout with a header on top that includes a cfinput using autosuggest, then below that a cflayout type="tab". The drop down produced by the autosuggest normally appears fine unless the cflayoutarea contains a cfgrid. In that case, the drop down seems to appear "behind" the cfgrid instead of in front of it (which makes it a bit hard to select an item!). Any thoughts on getting the autosuggest list to always appear "in front" of the cfgrid? Sample code: *Note: Replace the cfgrid with something else like simply HTML and the autosuggest list appears over the cflayoutarea. With the cfgrid in place, the autosuggest list appears truncated or "behind" the cfgrid. TIA! ~| 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:357693 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfform layout issues. cfinput autosuggest vs cfgrid
I've got a form layout with a header on top that includes a cfinput using autosuggest, then below that a cflayout type="tab". The drop down produced by the autosuggest normally appears fine unless the cflayoutarea contains a cfgrid. In that case, the drop down seems to appear "behind" the cfgrid instead of in front of it (which makes it a bit hard to select an item!). Any thoughts on getting the autosuggest list to always appear "in front" of the cfgrid? Sample code: *Note: Replace the cfgrid with something else like simply HTML and the autosuggest list appears over the cflayoutarea. With the cfgrid in place, the autosuggest list appears truncated or "behind" the cfgrid. TIA! ~| 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:357692 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Rendering on CFGRID
If you had this if(data == 'false') then this is comparing the data to a string of false, if you want to check for a true or false then you need to remove the single quotes so that it is. if(data == false) Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jan 15, 2014 at 5:55 PM, Anthony Doherty wrote: > > Hi Andrew > Thanks for getting back to me. > > I found the problem. The if statement did not like the word 'false' so I > changed it to a number 1 and it worked. > > I believe it has something to do with the SQL db but because I inherited > the db there was not much I can change > > Thanks for getting back to me > > Anthony > > Sent from my iPhone > > > On 14 Jan 2014, at 22:44, Andrew Scott wrote: > > > > > > Anthony, > > > > Have you thought about a few debugging options here? First you could do > > > > console.log(data) and see what is contained in the data, the other option > > is to use the debugging tools in the browser to line debug and see what > is > > happening. > > > > Regards, > > Andrew Scott > > WebSite: http://www.andyscott.id.au/ > > Google+: http://plus.google.com/113032480415921517411 > > > > > > > > On Wed, Jan 15, 2014 at 9:35 AM, Anthony Doherty >wrote: > > > >> > >> Hi Guys, > >> I have this custom rendering applied from this site > >> > >> > http://alagad.com/2010/03/31/ask-an-alagadian-how-can-i-style-a-cell-in-lt-cfgrid-gt-based-on-the-data-it-contains/ > >> > >> But its only rendering everything in the first style - it wont change > the > >> style based on the IF statement. > >> Below is my code: > >> > >>formatStatus = function(data,cell,record,row,col,store) { > >>if (data == 'false') > >> { > >> cell.css = 'status1'; > >> } > >>else > >> { > >> cell.css = 'status2'; > >> } > >>return data > >> > >>} > >>formatCells = function() { > >>theGrid = ColdFusion.Grid.getGridObject('grid1'); > >>cm = theGrid.getColumnModel(); > >>cm.setRenderer(9,formatStatus); > >>} > >> > >> > >>.status1{border:0px solid #000; background-color:#66FF66; } > >>.status2{border:0px solid #000; background-color:#00; } > >> > >> > >> So you can see i have 2 styles - my problem is everything is getting > >> rendered in status1 no matter if i change the IF statement. > >> Its as if there is a problem with the If statment. > >> > >> If someone could help as i have to do a presentation on this tomorrow > and > >> i have only realised during a practice run of the demo! > >> > >> Thanks > > > > > > ~| 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:357427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Rendering on CFGRID
Hi Andrew Thanks for getting back to me. I found the problem. The if statement did not like the word 'false' so I changed it to a number 1 and it worked. I believe it has something to do with the SQL db but because I inherited the db there was not much I can change Thanks for getting back to me Anthony Sent from my iPhone > On 14 Jan 2014, at 22:44, Andrew Scott wrote: > > > Anthony, > > Have you thought about a few debugging options here? First you could do > > console.log(data) and see what is contained in the data, the other option > is to use the debugging tools in the browser to line debug and see what is > happening. > > Regards, > Andrew Scott > WebSite: http://www.andyscott.id.au/ > Google+: http://plus.google.com/113032480415921517411 > > > > On Wed, Jan 15, 2014 at 9:35 AM, Anthony Doherty wrote: > >> >> Hi Guys, >> I have this custom rendering applied from this site >> >> http://alagad.com/2010/03/31/ask-an-alagadian-how-can-i-style-a-cell-in-lt-cfgrid-gt-based-on-the-data-it-contains/ >> >> But its only rendering everything in the first style - it wont change the >> style based on the IF statement. >> Below is my code: >> >>formatStatus = function(data,cell,record,row,col,store) { >>if (data == 'false') >> { >> cell.css = 'status1'; >> } >>else >> { >> cell.css = 'status2'; >> } >>return data >> >>} >>formatCells = function() { >>theGrid = ColdFusion.Grid.getGridObject('grid1'); >>cm = theGrid.getColumnModel(); >>cm.setRenderer(9,formatStatus); >>} >> >> >>.status1{border:0px solid #000; background-color:#66FF66; } >>.status2{border:0px solid #000; background-color:#00; } >> >> >> So you can see i have 2 styles - my problem is everything is getting >> rendered in status1 no matter if i change the IF statement. >> Its as if there is a problem with the If statment. >> >> If someone could help as i have to do a presentation on this tomorrow and >> i have only realised during a practice run of the demo! >> >> Thanks > > ~| 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:357426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom Rendering on CFGRID
Anthony, Have you thought about a few debugging options here? First you could do console.log(data) and see what is contained in the data, the other option is to use the debugging tools in the browser to line debug and see what is happening. Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Jan 15, 2014 at 9:35 AM, Anthony Doherty wrote: > > Hi Guys, > I have this custom rendering applied from this site > > http://alagad.com/2010/03/31/ask-an-alagadian-how-can-i-style-a-cell-in-lt-cfgrid-gt-based-on-the-data-it-contains/ > > But its only rendering everything in the first style - it wont change the > style based on the IF statement. > Below is my code: > > formatStatus = function(data,cell,record,row,col,store) { > if (data == 'false') > { > cell.css = 'status1'; > } > else > { > cell.css = 'status2'; > } > return data > > } > formatCells = function() { > theGrid = ColdFusion.Grid.getGridObject('grid1'); > cm = theGrid.getColumnModel(); > cm.setRenderer(9,formatStatus); > } > > > .status1{border:0px solid #000; background-color:#66FF66; } > .status2{border:0px solid #000; background-color:#00; } > > > So you can see i have 2 styles - my problem is everything is getting > rendered in status1 no matter if i change the IF statement. > Its as if there is a problem with the If statment. > > If someone could help as i have to do a presentation on this tomorrow and > i have only realised during a practice run of the demo! > > Thanks > > ~| 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:357423 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Custom Rendering on CFGRID
Hi Guys, I have this custom rendering applied from this site http://alagad.com/2010/03/31/ask-an-alagadian-how-can-i-style-a-cell-in-lt-cfgrid-gt-based-on-the-data-it-contains/ But its only rendering everything in the first style - it wont change the style based on the IF statement. Below is my code: formatStatus = function(data,cell,record,row,col,store) { if (data == 'false') { cell.css = 'status1'; } else { cell.css = 'status2'; } return data } formatCells = function() { theGrid = ColdFusion.Grid.getGridObject('grid1'); cm = theGrid.getColumnModel(); cm.setRenderer(9,formatStatus); } .status1{border:0px solid #000; background-color:#66FF66; } .status2{border:0px solid #000; background-color:#00; } So you can see i have 2 styles - my problem is everything is getting rendered in status1 no matter if i change the IF statement. Its as if there is a problem with the If statment. If someone could help as i have to do a presentation on this tomorrow and i have only realised during a practice run of the demo! Thanks ~| 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:357422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: EXT :CFGrid
So it turns out that it was my fault not the hotfix, I somehow lost the mapping to the CFIDE for this IP addrees in IIS. All is now well with the world. -Original Message- From: Huff, Jerome P (IS) [mailto:jerome.h...@ngc.com] Sent: Friday, May 17, 2013 11:26 AM To: cf-talk Subject: EXT :CFGrid Since applying the latest hotfix, cfgrid applets no longer appear on my web pages, on the production server. If I view source, the call to /CFIDE/scripts/ajax is there, but no applet appears. Anyone have any idea how to correct this? Thanks, Jerome Huff ~| 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:355761 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGrid
the links being there doesn't say much. click the links in the source and make sure they actually work and the files can be loaded. On Fri, May 17, 2013 at 4:26 PM, Huff, Jerome P (IS) wrote: > > Since applying the latest hotfix, cfgrid applets no longer appear on my > web pages, on the production server. If I view source, the call to > /CFIDE/scripts/ajax is there, but no applet appears. Anyone have any idea > how to correct this? > > Thanks, > > Jerome Huff > > > > ~| 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:355756 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGrid
Since applying the latest hotfix, cfgrid applets no longer appear on my web pages, on the production server. If I view source, the call to /CFIDE/scripts/ajax is there, but no applet appears. Anyone have any idea how to correct this? Thanks, Jerome Huff ~| 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:355753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid autosuggest problem
My client's application has a Coldfusion HTML form that contains a Coldfusion HTML grid which binds to a cfc to retrieve and update the grid's data. My client would like one of the grids columns to have an autosuggest feature like the other input fields on the page has. (he wants to be able to start typing and see a list of things that he's typed in there before) I've found some scripts that will apply the autosuggest feature to an input field (which doesn't seem necessary since it's built into the browser anyway) but I can't get it to work from within the grid. (I tried to simply change the path and field name of the input to the path and column name of the grid, but that didn't work) I also saw an article that said you can set a grid column's control type to type="combobox", but when I try that, it throws up an error stating that "Bind expressions cannot be empty". (perhaps because it doesn't know where to get the data to populate the drop-down list from) My client is very adamant about having this feature, so I can't just tell him that it isn't possible. (he doesn't believe in "it can't be done") Here is the code for the grid and the cfc that it's bound to, I really hope someone can help me with this. Grid code: cfc code (editGrid.cfc): SELECT * FROM tblProjectDetails WHERE ProjectID=#session.pid# ORDER BY #ARGUMENTS.gridsortcolumn# #ARGUMENTS.gridsortdir# INSERT INTO tblProjectDetails (ProjectID, Quantity, TaskName, UnitPrice, ExtendedPrice) VALUES (#session.pid#, #arguments.gridrow.Quantity#, '#arguments.gridrow.TaskName#', #arguments.gridrow.UnitPrice#, #arguments.gridrow.Quantity#*#arguments.gridrow.UnitPrice#) UPDATE tblProjectDetails SET #colname#="#value#" WHERE DetailID= DELETE FROM tblProjectDetails WHERE DetailID= SELECT * FROM vTempDetails WHERE ProjectID=#session.pid# UPDATE tblProjectDetails SET ExtendedPrice=#qGetExtendedPrice.Quantity#*#qGetExtendedPrice.UnitPrice# WHERE DetailID=#qGetExtendedPrice.DetailID# SELECT SUM(ExtendedPrice) AS Subtotal FROM vTempDetails WHERE ProjectID=#session.pid# UPDATE tblProjectDetails SET Taxable=#Taxable# SELECT SUM(ExtendedPrice) AS Taxable FROM vTempDetails WHERE ProjectID=#session.pid# SELECT SUM(ExtendedPrice) AS Total FROM vTempDetails WHERE ProjectID=#session.pid# ~| 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:351818 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 cfgrid refresh problem
Actually, the save and refresh buttons are a part of the html cfgrid, I didn't create them and you're correct that I'm using CF9. >The CFGrid is based on the ExtJS 3.1 (from memory, not sure if it was >upgraded past that point), on ColdFusion 9. So unless stated otherwise I am >going to assume ColdFusion 9. I've added the cfajaxproxy cfc script at the top >of the page, but I've never used it before, so I'm not sure I'm using it >right. I was under the impression that it created a direct link to the cfc so >that any changes would automatically refresh the bound fields. My cfajaxproxy >script is: and it's loaded just before the tag for the page. I tried using Coldfusion.Grid.refresh in a
Re: ColdFusion 9 cfgrid refresh problem
My Ext JS 3 is a little rusty, but I went and hit a copy of the docs I have on my CFQueryReader site (http://cfqueryreader.cutterscrossing.com/js/ext-3/docs/). I don't know about this 'refresh' method (maybe that's a custom CF thing), but you should get a reference to the grid's data store: var store = Coldfusion.Grid.getStore(); Then reload the store: store.reload(); That should update your grid with a fresh data call to the server. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 6/26/2012 3:00 AM, Ray Meade wrote: > I've been trying to solve this problem for over a week now to no avail and > it's driving me crazy. Basically, I have an html form with an html cfgrid > > containing the columns Quantity, TaskName, UnitPrice and ExtendedPrice. I > managed to bind the grid to a cfc function that populates it from the > database and > > I've created an onChange event that updates the database when changes are > made. I also have a cfinput (not part of the grid, but on the same form) that > is > > bound to another function that totals the "ExtendedPrice" column to display > the subtotal. My problem is that neither the grid or the subtotal field are > > refreshing automatically. My client doesn't mind having to click the "Save" > button and then the "Refresh" button on the grid to get it to refresh > (although, > > I'd like to be able to have it refresh automatically), but the only way to > get the subtotal field to refresh is by manually refreshing the page (by > hitting > > the F5 key). I tried adding ";Coldfusion.Grid.refresh(grdProjectDetails, > false)" to the end of the onChange event (I thought it was possible to use > more than > > one trigger on the onChange event by separating them with the semicolon) but > when I do that, it throws the error "Bind expressions cannot be empty". I even > > rtried adding it as a script to the function thaat does the updates, but it > has no effect there. Here is my code, I really hope someone can help me with > > this. > > > addproject.cfm > > >SELECT username, roles, first_name, last_name >FROM tblUsers >WHERE Username='#GetAuthUser()#' > > ListFind("Accounting,Administrator,Executive,User",qUser.Roles) EQ 0> > > > > > URLEncodedFormat(MM_referer)> > > > >SELECT * >FROM tblCompanyInfo > > > > > SELECT * > FROM vClients > WHERE ClientID= > > > > > > SELECT * > FROM vClientVehicles > WHERE VehicleID= cfsqltype="cf_sql_integer"> > > > > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > http://www.w3.org/1999/xhtml";> > > > > > $(document).ready(function() { > $('.jtextfill').textfill({ maxFontPixels: 48 }); > > $('#dyntext').keyup(function() { > $('.dyntextval').html(this.value); > $('.jtextfill').textfill({ maxFontPixels: 48 }); > }); > }); > > > > #qCompanyInfo.CompanyName# Database > > > > <!-- > .style4 { > font-family: "Monotype Corsiva", cursive; > font-size: 38px; > text-align: right; > color: #00F; > font-weight: bold; > } > .style14 { > text-align:center; > height:50px; > font-family: "English111 Vivace BT"; > font-size: 60px; > font-weight:bold; > color:#000; > } > #dyntext { > width: 100; > } > .monkeythink { > width:100%; > position:relative; > } > .jtextfill > { > position:relative; > width:100%; > height:inherit; > } > .style21 { > font-family: "English111 Vivace BT"; > font-size: 51px; > text-align: right; > color: #00F; > font-weight: bold; > } > .style22 { > font-size: 22px; > font-family: "Monotype Corsiva", cursive; > height: 25px; > } > .style1 { > font-family: "Monotype Corsiva", cursive; > font-weight: bold; >
Re: ColdFusion 9 cfgrid refresh problem
The CFGrid is based on the ExtJS 3.1 (from memory, not sure if it was upgraded past that point), on ColdFusion 9. So unless stated otherwise I am going to assume ColdFusion 9. There is a way where you can intercept, or take control of the save or hook into a listener in to do further things, one of which would be to refresh the grid. So a couple of questions for you, is the save your button as I am sure this is not part of the CFgrid normally, if that is the case then what you can do is fire a JS to save the data via ajax, and return whether it is successful or not, if it is not successful then I would let the user know that an error occurred saving the information. Otherwise you can use the ColdFusion JS to get a handle on the grid by its name, and use the .refresh() or .reload() to reload the grid. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Tue, Jun 26, 2012 at 5:00 PM, Ray Meade wrote: > > I've been trying to solve this problem for over a week now to no avail and > it's driving me crazy. Basically, I have an html form with an html cfgrid > > containing the columns Quantity, TaskName, UnitPrice and ExtendedPrice. I > managed to bind the grid to a cfc function that populates it from the > database and > > I've created an onChange event that updates the database when changes are > made. I also have a cfinput (not part of the grid, but on the same form) > that is > > bound to another function that totals the "ExtendedPrice" column to > display the subtotal. My problem is that neither the grid or the subtotal > field are > > refreshing automatically. My client doesn't mind having to click the > "Save" button and then the "Refresh" button on the grid to get it to > refresh (although, > > I'd like to be able to have it refresh automatically), but the only way to > get the subtotal field to refresh is by manually refreshing the page (by > hitting > > the F5 key). I tried adding ";Coldfusion.Grid.refresh(grdProjectDetails, > false)" to the end of the onChange event (I thought it was possible to use > more than > > one trigger on the onChange event by separating them with the semicolon) > but when I do that, it throws the error "Bind expressions cannot be empty". > I even > > rtried adding it as a script to the function thaat does the updates, but > it has no effect there. Here is my code, I really hope someone can help me > with > > this. > > > addproject.cfm > > > SELECT username, roles, first_name, last_name > FROM tblUsers > WHERE Username='#GetAuthUser()#' > > ListFind("Accounting,Administrator,Executive,User",qUser.Roles) EQ 0> > > > > > URLEncodedFormat(MM_referer)> > > > > SELECT * > FROM tblCompanyInfo > > > > >SELECT * >FROM vClients >WHERE ClientID= cfsqltype="cf_sql_varchar"> > > > > > >SELECT * >FROM vClientVehicles >WHERE VehicleID= cfsqltype="cf_sql_integer"> > > > > > http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > http://www.w3.org/1999/xhtml";> > > > > >$(document).ready(function() { >$('.jtextfill').textfill({ maxFontPixels: 48 }); > >$('#dyntext').keyup(function() { >$('.dyntextval').html(this.value); >$('.jtextfill').textfill({ maxFontPixels: 48 }); >}); >}); > > > > #qCompanyInfo.CompanyName# Database > > > > <!-- > .style4 { >font-family: "Monotype Corsiva", cursive; >font-size: 38px; >text-align: right; >color: #00F; >font-weight: bold; > } > .style14 { >text-align:center; >height:50px; >font-family: "English111 Vivace BT"; >font-size: 60px; >font-weight:bold; >color:#000; > } > #dyntext { >width: 100; > } > .monkeythink { >width:100%; >position:relative; > } > .jtextfill > { >position:relative; >width:100%; >height:inherit; > } > .style21 { >font-family: "English111 Vivace BT"; >font-size: 51px; >text-align: right; >color: #00F; >font-weight: bold; > } > .style22 { >font-size: 22px; >font-family: "Monotype Corsiva", cursive; >height: 25px; > } > .style1 { >font
ColdFusion 9 cfgrid refresh problem
I've been trying to solve this problem for over a week now to no avail and it's driving me crazy. Basically, I have an html form with an html cfgrid containing the columns Quantity, TaskName, UnitPrice and ExtendedPrice. I managed to bind the grid to a cfc function that populates it from the database and I've created an onChange event that updates the database when changes are made. I also have a cfinput (not part of the grid, but on the same form) that is bound to another function that totals the "ExtendedPrice" column to display the subtotal. My problem is that neither the grid or the subtotal field are refreshing automatically. My client doesn't mind having to click the "Save" button and then the "Refresh" button on the grid to get it to refresh (although, I'd like to be able to have it refresh automatically), but the only way to get the subtotal field to refresh is by manually refreshing the page (by hitting the F5 key). I tried adding ";Coldfusion.Grid.refresh(grdProjectDetails, false)" to the end of the onChange event (I thought it was possible to use more than one trigger on the onChange event by separating them with the semicolon) but when I do that, it throws the error "Bind expressions cannot be empty". I even rtried adding it as a script to the function thaat does the updates, but it has no effect there. Here is my code, I really hope someone can help me with this. addproject.cfm SELECT username, roles, first_name, last_name FROM tblUsers WHERE Username='#GetAuthUser()#' SELECT * FROM tblCompanyInfo SELECT * FROM vClients WHERE ClientID= SELECT * FROM vClientVehicles WHERE VehicleID= http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> $(document).ready(function() { $('.jtextfill').textfill({ maxFontPixels: 48 }); $('#dyntext').keyup(function() { $('.dyntextval').html(this.value); $('.jtextfill').textfill({ maxFontPixels: 48 }); }); }); #qCompanyInfo.CompanyName# Database <!-- .style4 { font-family: "Monotype Corsiva", cursive; font-size: 38px; text-align: right; color: #00F; font-weight: bold; } .style14 { text-align:center; height:50px; font-family: "English111 Vivace BT"; font-size: 60px; font-weight:bold; color:#000; } #dyntext { width: 100; } .monkeythink { width:100%; position:relative; } .jtextfill { position:relative; width:100%; height:inherit; } .style21 { font-family: "English111 Vivace BT"; font-size: 51px; text-align: right; color: #00F; font-weight: bold; } .style22 { font-size: 22px; font-family: "Monotype Corsiva", cursive; height: 25px; } .style1 { font-family: "Monotype Corsiva", cursive; font-weight: bold; } .style2 { font-family: "Monotype Corsiva", cursive; font-size: 30px; font-weight: bold; color: #F00; } .style3 { font-size: large; font-family: "Monotype Corsiva", cursive; } .style23 { font-size: medium; font-family: "Monotype Corsiva", cursive; } .style24 { font-family: "Arial, Helvetica, sans-serif"; } .style25 { font-size: 20px; font-family: "Monotype Corsiva", cursive; } .style27 { font-size: 22px; font-family: "Monotype Corsiva", cursive; height: 25px; width:100%; } .style5 { font-size: 8px; color:#000; font:Arial; font-family: "Arial, Helvetica, sans-serif"; } .style8 { font-size: 14px; } .style11 { font-size: 16px; font-weight: bold; color:#00F; } .style9 { font-family: "Arial, Helvetica, sans-serif"; color: #000; font-size: 14px; } .style10 { color: #FFF; font-weight: bold; } .style12 { font-family: "Monotype Corsiva"; font-size: 26px; color:#000; } .style15 { font-family: "Monotype Corsiva"; font-size: 24px; color: #00F; font-weight: bold; } .style16 { font-family: "Monotype Corsiva", cursive; font-size: 20px; font-weight: bold; color: #F00; } .style17 { font-size: 28px; font-family: "Monotype Corsiva", cursive; font-weight:bold; color:#00F; } .style18 { font-size: 28px; font-fam
CF9 cfgrid get value from added textbox
What I am trying to do is get the value of a textbox that I have added to my grid via button click. Here is the code that I have used so far: This is where I add the button and textbox. [code] ",currentrow)> ", currentrow)> [/code] Here is the javascript for the button click. ( I know I have to functions that are doing the same thing, it is two buttons I was just testing to make sure they were giving me the information I wanted.) [code] myproxy = new myproxy(); myproxy.setCallbackHandler(handleResult); function testit(){ var itemID = ColdFusion.getElementValue('items', 'iResults', 'ItemId'); var qty = ColdFusion.getElementValue('items', 'iResults', 'qty2').value; myproxy.getData(itemID, qty); } function testit2(){ var itemID = ColdFusion.getElementValue('items', 'iResults', 'ItemId'); var qty = ColdFusion.getElementValue('items', 'iResults', 'qty2').value; myproxy.getData(itemID, qty) } function handleResult(r){ alert("Result: "+r); } [/code] Here is the code for the grid. [code] Search: My Guide [/code] So far all I have been able to get when I try to reference that column is the actual code that is used to create the textbox. ~| 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:351351 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid
New to using cfgrid and have a question or two. I'm using a cfselect input with a query. It's possible that two or more items that are displayed will be very similar so I'll have the cfgrid in a hidden div that the user can pop open and do a lookup there where more information is displayed about each entry. For updates or inserts I plan on using a submit button that triggers a ColdFusion.Ajax.submitForm call (I don't want to process the entire form at this point). I think I have the javascript/jquery to append to my select box if an insert is made. Any suggestions on how to allow users to make their selection (without an update or insert) from the cfgrid => Ajax => callback routine where it can then be handled? ~| 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:350082 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Binding cfselect to cfgrid
Having a hard time finding any resources on how to bind a cfselect to cfgrid. I can bind a cfinput to a cfgrid easily. For example: But when it comes to cfselect, I can't figure out how to do the same thing. Any help would be appreciated. Thanks in advanced! ~| 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:347652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: implementing CFGRID filter on CF9, blog examples fail
> Oh drat, I got so caught up in typing up my reply that I forgot to > thank you for taking the time to offer a suggestion. I really did > mean to write that first. > > -Patti N/P. it was only a small suggestion. ~| 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:347031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: implementing CFGRID filter on CF9, blog examples fail
Oh drat, I got so caught up in typing up my reply that I forgot to thank you for taking the time to offer a suggestion. I really did mean to write that first. -Patti ~| 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:347014 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: implementing CFGRID filter on CF9, blog examples fail
Yes, Yes, No. My research tells me that the examples I found that were written for cf8 just won't work because of the major differences between its version of EXTjs and cf9+. I suspect taht the example I found for cf9 won't work because of the minor difference between cf9.0 and 9.01. AT the very least, using the header toolbar is hosed for 9.0 and i don't have the time to dig into how to manipulate EXTjs directly. I did find that one thing I was doing wrong was populating my CFGRID with a CFQUERY. In order to get the bottom toolbar and paging to work, I needed to get rid of the query and do a bind to a CFC method. My final fix, to get my top toolbar approximation with a filter was to just hand code a HTML drop box as part of the CFFORM and bind it too: // for the cfgrid args = structNew(); args.bind = "cfc:ebusiness.getFundingTransactions({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},{filter})"; args.onchange = "cfc:ebusiness.psbFunding.edit({cfgridaction},{cfgridrow},{cfgridchanged})"; then var gridRender = function() { grid = ColdFusion.Grid.getGridObject('eBusinessGrid'); var bbar = Ext.DomHelper.overwrite(grid.bbar,{tag:'div',id:Ext.id()},true); gbbar = new Ext.PagingToolbar({ renderTo:bbar, store: grid.store, pageSize: 50, displayInfo: true, displayMsg: '<b>Showing {0} - {1} out of {2}</b>', emptyMsg: "<b>No Records</b>" }); }; then ... stuff... ... ... > Off the top of my head, do you have a mapping to the /CFIDE/scripts > directory, or is it accessible to the browser? It may be that CF is > not finding the scripts it needs to run cfgrid. > > hth, > larry ~| 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:347013 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: implementing CFGRID filter on CF9, blog examples fail
Off the top of my head, do you have a mapping to the /CFIDE/scripts directory, or is it accessible to the browser? It may be that CF is not finding the scripts it needs to run cfgrid. hth, larry > Running ColdFusion Server Standard 9,0,0,251028 and using CFGRID for > the first time in years. It was going just fine until I started > trying to implement a filter. > > First I found Dan Vega's blog: http://www.danvega. > org/blog/2008/3/10/ColdFusion-8-Grid-Filtering > > I downloaded his source and ran it... the grid displays, but no filter. > I'm not proficient at debugging Ajax, but what I did do was: > > 1) Copy the toolbar.js and button.js to the same directory as the code > to be sure. I did this because the path on my server to these files > was different than the path his example expected... when that didn't > work I used the webs to borrow someone else's copy that was in the > path Vega expected... but of course that still didn't work. > > 2) I then wanted to check the first step of all the js setup and wrote > an alert: > alert(ColdFusion.Grid.getGridObject('ArtistGrid')); > result: "undefined" > > Vega's example was written for CF 8. I found another one that was > written for CF9: http://www.thecfguy.com/post. > cfm/add-header-in-cfgrid-in-coldfusion-9 > > This too used the Artist dsn so I copied it verbatim and tried it out. > Same stuff. No actual errors but the EXT toolbar doesn't display, the > alert shows "undefined" and I don't really know what I can do to > diagnose what is going on. > > Any help? Can someone run these examples on CF 9 and let me know if > it works fine for them? If it DOES, any clues what is my malfunction? > Is it that I don't have the 9.01 update installed (not my choice, that... > I don't have control over these servers). > > -Patti ~| 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:347000 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
implementing CFGRID filter on CF9, blog examples fail
Running ColdFusion Server Standard 9,0,0,251028 and using CFGRID for the first time in years. It was going just fine until I started trying to implement a filter. First I found Dan Vega's blog: http://www.danvega.org/blog/2008/3/10/ColdFusion-8-Grid-Filtering I downloaded his source and ran it... the grid displays, but no filter. I'm not proficient at debugging Ajax, but what I did do was: 1) Copy the toolbar.js and button.js to the same directory as the code to be sure. I did this because the path on my server to these files was different than the path his example expected... when that didn't work I used the webs to borrow someone else's copy that was in the path Vega expected... but of course that still didn't work. 2) I then wanted to check the first step of all the js setup and wrote an alert: alert(ColdFusion.Grid.getGridObject('ArtistGrid')); result: "undefined" Vega's example was written for CF 8. I found another one that was written for CF9: http://www.thecfguy.com/post.cfm/add-header-in-cfgrid-in-coldfusion-9 This too used the Artist dsn so I copied it verbatim and tried it out. Same stuff. No actual errors but the EXT toolbar doesn't display, the alert shows "undefined" and I don't really know what I can do to diagnose what is going on. Any help? Can someone run these examples on CF 9 and let me know if it works fine for them? If it DOES, any clues what is my malfunction? Is it that I don't have the 9.01 update installed (not my choice, that... I don't have control over these servers). -Patti ~| 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:346995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Steve's right, if you have unescaped HTML inside the grid (in the data), then it can cause the grid display to be wonky. Brook -Original Message- From: Steve 'Cutter' Blades [mailto:cold.fus...@cutterscrossing.com] Sent: August-11-11 10:28 AM To: cf-talk Subject: Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS) No, you can't update Ext on the server. You could write a straight Ext implementation, skipping the cfajax components all together. Or, it could be a data issue, where something in the data is breaking cfgrid's js. If you're server versions, hotfix levels, etc are all the same then it should just work. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-st yle-user-interfaces/book "The best way to predict the future is to help create it" On 8/11/2011 1:18 PM, Luiz Milfont wrote: > Could it be an EXT issue? Is there any way to update EXT on production server? I ask this, because my CFGRID component uses EXT. > > ~| 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:346709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
No, you can't update Ext on the server. You could write a straight Ext implementation, skipping the cfajax components all together. Or, it could be a data issue, where something in the data is breaking cfgrid's js. If you're server versions, hotfix levels, etc are all the same then it should just work. Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 8/11/2011 1:18 PM, Luiz Milfont wrote: > Could it be an EXT issue? Is there any way to update EXT on production > server? I ask this, because my CFGRID component uses EXT. > > ~| 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:346706 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Could it be an EXT issue? Is there any way to update EXT on production server? I ask this, because my CFGRID component uses EXT. ~| 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:346704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Dear Steve, Yes, I´ve checked versions. All the same. I´ve applied all kinds of patches from Adobe site... I have even copied the CFIDE folder from my machine to production machine, thinking that it might be a CSS problem... Nothing has solved the problem yet. What I can say, if that maybe a clue, is that some html are displayed different in this server, e.g., html tables, sometimes makes scrollbars appear (althought that does not happen in development machines). Maybe it is an IIS or Windows 2000 issue. > Have you checked that the prod server is running the same version of > CF? > Hotfix levels, all that? > > Steve 'Cutter' Blades > Adobe Community Professional > Adobe Certified Expert > Advanced Macromedia ColdFusion MX 7 Developer ~| 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:346703 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Have you checked that the prod server is running the same version of CF? Hotfix levels, all that? Steve 'Cutter' Blades Adobe Community Professional Adobe Certified Expert Advanced Macromedia ColdFusion MX 7 Developer http://blog.cutterscrossing.com Co-Author "Learning Ext JS 3.2" Packt Publishing 2010 https://www.packtpub.com/learning-ext-js-3-2-for-building-dynamic-desktop-style-user-interfaces/book "The best way to predict the future is to help create it" On 8/11/2011 11:16 AM, Luiz Milfont wrote: > Dear Sirs/Madams, > > I am facing a strange issue with CFGRID component, just in production server. > In my development machine or any other, if I install Coldfusion8 and my > application, it works just fine. > > I double-click a grid cell and edit its contents. Then I press the TAB key > to move to the next grid column. When the next grid cell gets focus, the > value of the previous one gets cleared, althought correctly saved at database. > > If I leave the grid page and return to the previous one, the value of the > editted > cell is displayed correctly. It is just a visual issue, but the application > users are complaining that are not feeling safe when entering data on the > grid, because it vanishes right in front of their eyes. > > I would kindly ask if any of you have some fix for this. > > My production server has Coldfusion8 and Windows 2000, using Apache and IIS. > Apache handles requests and IIS runs the Coldfusion application (just because > our IIS version did not compress html pages with gzip). > > Thanks in advance. > Luiz Milfont. > > ~| 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:346702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGRID strange behaviour in Production Server (Windows 2000 + ISS)
Dear Sirs/Madams, I am facing a strange issue with CFGRID component, just in production server. In my development machine or any other, if I install Coldfusion8 and my application, it works just fine. I double-click a grid cell and edit its contents. Then I press the TAB key to move to the next grid column. When the next grid cell gets focus, the value of the previous one gets cleared, althought correctly saved at database. If I leave the grid page and return to the previous one, the value of the editted cell is displayed correctly. It is just a visual issue, but the application users are complaining that are not feeling safe when entering data on the grid, because it vanishes right in front of their eyes. I would kindly ask if any of you have some fix for this. My production server has Coldfusion8 and Windows 2000, using Apache and IIS. Apache handles requests and IIS runs the Coldfusion application (just because our IIS version did not compress html pages with gzip). Thanks in advance. Luiz Milfont. ~| 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:346695 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfgrid format="html" and copy
Try this css at the top of your page .x-grid3-td-0 {-moz-user-select:auto} .x-grid3-td-1 {-moz-user-select:auto} .x-grid3-td-2 {-moz-user-select:auto} .x-grid3-td-3 {-moz-user-select:auto} .x-grid3-td-4 {-moz-user-select:auto} .x-grid3-td-0 {-webkit-user-select::auto} .x-grid3-td-1 {-webkit-user-select::auto} .x-grid3-td-2 {-webkit-user-select:auto} .x-grid3-td-3 {-webkit-user-select:auto} .x-grid3-td-4 {-webkit-user-select:auto} -Aaron McLean ~| 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:345132 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Adding more than 1 row in CFGRID
I am having a problem with CFGRID where I get "Multiple row insert is not supported" when a user clicks the insert row button more than once. Is there a way to disable the Add Row button after it is clicked, or does anyone know how to get CFGRID to insert more than 1 row at a time? Thanks ~| 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:343243 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 - cfgrid posting empty form data
Hi I'm having a mare with an HTML cfgrid which will not post any data whatever I do to it. I've used Flash grids before and not had any problems but this HTML grid I just cannot work out at all. It is bound to a CFC and populates itself just fine. However, once a row is selected and Submit is pressed, the FORM object on the destination page is completely blank. Any thoughts on this I'd really appreciate. The code for the grid is On the page myForm.cfm I get the following blank variables in the FORM object MYGRID __CFGRID__MYFORM__MYGRID Thanks DomH ~| 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:342538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Date format in HTML cfgrid
Well, it won't support properly in your SQL solution because you've converted it to a varchar. Pete On Thu, Feb 3, 2011 at 10:13 AM, Steve Sequenzia wrote: > > I am trying to format dates in an HTML cfgrid. I cannot seem to make it > work in CF when using HTML as the grid type. I have also tried doing it in > MSSQL by using - CONVERT(VARCHAR(10), startDate, 101) AS startDate. > > When I do that it shows up right in the grid but the grid will not sort on > the date properly. > > Anyone know of a way to make it show up in the grid in a mm/dd/ format > and also sort on the date properly? > > Any help would be great. > > 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:341886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Date format in HTML cfgrid
I am trying to format dates in an HTML cfgrid. I cannot seem to make it work in CF when using HTML as the grid type. I have also tried doing it in MSSQL by using - CONVERT(VARCHAR(10), startDate, 101) AS startDate. When I do that it shows up right in the grid but the grid will not sort on the date properly. Anyone know of a way to make it show up in the grid in a mm/dd/ format and also sort on the date properly? Any help would be great. 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:341824 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid bind question
Hi All- I am trying to use cfgrid, as below . I also have a application.cfm file which is checking for a URL variable as below: The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~| 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:339786 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid bind question
Hi All- I am trying to use cfgrid, as below . I also have a application.cfm file which is checking for a URL variable as below: The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~| 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:339785 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid bind question
Hi All- I am trying to use cfgrid, as below . I also have a application.cfm file which is checking for a URL variable as below: The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~| 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:339783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid bind question
Hi All- I am trying to use cfgrid, as below . I also have a application.cfm file which is checking for a URL variable as below: The problem is the call to remote cfc is checking for this URL variable. How can I pass a URL variable in the bind attribute? Thanks ~| 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:339780 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGRID width
in CF9 using CFGRID, for some reason I cannot get it to be 100% the width of the cflayout. I know you can set the width but it's in px which is no good to me. i would like it i could make the width just 100% but its not accepted. any other way to make the with 100% of when inside a cflayout ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfgrid dynamic row colour
http://www.andyscott.id.au/2010/10/5/ColdFusion-9-and-how-to-change-the-colo ur-of-the-row-in-a-CFGrid Regards, Andrew Scott http://www.andyscott.id.au/ > -Original Message- > From: Anthony Doherty [mailto:anthony.dohe...@oakleafcontracts.com] > Sent: Wednesday, 6 October 2010 7:53 AM > To: cf-talk > Subject: cfgrid dynamic row colour > > > Hi i have a grid that displays a date field. > Im looking some help in changing the colour of the row if the date is less than > 2 weeks away?? > also im using cf9 > > Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337887 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid dynamic row colour
Hi i have a grid that displays a date field. Im looking some help in changing the colour of the row if the date is less than 2 weeks away?? also im using cf9 Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
For CF8, can CFGrid html format do drag and drop of rows?
I'd like to create a cfgrid format="html" and be able to drag and drop. What I'm trying to do is sort the rows of the grid by drag and drop and be able to save the updated sorting. I've seen examples in flash format, but can't find examples in html format. The reason I don't want to use flash format is because I can't seem to use to create hyperlinks from a particular column. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337768 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGRID sort order
I've got a cfgrid that I put together using this tutorial: http://www.garyrgilbert.com/tutorials/coldfusion/intermediate/cfgrid.cfm It is working fine except there is an issue with the sorting of one column, the column is called DISPATCHNUM, but the data is not all numeric. The datatype is nvarchar and some entries contain letters. The issue is that most of the entries are sorting fine, but there are quite a few of them that are out of order and I can't figure out why. For instance I'll see 14317, 14316, and 14313, but 14314 will be 20-30 pages back. I've checked to see if there are spaces or anything entered around the number but it is nothing like that. I don't know if I have missed something obvious or there is a better way to troubleshoot this out there. Thanks! I have a cfc called joborder.cfc with the following code: SELECT DISPATCHNUM, SUBMITDATE, WORKCOMPLETE + ' ' as workcomplete, EDITDATE, JOBID, ORDERNUM, JOBNAME, CONTACTFIRST, CONTACTLAST, SERVICEENGINEER FROM JOBORDERS order by #arguments.gridsortcolumn# #arguments.gridsortdirection# On the cfm page this is the cfgrid code: -- ExchangeDefender Message Security: Click below to verify authenticity http://www.exchangedefender.com/verify.asp?id=o8FK66RW024954&from=sa...@tdai.net ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337097 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
show Hide cfgrid?
Is there any way to show a hidden cfgrid based on an OnChange event from another cfgrid? I've tried using a javascript function call with no results: Any suggestions on how I could show the hidden cfgrid from another cfgrid by some other method? Thanks. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How Update 2 Tables from CFGRID - CF 9
Need Help Updating 2 Tables from a Grid Is there a way to do this in CF 9? Some of the grid columns need to update the table "contract". The update code for the other table, "fte" is below. It will fail, obviously, since several columns in the update query belong to the "contract" table. Here's the relevant code: GetRCPsForContracts.UpContract.cfc UPDATE fte SET #colname# = '#value#' WHERE FTE_id = #ARGUMENTS.gridrow.FTE_id# ContractMngmnt.cfm Thanks for any assistance you can provide. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bind to a CFINPUT from a CFGRID
As an aside: I see this time and time again and just don't get it. If you're going to bother to test that url.Parkname exists and isn't a zero length string then why aren't you trimming it when you check? On Fri, Jul 30, 2010 at 12:57 AM, Ria Ragam wrote: > > gridExample.cfm > name="GetParks" datasource="cfdocexamples" >cachedwithin="#CreateTimeSpan(0, 6, 0, 0)#"> >SELECT PARKNAME, REGION, STATE >FROM Parks >Where REGION = 'Southeast Region' >ORDER BY ParkName, State > > > BindOnLoad="no" query="GetParks" format='html' appendKey ="yes" > > header="PARKNAME" > headeralign="center" > headerbold="Yes"> > header="REGION" > headeralign="center" > headerbold="Yes"> > > > bind="url:gridOutput.cfm?PARKNAME={GridForm:Brand_Grid.PARKNAME}"> > > gridOutput.cfm > Echoing main page input: > > > > > > Park Name: > type="Text"> > > > >No input > > > > > > I can't seem to figure out how to bind a selected column value in a > > CFGRID to a text box later on the page. Any ideas? Thanks > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bind to a CFINPUT from a CFGRID
gridExample.cfm SELECT PARKNAME, REGION, STATE FROM Parks Where REGION = 'Southeast Region' ORDER BY ParkName, State gridOutput.cfm Echoing main page input: Park Name: No input > I can't seem to figure out how to bind a selected column value in a > CFGRID to a text box later on the page. Any ideas? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Bind to a CFINPUT from a CFGRID
I can't seem to figure out how to bind a selected column value in a CFGRID to a text box later on the page. Any ideas? Thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335854 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGrid and actionscript
Hi all, I have a small dilemma and would like some suggestions. I have an app that has been working for a long time. It is a Flash Form using a cfgrid. ActionScript and Flash Remoting is used to deal with updating and saving changes, etc. If there is only a row or two in the grid everything is fine, but if there are more than that, the updates to the database take so long that the flash form times out and locks up. Right now the code re-saves every row if it was changed or not. I want to switch to only change items that were actually changed to make things run faster. Using a CFGrid in a non Flash Form sends not only the grid data, but also what changed and what the original value was. Does anyone know how to see this same information in ActionScript? As I see it my options are as follows: 1) Learn how to see that extra information and use it to limit what is updated. 2) Make a copy of the original grid before they make changes, pass both grids to the cfc and have it determine what is changed and update. I'm afraid this might add a bit of over head as well. I don't have time to re-write this app and I can't share the url because it is a internal company website. Any ideas or info on extra data in cfgrids would be appreciated. Thanks, Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9: How pass cfgrid values to a cfm page?
On Fri, Jun 11, 2010 at 9:00 PM, Azadi Saryev wrote: > > On 11/06/2010 23:40, Raymond Camden wrote: >> You've made your button use CF's navigate function, which is NOT going >> to pass the form fields along > > actually, it IS going to pass them if you specify form's name or id as > the last parameter of ColdFusion.navigate() function - which Joy did. Doh! Thanks for that. Had to check the reference just to be sure, but you are absolutely right. -ra ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9: How pass cfgrid values to a cfm page?
On 11/06/2010 23:40, Raymond Camden wrote: > You've made your button use CF's navigate function, which is NOT going > to pass the form fields along actually, it IS going to pass them if you specify form's name or id as the last parameter of ColdFusion.navigate() function - which Joy did. @Joy - you have set http method parameter of ColdFusion.navigate() function to 'GET' - thus your form values will be in URL scope, not in FORM scope. so to get RCP_ID use #url.rcp_id# Azadi ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334500 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9: How pass cfgrid values to a cfm page?
You've made your button use CF's navigate function, which is NOT going to pass the form fields along. Why not just get rid of that and use a normal submit? On Fri, Jun 11, 2010 at 8:16 AM, Joy Rose wrote: > > I get Element RCP_ID is undefined in FORM when I run the code below: If > possible, Id like to continue to work with the ColdFusion.navigate function. > > > RCPMngmnt.cfm excerpt: > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334471 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9: How pass cfgrid values to a cfm page?
I get Element RCP_ID is undefined in FORM when I run the code below: If possible, Id like to continue to work with the ColdFusion.navigate function. RCPMngmnt.cfm excerpt: RCPMngmnt_Insert.cfm: Insert into RCP_table (RCP_ID, RCP_Number, Date_Recived, Amount_of_RCP, cost_code, modification_number, modification_amount, fk_ProgID, fk_ParentMTF, fk_ChildMTF, entry_date, entered_by, funding_year) VALUES(#form.RCP_ID#,'#form.RCP_Number#','#form.Date_Recived#','#form.Amount_of_RCP#',#form.cost_code#, #form.modification_number#, '#form.modification_amount#', #form.fk_ProgID#, '#form.fk_ParentMTF#', '#form.fk_ChildMTF#', '#form.entry_date#', '#form.entered_by#', #form.funding_year#) Select RCP_Number = @@Identity SELECT * from RCP_table WHERE RCP_Number = '#form.RCP_Number#' Thanks in advance for any assistance you can provide. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334469 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9: How pass cfgrid values to a cfm page?
I get Element RCP_ID is undefined in FORM when I run the code below: If possible, Id like to continue to work with the ColdFusion.navigate function. RCPMngmnt.cfm excerpt: RCPMngmnt_Insert.cfm: Insert into RCP_table (RCP_ID, RCP_Number, Date_Recived, Amount_of_RCP, cost_code, modification_number, modification_amount, fk_ProgID, fk_ParentMTF, fk_ChildMTF, entry_date, entered_by, funding_year) VALUES(#form.RCP_ID#,'#form.RCP_Number#','#form.Date_Recived#','#form.Amount_of_RCP#',#form.cost_code#, #form.modification_number#, '#form.modification_amount#', #form.fk_ProgID#, '#form.fk_ParentMTF#', '#form.fk_ChildMTF#', '#form.entry_date#', '#form.entered_by#', #form.funding_year#) Select RCP_Number = @@Identity SELECT * from RCP_table WHERE RCP_Number = '#form.RCP_Number#' Thanks in advance for any assistance you can provide. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfgrid refresh
I have a bindable cfgrid in cf8 that updates just fine (I see the red triangle in the cell). What I need to know is how to refresh the grid after the update so the original cfc that fills the grid runs again to show new updated information. I found these commands but not sure where to put them or how to call them. Should they be in the page or the cfc? ColdFusion.Grid.refresh('mygrid', true) ColdFusion.Grid.getGridObject('MyGrid').render(); ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334194 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID - Empty Response help
Emily.. no problem at all.. sometimes the worst bugs, just need a fresh set of eyes ...no time wasted, glad I could help On Tue, May 25, 2010 at 11:19 AM, Emily McGill wrote: > > Thanks for the help. I went in yesterday to try this change and noticed at > that point (after hours of staring at it last week), it was a darn typo > actually. Fixed it right up. > This line - > has the double a in the invoiceActive line. No wonder my response was empty! > > Isn't that always the way it is? So, I apologize for wasting everyone's time > and I really appreciate the help. I am sure I will need more and I am > learning a lot just by listening in on the conversation here! > > Em > >>Emily, >> >>This line needs a "set" >> >> >> >>Ok, I have read and read and read and I can't figure out what I have got >>going on here. I have a cfc which gets the data to populate the cfgrid. (I >>am so new to all this, not even funny). I do not have an application.cfc, so >>that rules out half the answers to this problem. I have another cfc to a >>different page and when that has no data, it just shows the empty grid. So, >>I don't think it is a configuration type problem. >>The grid is fine when there is data, but I can't figure out how to stop the >>nasty pop-up error when the dataset is empty. Here is the call: >>> stripeRowColor="##cc" width="800" selectmode="row" format="html" >>autowidth="true" pagesize="50" >>bind="cfc:ApprenticeCFC/apprenticeReports.getApprenticeReportData({cfgridpag >>e},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},'#report#')"> >> >>And here is the CFC: >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >>select distinct po.occ_title,ap.occ_code, a.appr_id, a.appr_last_name||', >>'||a.appr_first_name appr_last_name, >>a.appr_first_name, ap.spon_prog_num spon_prog_num, >>decode(updated_expected_compl, null, >>to_char(expected_completion, '/mm/dd'),to_char(updated_expected_compl, >>'mm/dd/')) expected_completion, >>to_char(ap.register_date, '/mm/dd') register_date, >>CASE WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) BETWEEN 16 >>AND 18) THEN 'Y' >> WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) > 18) THEN >>null >> END YOUTH, to_char(i.invoice_date_2009, '/mm/dd') invoice_date_2009, >>invoice_id, to_char(paid_date_2009, '/mm/dd') paid_date_2009, >>to_char(voided_date_2009, '/mm/dd') voided_date_2009 >>from r_apprentice a, r_rais_user u, spon_login sl, r_appr_program ap, >> r_prog_occupation po, invoices i >>where upper(u.USER_ID) = upper('#Session.username#') and u.user_id = >>sl.USER_ID >>and a.appr_id = ap.APPR_ID and sl.spon_prog_num = ap.spon_prog_num and >>terminate_rsn is null >>and ap.spon_prog_num = po.spon_prog_num and ap.occ_code = po.occ_code and >>i.appr_id = a.appr_id >> >> order by #gridsortcolumn# #gridsortdirection# >> >> order by invoice_id >> >> >> >> >> >> >> >> >>Please, please help. I apologize if I have missed a solution out there >>somewhere, I have hunted and hunted, but everything seems to be either a >>problem with the application.cfc or something more advanced than I am using. >> >>This is the first time I ever posted a question anywhere in 13 years of IT >>work, so let me know if you need more info or anything. >> >> >> >> >> >> >> >> >> >>. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFGRID - Empty Response help
Thanks for the help. I went in yesterday to try this change and noticed at that point (after hours of staring at it last week), it was a darn typo actually. Fixed it right up. This line - has the double a in the invoiceActive line. No wonder my response was empty! Isn't that always the way it is? So, I apologize for wasting everyone's time and I really appreciate the help. I am sure I will need more and I am learning a lot just by listening in on the conversation here! Em >Emily, > >This line needs a "set" > > > >Ok, I have read and read and read and I can't figure out what I have got >going on here. I have a cfc which gets the data to populate the cfgrid. (I >am so new to all this, not even funny). I do not have an application.cfc, so >that rules out half the answers to this problem. I have another cfc to a >different page and when that has no data, it just shows the empty grid. So, >I don't think it is a configuration type problem. >The grid is fine when there is data, but I can't figure out how to stop the >nasty pop-up error when the dataset is empty. Here is the call: > stripeRowColor="##cc" width="800" selectmode="row" format="html" >autowidth="true" pagesize="50" >bind="cfc:ApprenticeCFC/apprenticeReports.getApprenticeReportData({cfgridpag >e},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},'#report#')"> > >And here is the CFC: > > > > > > > > > > > > > > > > > >select distinct po.occ_title,ap.occ_code, a.appr_id, a.appr_last_name||', >'||a.appr_first_name appr_last_name, >a.appr_first_name, ap.spon_prog_num spon_prog_num, >decode(updated_expected_compl, null, >to_char(expected_completion, '/mm/dd'),to_char(updated_expected_compl, >'mm/dd/')) expected_completion, >to_char(ap.register_date, '/mm/dd') register_date, >CASE WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) BETWEEN 16 >AND 18) THEN 'Y' > WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) > 18) THEN >null > END YOUTH, to_char(i.invoice_date_2009, '/mm/dd') invoice_date_2009, >invoice_id, to_char(paid_date_2009, '/mm/dd') paid_date_2009, >to_char(voided_date_2009, '/mm/dd') voided_date_2009 >from r_apprentice a, r_rais_user u, spon_login sl, r_appr_program ap, > r_prog_occupation po, invoices i >where upper(u.USER_ID) = upper('#Session.username#') and u.user_id = >sl.USER_ID >and a.appr_id = ap.APPR_ID and sl.spon_prog_num = ap.spon_prog_num and >terminate_rsn is null >and ap.spon_prog_num = po.spon_prog_num and ap.occ_code = po.occ_code and >i.appr_id = a.appr_id > > order by #gridsortcolumn# #gridsortdirection# > > order by invoice_id > > > > > > > > >Please, please help. I apologize if I have missed a solution out there >somewhere, I have hunted and hunted, but everything seems to be either a >problem with the application.cfc or something more advanced than I am using. > >This is the first time I ever posted a question anywhere in 13 years of IT >work, so let me know if you need more info or anything. > > > > > > > > > >. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333974 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFGRID - Empty Response help
Emily, This line needs a "set" -Original Message- From: Emily McGill [mailto:cassadinec...@gmail.com] Sent: Friday, May 21, 2010 1:38 PM To: cf-talk Subject: CFGRID - Empty Response help Ok, I have read and read and read and I can't figure out what I have got going on here. I have a cfc which gets the data to populate the cfgrid. (I am so new to all this, not even funny). I do not have an application.cfc, so that rules out half the answers to this problem. I have another cfc to a different page and when that has no data, it just shows the empty grid. So, I don't think it is a configuration type problem. The grid is fine when there is data, but I can't figure out how to stop the nasty pop-up error when the dataset is empty. Here is the call: And here is the CFC: select distinct po.occ_title,ap.occ_code, a.appr_id, a.appr_last_name||', '||a.appr_first_name appr_last_name, a.appr_first_name, ap.spon_prog_num spon_prog_num, decode(updated_expected_compl, null, to_char(expected_completion, '/mm/dd'),to_char(updated_expected_compl, 'mm/dd/')) expected_completion, to_char(ap.register_date, '/mm/dd') register_date, CASE WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) BETWEEN 16 AND 18) THEN 'Y' WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) > 18) THEN null END YOUTH, to_char(i.invoice_date_2009, '/mm/dd') invoice_date_2009, invoice_id, to_char(paid_date_2009, '/mm/dd') paid_date_2009, to_char(voided_date_2009, '/mm/dd') voided_date_2009 from r_apprentice a, r_rais_user u, spon_login sl, r_appr_program ap, r_prog_occupation po, invoices i where upper(u.USER_ID) = upper('#Session.username#') and u.user_id = sl.USER_ID and a.appr_id = ap.APPR_ID and sl.spon_prog_num = ap.spon_prog_num and terminate_rsn is null and ap.spon_prog_num = po.spon_prog_num and ap.occ_code = po.occ_code and i.appr_id = a.appr_id order by #gridsortcolumn# #gridsortdirection# order by invoice_id Please, please help. I apologize if I have missed a solution out there somewhere, I have hunted and hunted, but everything seems to be either a problem with the application.cfc or something more advanced than I am using. This is the first time I ever posted a question anywhere in 13 years of IT work, so let me know if you need more info or anything. . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFGRID - Empty Response help
Ok, I have read and read and read and I can't figure out what I have got going on here. I have a cfc which gets the data to populate the cfgrid. (I am so new to all this, not even funny). I do not have an application.cfc, so that rules out half the answers to this problem. I have another cfc to a different page and when that has no data, it just shows the empty grid. So, I don't think it is a configuration type problem. The grid is fine when there is data, but I can't figure out how to stop the nasty pop-up error when the dataset is empty. Here is the call: And here is the CFC: select distinct po.occ_title,ap.occ_code, a.appr_id, a.appr_last_name||', '||a.appr_first_name appr_last_name, a.appr_first_name, ap.spon_prog_num spon_prog_num, decode(updated_expected_compl, null, to_char(expected_completion, '/mm/dd'),to_char(updated_expected_compl, 'mm/dd/')) expected_completion, to_char(ap.register_date, '/mm/dd') register_date, CASE WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) BETWEEN 16 AND 18) THEN 'Y' WHEN (trunc86400*(sysdate-birth_date))/60)/60)/24/365) > 18) THEN null END YOUTH, to_char(i.invoice_date_2009, '/mm/dd') invoice_date_2009, invoice_id, to_char(paid_date_2009, '/mm/dd') paid_date_2009, to_char(voided_date_2009, '/mm/dd') voided_date_2009 from r_apprentice a, r_rais_user u, spon_login sl, r_appr_program ap, r_prog_occupation po, invoices i where upper(u.USER_ID) = upper('#Session.username#') and u.user_id = sl.USER_ID and a.appr_id = ap.APPR_ID and sl.spon_prog_num = ap.spon_prog_num and terminate_rsn is null and ap.spon_prog_num = po.spon_prog_num and ap.occ_code = po.occ_code and i.appr_id = a.appr_id order by #gridsortcolumn# #gridsortdirection# order by invoice_id Please, please help. I apologize if I have missed a solution out there somewhere, I have hunted and hunted, but everything seems to be either a problem with the application.cfc or something more advanced than I am using. This is the first time I ever posted a question anywhere in 13 years of IT work, so let me know if you need more info or anything. . ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFgrid default save and cancel buttons
Does anyone know how to change the default "save" and "cancel" buttons in an editable cfgrid (html format)? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
inserting a new record with identity key using cfgrid bind onchange
I got an error message on trying to insert a row to a table with an identity column using cfgrid onchange I would like also to use a stored procedure instead of cfquery I just need how to call it and how to pass arguments to it Please look below is the code,component, and error message My component UPDATE SP.MediaType SET #colname# = '#value#' WHERE MediaTypeID = #ARGUMENTS.gridrow.MediaTypeID# update SP.MediaType set Deleted=1 WHERE MediaTypeID = #ARGUMENTS.gridrow.MediaTypeID# insert into SP.MediaType (#colname#) Values ('#value#') --- my table mediatype: mediatypeid primary key,identity mediatypename my code is __ on insert I get the following error message ajax logging error message http: Error invoking xxx/MediaType.cfc : Element '' is undefined in a CFML structure referenced as part of an expression. {"gridaction":"I","gridrow":{"MEDIATYPEID":"","MEDIATYPENAME":"uu","CFGRIDROWINDEX":4},"gridchanged":{}} ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 binding cfgrid
Firebug shows an ' ' in the grid. I see several gets in the HTTP request. I have copied and pasted the details below. - {URL}messageWindow.cfm?PlayerID=5&_cf_containerId=myCFWindow_body&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=0 GET messageWindow.cfm?PlayerID=5&_cf_containerId=myCFWindow_body&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=0 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:26 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- {URL}messages.cfc?method=dispMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=1 GET messages.cfc?method=dispMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=1 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:28 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- {URL}/messages.cfc?method=dispSentMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=2 GET messages.cfc?method=dispSentMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=2 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:28 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- > What does Firebug or Chrome's Dev Tools show you in the HTTP request? > Is CF Debugging on? > > On Sun, May 9, 2010 at 2:41 PM, Alteria > wrote: > > > > I am having some issues figuring this one out. The code was all > working with ColdFusion 8, then we moved to a CF 9 server and > discovered the code was no longer working. It seems like the grid > never stops loading. I have placed the code snippets below and parts > from the cfdebug window to show there is one result displaying. I > can't figure out what changed from 8 to 9. Any assistance would be > appreciated. > > > > > > Main CFM file: > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 binding cfgrid
Firebug shows an ' ' in the grid. I see several gets in the HTTP request. I have copied and pasted the details below. - {URL}messageWindow.cfm?PlayerID=5&_cf_containerId=myCFWindow_body&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=0 GET messageWindow.cfm?PlayerID=5&_cf_containerId=myCFWindow_body&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=0 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:26 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- {URL}messages.cfc?method=dispMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=1 GET messages.cfc?method=dispMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=1 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:28 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- {URL}/messages.cfc?method=dispSentMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=2 GET messages.cfc?method=dispSentMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=906501B01E1AB13D8A5B208A3C79EA53&_cf_rc=2 HTTP/1.1 Host: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3 ( .NET CLR 3.5.30729) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-us,en;q=0.5 Accept-Encoding: gzip,deflate Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Keep-Alive: 115 Connection: keep-alive Referer: Cookie: CFID=; CFTOKEN=; JSESSIONID= HTTP/1.1 200 OK Connection: close Date: Thu, 13 May 2010 11:48:28 GMT Server: Microsoft-IIS/6.0 X-Powered-By: ASP.NET Pragma: public Content-Type: text/html; charset=UTF-8 Expires: 0 Cache-Control: must-revalidate, post-check=0, pre-check=0 -- > What does Firebug or Chrome's Dev Tools show you in the HTTP request? > Is CF Debugging on? > > On Sun, May 9, 2010 at 2:41 PM, Alteria > wrote: > > > > I am having some issues figuring this one out. The code was all > working with ColdFusion 8, then we moved to a CF 9 server and > discovered the code was no longer working. It seems like the grid > never stops loading. I have placed the code snippets below and parts > from the cfdebug window to show there is one result displaying. I > can't figure out what changed from 8 to 9. Any assistance would be > appreciated. > > > > > > Main CFM file: > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion 9 binding cfgrid
What does Firebug or Chrome's Dev Tools show you in the HTTP request? Is CF Debugging on? On Sun, May 9, 2010 at 2:41 PM, Alteria wrote: > > I am having some issues figuring this one out. The code was all working with > ColdFusion 8, then we moved to a CF 9 server and discovered the code was no > longer working. It seems like the grid never stops loading. I have placed the > code snippets below and parts from the cfdebug window to show there is one > result displaying. I can't figure out what changed from 8 to 9. Any > assistance would be appreciated. > > > Main CFM file: > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
ColdFusion 9 binding cfgrid
I am having some issues figuring this one out. The code was all working with ColdFusion 8, then we moved to a CF 9 server and discovered the code was no longer working. It seems like the grid never stops loading. I have placed the code snippets below and parts from the cfdebug window to show there is one result displaying. I can't figure out what changed from 8 to 9. Any assistance would be appreciated. Main CFM file: CFC file: select btvUser.users.users_usernameDisp, btvUser.messages.messages_id, btvUser.messages.messages_title, btvUser.messages.messages_date_sent, case when btvUser.messages.messages_isRead = 0 then 'New' else 'Old' end AS messages_isRead_updated from btvUser.messages left outer join btvUser.users on btvUser.users.users_id = btvUser.messages.messages_from_users_id where btvUser.messages.messages_to_users_id = 5 CFDEBUG: info:http: CFC invocation response: {"QUERY":{"COLUMNS":["USERS_USERNAMEDISP","MESSAGES_ID","MESSAGES_TITLE","MESSAGES_DATE_SENT","MESSAGES_ISREAD_UPDATED"],"DATA":[["Alteria",118,"Testing This","May, 09 2010 08:25:36","New"]]},"TOTALROWCOUNT":1} info:http: CFC invocation response: {"QUERY":{"COLUMNS":["USERS_USERNAMEDISP","MESSAGES_ID","MESSAGES_TO_USERS_ID","MESSAGES_TITLE","MESSAGES_DATE_SENT","MESSAGES_ISREAD"],"DATA":[["Alteria",118,5,"Testing This","May, 09 2010 08:25:36",0]]},"TOTALROWCOUNT":1} info:http: Replaced markup for element: myCFWindow_body info:widget: Selected tab, id: readMessages in tab container, id: messageArea info:widget: Created grid, id: getSentMsg info:http: HTTP GET messages.cfc?method=dispSentMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=252D76B0060B6273D425D8A95F88B2AC&_cf_rc=10 info:http: Invoking CFC: messages.cfc , function: dispSentMessages , arguments: {"page":1,"pageSize":10,"gridsortcolumn":"","gridsortdirection":"ASC"} info:widget: Created grid, id: getMsg info:http: HTTP GET messages.cfc?method=dispMessages&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A25%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22ASC%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=252D76B0060B6273D425D8A95F88B2AC&_cf_rc=9 info:http: Invoking CFC: messages.cfc , function: dispMessages , arguments: {"page":1,"pageSize":25,"gridsortcolumn":"","gridsortdirection":"ASC"} ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333536 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
I tell everyone that the cfajax tags are great for rapid prototyping, but it's best to go straight ExtJs for production implementation on anything but the simplest work. One of the biggest issues I've seen, in examples of paging with the cfgrid tags, is the use of the QueryConvertForGrid() method for creating your paged datasets. If performance is an issue, you will be much better served by writing a true paging query. The QueryConvertForGrid() method is basically taking on a QueryOfQuery approach, whereby your querying your entire recordset and filtering it down at the CF level before passing it to the grid. For large datasets, this is handled much better at your SQL tier. There are many examples on this out on the web. It's fairly trivial with MS SQL, and really easy with MySQL. Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Steve "Cutter" Blades Adobe Community Professional - ColdFusion Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of "Learning Ext JS" http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Eric . wrote: > Playing with some CFGRID examples on ColdFusion 9, I noticed some major > slowdown without a lot of records being loaded. Being on a locally hosted > server off my workstation that concerned me even more. > > I have a lot of CRUD pages for various parts of a management system we're > re-writing as a Software-as-a-Service app that would be great candidates for > a CFC that creates a CFGRID (or something similar) with dynamic functionality. > > However playing with my examples, I worry about real-world use and larger > datasets making them judge our app for something that isn't its fault. > > > Currently I follow the old tried and true model of an HTML table that > displays data, a link to edit that goes to a form, etc. Inline editing would > work great for a lot of these screens, so a grid-based format seems ideal. > > > Has anyone had any great success with moving away from the old-school > approach to something a little more modern? > > I'm on a dual-core box with 2 gigs of ram, which might be a tad higher than > I'd expect from our users. I'm looking for something that does what I need > it to do but without that "clunky" feeling. > > > Am I just not customizing CFGRID well enough, or am I on to something you've > realized as well? > > TIA :) > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333506 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
On Fri, May 7, 2010 at 11:27 AM, Will Tomlinson wrote: > >> Playing with some CFGRID examples on ColdFusion 9, I noticed some >> major slowdown without a lot of records being loaded. Being on a >> locally hosted server off my workstation that concerned me even more. > > > I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes > that problem. > > http://www.trirand.com/jqgridwiki/doku.php?id=start +1 for not actually using cfgrid. :) I like dojo's grids/data binding stuff. Here's an example of a cool one: http://www.dojotoolkit.org/reference-guide/dojox/grid/EnhancedGrid.html Awesome stuff. The demos that come with the source work better than the online ones, I don't think they update those demos much. They're trying to keep the goodness hidden, for some reason. But don't let that fool you, it's *powerful* stuff :) :Den -- What every genuine philosopher (every genuine man, in fact) craves most is praise although the philosophers generally call it recognition! William Jame ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333499 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
> Playing with some CFGRID examples on ColdFusion 9, I noticed some > major slowdown without a lot of records being loaded. Being on a > locally hosted server off my workstation that concerned me even more. I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes that problem. http://www.trirand.com/jqgridwiki/doku.php?id=start Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
Thanks Dan, Do you have any specific links that you've come across and deemed authoritative for some of those techniques? There's a lot of CFGRID examples but some lead to broken javascript errors in IE or other buggy functionality. > On Thu, May 6, 2010 at 5:10 PM, Eric . wrote: ... > > > Am I just not customizing CFGRID well enough, or am I on to > something you've realized as well? > > I don't know about cfgrid specifically, but the principal is sound, > and works, and there are tricks to make it work better (splitting up > some stuff so it loads right away and then lazy loading other stuff, > which toolkit you roll with, etc.). > > I just *love* my scrolling grids. To heck with manual paging! > > And these grids can be blazingly fast, if that was your real question. > :) > > :Den > > -- > Time itself comes in drops. > William James ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333482 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
On Thu, May 6, 2010 at 5:10 PM, Eric . wrote: ... > Am I just not customizing CFGRID well enough, or am I on to something you've > realized as well? I don't know about cfgrid specifically, but the principal is sound, and works, and there are tricks to make it work better (splitting up some stuff so it loads right away and then lazy loading other stuff, which toolkit you roll with, etc.). I just *love* my scrolling grids. To heck with manual paging! And these grids can be blazingly fast, if that was your real question. :) :Den -- Time itself comes in drops. William James ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
Playing with some CFGRID examples on ColdFusion 9, I noticed some major slowdown without a lot of records being loaded. Being on a locally hosted server off my workstation that concerned me even more. I have a lot of CRUD pages for various parts of a management system we're re-writing as a Software-as-a-Service app that would be great candidates for a CFC that creates a CFGRID (or something similar) with dynamic functionality. However playing with my examples, I worry about real-world use and larger datasets making them judge our app for something that isn't its fault. Currently I follow the old tried and true model of an HTML table that displays data, a link to edit that goes to a form, etc. Inline editing would work great for a lot of these screens, so a grid-based format seems ideal. Has anyone had any great success with moving away from the old-school approach to something a little more modern? I'm on a dual-core box with 2 gigs of ram, which might be a tad higher than I'd expect from our users. I'm looking for something that does what I need it to do but without that "clunky" feeling. Am I just not customizing CFGRID well enough, or am I on to something you've realized as well? TIA :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bind CFgrid data to Textbox
As far as I can tell using CF9, the "value" field can't be used in CFGrid. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:48 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
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.adcalpo 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 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: > > 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"> > Browser must support Java to view ColdFusion Java > Applets > > > 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?
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" To: "cf-talk" 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: > > > select EmployeeID, GivenName, Surname, Bundyno > from dbo.tblEmployee > > > > > > > > value="#application.applicationname#" > label="Test of the cfforms" validate="email" message="Checking the > validation"/> > > > > > > > > > > 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 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?
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?
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: > > > select EmployeeID, GivenName, Surname, Bundyno > from dbo.tblEmployee > > > > > > > > label="Test of the cfforms" validate="email" message="Checking the > validation"/> > > > > > > > > > > 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 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?
> 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: 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"> Browser must support Java to view ColdFusion Java Applets 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?
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: select EmployeeID, GivenName, Surname, Bundyno from dbo.tblEmployee 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 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?
> 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
Where do i find CFGRID Code?
I have an application where the client's code, containing some CFGrid tags works fine on the production server built by a previous developer, but when I load all that code onto my dev server, so i have a local working copy, the CFGRID tags dont work. I'm guessing this is because I have a non-default layout of my dev server's ColdFusion code, and therefore i need to use the scriptsrc attribute in the CFFORM tag. (the clue i'm working on is the error message in place of the grid, which says [quote] load: class coldfusion.applets.CFGridApplet.class not found. java.lang.ClassNotFoundException: coldfusion.applets.CFGridApplet.class [/quote] The java error message also says: [quote] Java Plug-in 1.6.0_19 Using JRE version 1.6.0_19-b04 Java HotSpot(TM) Client VM User home directory = C:\Documents and Settings\Michael [/quote] 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? [B] If yes, where is it to be found? what am i looking for? [C] if No, what do you think is the problem and therefore the solution? -- 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 ~| 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:333052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm