Re: Having trouble with cfcI have removed all references to site_theartoflovingcatsanddogs_com and deleted the template cache. No luck. Any help?

2014-07-22 Thread Claude Schnéegans

 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?

2014-07-22 Thread Mark A Kruger

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

2014-07-22 Thread Rob Voyle

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Andrew Scott

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

2014-07-22 Thread John M Bliss

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Maureen

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Andrew Scott

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

2014-07-22 Thread Byron Mann

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Andrew Scott

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Maureen

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Maureen

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

2014-07-22 Thread Andrew Scott

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread Andrew Scott

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

2014-07-22 Thread Stephen Hait

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

2014-07-22 Thread .jonah

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

2014-07-22 Thread UXB

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

2014-07-22 Thread Rakesh Prasad

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