Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?
maybe he's a bot? If he is, sure he didn't programed it himself. ~| 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:358957 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?
I hope the art of loving cats and dogs is painting or crafts or something :D -Original Message- From: Claude Schnéegans schneeg...@internetique.com [mailto:=?ISO-8859-1?Q?Claude_Schn=E9egans schneegans@interneti=71?= =?ISO-8859-1?Q?ue.com=3E?=] Sent: Tuesday, July 22, 2014 8:49 AM To: cf-talk Subject: Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help? maybe he's a bot? If he is, sure he didn't programed it himself. ~| 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:358958 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion and authorize.net
Hi Eric I use coldfusion and authorize.net and I am big into simple Take a look at: https://www.appreciativeway.com/secure/paymentPortal.cfm If that is what you want I could help you off line. Biggest challenge is maintaining the PCI compliance to which end you may want to use their forms. Rob Robert J. Voyle, Psy.D. Director, Clergy Leadership Institute For Coaching and Training in Appreciative Inquiry Author: Restoring Hope: Appreciative Strategies to Resolve Grief and Resentment http://www.appreciativeway.com/ 503-647-2378 or 503-647-2382 On 21 Jul 2014 at 15:03, Eric Bourland wrote: ColdFusion 9 MS SQL Server 2012 authorize.net API Hi. I need help with a problem, and am hoping someone here can guide me on the right path. In brief: I need to populate an authorize.net payment page using information from a simple form that is processed in coldfusion. Details: I need to do something fairly simple -- or, I am told it is simple. =) Here is what the client wants to happen: After the user fills out and submits the simple registration form, she should then see the authorize.net payment page where she pays conference registration fees; the client would like the authorize.net payment page to already display the information (name, address, payment amount, and so on) that the user already typed in the ColdFusion form I downloaded some sample code from authorize.net -- it is given below. I would like the registrant to register her information -- name, address, conference fee -- then go to the authorize.net payment page and see all of her contact information, and the conference fee that she selected, already populated in the payment fields. Has anyone here done this with ColdFusion? I am not clear how to integrate the cfhttp code with my existing, simple registration form. Thank you for your advice. Eric cfsetting enablecfoutputonly=true cfoutput !-- This sample code is designed to connect to Authorize.net using the AIM method. For API documentation or additional sample code, please visit: http://developer.authorize.net -- !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN http://www.w3.org/TR/html4/loose.dtd; HTML lang='en' HEAD TITLE Sample AIM Implementation /TITLE /HEAD BODY P This sample code is designed to generate a post using Authorize.net's Advanced Integration Method (AIM) and display the results of this post to the screen. /P P For details on how this is accomplished, please review the readme file, the comments in the sample code, and the Authorize.net AIM API documentation found at http://developer.authorize.net /P HR / /cfoutput !--- ColdFusion's cfhttp object is specifically designed to create a post, and retrieve the results. Those results are accessed in cfhttp.filecontent --- !--- By default, this sample code is designed to post to our test server for developer accounts: https://test.authorize.net/gateway/transact.dll for real accounts (even in test mode), please make sure that you are\posting to: https://secure.authorize.net/gateway/transact.dll --- cfhttp method=Post url=https://test.authorize.net/gateway/transact.dll; !--- the API Login ID and Transaction Key must be replaced with valid values --- cfhttpparam type=Formfield name=x_login value=API_LOGIN_ID cfhttpparam type=Formfield name=x_tran_key value=TRANSACTION_KEY cfhttpparam type=Formfield name=x_delim_data value=TRUE cfhttpparam type=Formfield name=x_delim_char value=| cfhttpparam type=Formfield name=x_relay_response value=FALSE cfhttpparam type=Formfield name=x_type value=AUTH_CAPTURE cfhttpparam type=Formfield name=x_method value=CC cfhttpparam type=Formfield name=x_card_num value=4111 cfhttpparam type=Formfield name=x_exp_date value=0115 cfhttpparam type=Formfield name=x_amount value=19.99 cfhttpparam type=Formfield name=x_description value=Sample Transaction cfhttpparam type=Formfield name=x_first_name value=John cfhttpparam type=Formfield name=x_last_name value=Doe cfhttpparam type=Formfield name=x_address value=1234 Street cfhttpparam type=Formfield name=x_state value=WA cfhttpparam type=Formfield name=x_zip value=98004 !--- Additional fields can be added here as outlined in the AIM integration guide at: http://developer.authorize.net --- !--- The following fields show an example of how to include line item details, they are commented out by default. cfhttpparam type=Formfield name=x_line_item value=item1|golf balls||2|18.95|Y cfhttpparam type=Formfield name=x_line_item value=item2|golf bag|Wilson golf carry bag, red|1|39.99|Y cfhttpparam type=Formfield name=x_line_item value=item3|book|Golf for Dummies|1|21.99|Y --- /cfhttp !--- Because coldfusion's ListToArray object ignores empty fields, we
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: cfgrid 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: cffunction name=getPilots access=remote returntype=struct cfargument name=page required=true / cfargument name=pageSize required=true / cfargument name=gridsortcolumn required=true / cfargument name=gridsortdirection required=true / cfargument name=pil_email type=string required=no default= / cfargument name=pil_lname type=string required=no default= / cfargument name=pil_n_number type=string required=no default= / cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = pil_email / cfset arguments.gridsortdirection = asc / /cfif cfquery name=pilots datasource=hope select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_email#% and pil_lname like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_lname#% and pil_n_number like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_n_number#% order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfquery cfreturn queryconvertforgrid(pilots, page, pagesize) / /cffunction 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
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 stephenh...@gmail.com 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: cfgrid 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: cffunction name=getPilots access=remote returntype=struct cfargument name=page required=true / cfargument name=pageSize required=true / cfargument name=gridsortcolumn required=true / cfargument name=gridsortdirection required=true / cfargument name=pil_email type=string required=no default= / cfargument name=pil_lname type=string required=no default= / cfargument name=pil_n_number type=string required=no default= / cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = pil_email / cfset arguments.gridsortdirection = asc / /cfif cfquery name=pilots datasource=hope select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_email#% and pil_lname like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_lname#% and pil_n_number like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_n_number#% order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfquery cfreturn queryconvertforgrid(pilots, page, pagesize) / /cffunction 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
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 andr...@andyscott.id.au 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 stephenh...@gmail.com 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: cfgrid 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: cffunction name=getPilots access=remote returntype=struct cfargument name=page required=true / cfargument name=pageSize required=true / cfargument name=gridsortcolumn required=true / cfargument name=gridsortdirection required=true / cfargument name=pil_email type=string required=no default= / cfargument name=pil_lname type=string required=no default= / cfargument name=pil_n_number type=string required=no default= / cfif arguments.gridsortcolumn eq cfset arguments.gridsortcolumn = pil_email / cfset arguments.gridsortdirection = asc / /cfif cfquery name=pilots datasource=hope select userid, pil_n_number, pil_email, pil_lname, pil_fname, pil_password, last_login from pilots where 0=0 and pil_email like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_email#% and pil_lname like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_lname#% and pil_n_number like cfqueryparam cfsqltype=cf_sql_varchar value=%#arguments.pil_n_number#% order by #arguments.gridsortcolumn# #arguments.gridsortdirection# /cfquery cfreturn queryconvertforgrid(pilots, page, pagesize) / /cffunction 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
On Tue, Jul 22, 2014 at 1:34 PM, Andrew Scott andr...@andyscott.id.au 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
On Tue, Jul 22, 2014 at 1:38 PM, John M Bliss bliss.j...@gmail.com 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:08 PM, Stephen Hait stephenh...@gmail.com 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 2:01 PM, Maureen mamamaur...@gmail.com wrote: On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait stephenh...@gmail.com 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
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 stephenh...@gmail.com wrote: On Tue, Jul 22, 2014 at 2:01 PM, Maureen mamamaur...@gmail.com wrote: On Tue, Jul 22, 2014 at 1:08 PM, Stephen Hait stephenh...@gmail.com 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
Spelling Correction
Working on a search feature on CF8 with Verity. I see that it returns suggestions for alternate searches. We were hoping to use this for a feature similar to Google's Did you mean, when you fat finger a word. However, the suggestions returned from Verity are pretty horrible and useless. Has anyone done this type of thing previously and have any suggestions? I was thinking if there is an API out there to do this, that might work. I did the Googling with a few suggestions, but mainly came across Thesaurus type APIs. Doesn't seem to be too many auto-correction services. -- Regards, Byron Mann ~| 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:358968 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 andr...@andyscott.id.au 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
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 stephenh...@gmail.com wrote: On Tue, Jul 22, 2014 at 3:04 PM, Andrew Scott andr...@andyscott.id.au 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 4:10 PM, Andrew Scott andr...@andyscott.id.au 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
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 stephenh...@gmail.com 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:40 PM, Maureen mamamaur...@gmail.com 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 didn't see scopes on the variables in your return statement. cfreturn queryconvertforgrid(pilots, page, pagesize) / Not sure if that matters, but I would scope them just in case. On Tue, Jul 22, 2014 at 4:47 PM, Stephen Hait stephenh...@gmail.com wrote: On Tue, Jul 22, 2014 at 4:40 PM, Maureen mamamaur...@gmail.com 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
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 mamamaur...@gmail.com wrote: I didn't see scopes on the variables in your return statement. cfreturn queryconvertforgrid(pilots, page, pagesize) / Not sure if that matters, but I would scope them just in case. On Tue, Jul 22, 2014 at 4:47 PM, Stephen Hait stephenh...@gmail.com wrote: On Tue, Jul 22, 2014 at 4:40 PM, Maureen mamamaur...@gmail.com 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
On Tue, Jul 22, 2014 at 4:51 PM, Maureen mamamaur...@gmail.com wrote: I didn't see scopes on the variables in your return statement. cfreturn queryconvertforgrid(pilots, page, pagesize) / 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
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 stephenh...@gmail.com wrote: On Tue, Jul 22, 2014 at 4:51 PM, Maureen mamamaur...@gmail.com wrote: I didn't see scopes on the variables in your return statement. cfreturn queryconvertforgrid(pilots, page, pagesize) / 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 5:06 PM, Andrew Scott andr...@andyscott.id.au 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: Spelling Correction
Maybe you could pass your input through something like http://cfspell.riaforge.org/ On 7/22/14, 12:37 PM, Byron Mann wrote: Working on a search feature on CF8 with Verity. I see that it returns suggestions for alternate searches. We were hoping to use this for a feature similar to Google's Did you mean, when you fat finger a word. However, the suggestions returned from Verity are pretty horrible and useless. Has anyone done this type of thing previously and have any suggestions? I was thinking if there is an API out there to do this, that might work. I did the Googling with a few suggestions, but mainly came across Thesaurus type APIs. Doesn't seem to be too many auto-correction services. ~| 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:358979 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Regex help maybe
Thanks to everyone. I managed to come up with one similar to Byron's example and then tweaked it further (No spaces) so I could use it in JS on the client and CF on the server. I knew I could do it in 2 or three steps but wanted one step so I could hand off the regex to the client for validation. Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com So like this in the second variant: ^(?=.*\d.*\d.*\d)(?=.*[\~\!\@\#\$\%\^\\*\(\)\_\+]+)[\d\~\!\@\#\$\%\^\\*\(\ )\_\+]{10,20}$ ~| 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:358980 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: need help with two sites - willing to pay $45/hour
Hi, We have excellent experience in Coldfusion based website and web application development as mentioned below, Also we have a team of well experienced developers in Coldfusion technology. Experience : around 15 years Projects: 200 web application and website. We can provide help you to troubleshoot your website issues. Thanks Regards RK Prasad On Tue, Jul 22, 2014 at 6:56 AM, Matthew Smith chedders...@gmail.com wrote: I have two sites with minor issues I need help with. http://www.theartoflovingcatsanddogs.com http://www.fatcate-juice.com The first is an image reference issue and the second has to do with a cfc issue. Please let me know if anyone is interested. Thanks. -- Regards, chedder is bedder ~| 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:358981 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm