Re: CF 404 handler non being invoked on IIS
You will need to change a setting in IIS for the 404 page not found and point it to a CF page designed to process those requests. Thanks, Brian On Feb 8, 2015, at 11:35 AM, Mark Spence markpence...@gmail.com wrote: This is working on the live hosted site, but on my local install of iis and cf it isn't. I have ses urls like this: http://mysitedotcom/item-section/item-name-1034/index.cfm The directories item-section and item-name-1034 do not exist, so it should invoke the Application.cfc onMissingTemplate function, which is set up to serve the proper dynamic page. However on my local setup, I am getting this iis error: HTTP Error 404.0 - Not Found Detailed Error Information: Module IIS Web Core Notification MapRequestHandler Handler cfmHandler Error Code 0x80070002 Requested URL http://mysitedotcom:80/site_mysubsite_com/items/item-name-1034/index.cfm Physical Path C:\wwwroot\site_mysite_com\item-section\item-name-1034\index.cfm Logon Method Anonymous Logon User Anonymous It's like CF is not even getting to see the missing template error before IIS steps in. I tried setting Application.cfc as the error page for 404 errors but no dice. How can I make CF take priority and handle the 404 error? Thank you. ~| 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:360089 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need someone to help with site
Hi Matthew, What is the site? Any specifics as to why the site is down? Regards, Brian Cain Sent from my iPhone On Jul 6, 2014, at 8:18 PM, Matthew Smith chedders...@gmail.com wrote: I need someone to help with a site that has been down for a month. Will pay $50 hour via Paypal. Please email info if you are interested. ~| 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:358826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Does Not Contain Number
Use a regex. If refind(address, [0-9] You have a number Else No number My syntax may be off, but I think this is the logic you are looking for. Brian Cain Sent from my iPhone On Apr 20, 2014, at 3:41 PM, David Moore dgmoor...@hotmail.com wrote: Well, you are doing a great job. I guess I am not communicating well. I was using the 316 as an example. I want to check an address field passed from a form where the value is unknown. I just want to be able to check using Does Not Contain or IsNumeric or other Cold Fusion test in a cfif statement to determine if the passed string contains a number. Does that help? ~| 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:358370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cflocation mystery- solved
You should also be retiring a 301 status code to the client. This makes a difference for SEO purposes. In CF7 or before you would need to use the cfheader tag. CF8 and on, you can add the status code attribute to the cflocation tag. Sent from my iPhone On Feb 2, 2014, at 11:51 AM, Rob Voyle robvo...@voyle.com wrote: Thanks guys needed the absolute path in fileExist Rob ~| 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:357577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Noise words
Hello, I am working on a problem that is provide ample frustration. I have a keyword search on my site. For the most part this works fine. It is hitting a MSSQL 2012 server with FT Index setup. My routine for formatting the keywords and everything is in place and works well. The problem happens when the search condition contains noise words. Simplest example is a single letter like big b equipment. When I run the query in Management Studio, the results are returned, but I get the informational message: The full-text search condition contained noise word(s). The problem is that although it does not error when executing the query, ColdFusion seems to be determining that the informational message is the first result set, which is empty. Essentially any FT search phrase that has noise words does not work in CF. I am using the cfquery tag to get the results as stored proc is not possible in this scenario due to the possible complexity of the search. I can confirm through testing that this same behavior happens even when using a test stored procedure with the hard coded SQL statement, so the problem is definitely how CF is handling the returned result from the DB server. Has anyone had any experience with this issue and workarounds for it? ~| 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:357486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Noise words
I tried that, and it did not make a difference. I still get the informational message with option on or off. On Thu, Jan 23, 2014 at 12:29 PM, Dave Watts dwa...@figleaf.com wrote: I am working on a problem that is provide ample frustration. I have a keyword search on my site. For the most part this works fine. It is hitting a MSSQL 2012 server with FT Index setup. My routine for formatting the keywords and everything is in place and works well. The problem happens when the search condition contains noise words. Simplest example is a single letter like big b equipment. When I run the query in Management Studio, the results are returned, but I get the informational message: The full-text search condition contained noise word(s). The problem is that although it does not error when executing the query, ColdFusion seems to be determining that the informational message is the first result set, which is empty. Essentially any FT search phrase that has noise words does not work in CF. I am using the cfquery tag to get the results as stored proc is not possible in this scenario due to the possible complexity of the search. I can confirm through testing that this same behavior happens even when using a test stored procedure with the hard coded SQL statement, so the problem is definitely how CF is handling the returned result from the DB server. You can disable this functionality on SQL Server: http://technet.microsoft.com/en-us/library/ms187914.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Noise words
I wanted to try that, but one of the requirements requested by the sales team is to allow for single letters. that way when someone searches for something like j r simplot they will still get good matches. I think I will probably remove them like you say, and provide an alternative for searching by company name. Not elegant, but functional. On Thu, Jan 23, 2014 at 1:24 PM, Russ Michaels r...@michaels.me.uk wrote: I have had this issue before and simply removed the noise words from the search string first. On Thu, Jan 23, 2014 at 7:16 PM, Brian Cain bcc9...@gmail.com wrote: I tried that, and it did not make a difference. I still get the informational message with option on or off. On Thu, Jan 23, 2014 at 12:29 PM, Dave Watts dwa...@figleaf.com wrote: I am working on a problem that is provide ample frustration. I have a keyword search on my site. For the most part this works fine. It is hitting a MSSQL 2012 server with FT Index setup. My routine for formatting the keywords and everything is in place and works well. The problem happens when the search condition contains noise words. Simplest example is a single letter like big b equipment. When I run the query in Management Studio, the results are returned, but I get the informational message: The full-text search condition contained noise word(s). The problem is that although it does not error when executing the query, ColdFusion seems to be determining that the informational message is the first result set, which is empty. Essentially any FT search phrase that has noise words does not work in CF. I am using the cfquery tag to get the results as stored proc is not possible in this scenario due to the possible complexity of the search. I can confirm through testing that this same behavior happens even when using a test stored procedure with the hard coded SQL statement, so the problem is definitely how CF is handling the returned result from the DB server. You can disable this functionality on SQL Server: http://technet.microsoft.com/en-us/library/ms187914.aspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Noise words
When I call a proc with no noise words it works as expected. When I add the noise words back to the proc, save the cfstoredproc result to a variable and dump that I get cached=false and executiontime=395. There are no proc results returned with it. I even tried adding the cfprocresult tags to check for multiple result sets, and they are not defined when I attempt to dump them. I would have thought I would get a different error with the cfprocresult tag assigned the result sets that do not appear to exist, but i only get an error when I try to access the variables defined by the cfprocresult. On Thu, Jan 23, 2014 at 1:33 PM, Dave Watts dwa...@figleaf.com wrote: I tried that, and it did not make a difference. I still get the informational message with option on or off. What happens if you call it with CFSTOREDPROC, and specify two different recordsets? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFILE Question
Another alternative, if you are using CF 8 and above, is the content attribute of the cfmailparam tag. You can use this to attache the binary data itself as an attachment, that way you do not have to rely on a file existing on the server at the time the mail is sent. Read the file into a variable and then add it to the content attribute and delete the file. I am actually saving the file contents into the database, and then dropping the value of the database column directly into the cfmailparam tag. It has been working great, and no need for file clean up. Ben Nadel has a great blog about it. http://www.bennadel.com/blog/1220-ColdFusion-CFMailParam-s-New-Content-Attribute-Is-Awesome.htm Brian Cain On Wed, Oct 23, 2013 at 8:08 AM, Steve LaBadie slaba...@po-box.esu.eduwrote: I have a web-based form that requires the user to upload a document. Everything works fine until I try and delete the document after delivery. With the delete action enabled the email does not get delivered. I have place the action=delete inside and outside of the /cfmail cfif isDefined(form.attached) AND form.attached NEQ cffile action=upload destination=f:\inetpub\wwwroot\..\..\upload mode=644 nameConflict=overwrite fileField=form.attached cfset attachment=f:\inetpub\wwwroot\..\..\upload\#cffile.serverFile# /cfif cfprocessingdirective suppresswhitespace=no cfmail from=#..# to=#..# subject= type=html cfsilentcfif FORM.attached neq cfmailparam file=#attachment# //cfif/cfsilent /cfmail cfif isDefined(form.attached) AND form.attached NEQ cffile action=Delete file=#attachment# /cfif Steve LaBadie, Web Manager East Stroudsburg University 570-422-3999 slaba...@esu.edumailto:slaba...@esu.edu [facebook-16x16]http://www.facebook.com/eaststroudsburguniversity [twitter-16x16] http://twitter.com/esuniversity [youtube-16x16] http://www.youtube.com/user/esuedu ~| 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:356966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Syntax Problem
You should try putting your content into a variable using cfsavecontent and then choose to display in the browser or send an email. You cannot wrap the begin and end tags of a cfmail the way you are doing. cfsavecontent var=mycontentcfoutputYour stuff/cfoutput/cfsavecontent cfif generate_email cfmail all your settings#mycontent#/cfmail cfelse cfoutput#mycontent#/cfoutput /cfif Regards, Brian C On Thu, Oct 17, 2013 at 1:46 PM, Robert Harrison rob...@austin-williams.com wrote: In the statement below, what I missing? When generate_email=0, I get: Either the end tag /cfmail encountered on line 44 at column 29 requires a matching start tag or tag cfmail does not support end tag. cfif generate_email eq 1cfmail from=#techadmin# to= rob...@austin-williams.com bcc=#techadmin# Subject=Open House Registration Report server=#smtpid#/cfif cfoutputreport details go here/cfoutput cfif generate_email eq 1/cfmail/cfif I want to use this setting to either display this report or email the report. I don't understand why the switch is disabling the starting tag but not the closing tag. Thoughts? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:356930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Syntax Problem
The subject to your problem says it all. This is a syntax error. You cannot wrap the begin and end tags in a conditional statement. That breaks the syntax rules of the ColdFusion parsing engine and seems like a clunky solution anyway. You either want to mail the content or display it, so logically, your condition should have a true condition that mails, and a false condition the displays it. This is a commonly used technique, especially if you want to do both. It requires less code and is more readable as well. On Thu, Oct 17, 2013 at 1:58 PM, Robert Harrison rob...@austin-williams.com wrote: I thought of that but it seemed rather unnecessary. It seem like a hack to get around something that should work. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Thursday, October 17, 2013 2:58 PM To: cf-talk Subject: Re: Syntax Problem You should try putting your content into a variable using cfsavecontent and then choose to display in the browser or send an email. You cannot wrap the begin and end tags of a cfmail the way you are doing. cfsavecontent var=mycontentcfoutputYour stuff/cfoutput/cfsavecontent cfif generate_email cfmail all your settings#mycontent#/cfmail cfelse cfoutput#mycontent#/cfoutput /cfif Regards, Brian C On Thu, Oct 17, 2013 at 1:46 PM, Robert Harrison rob...@austin-williams.com wrote: In the statement below, what I missing? When generate_email=0, I get: Either the end tag /cfmail encountered on line 44 at column 29 requires a matching start tag or tag cfmail does not support end tag. cfif generate_email eq 1cfmail from=#techadmin# to= rob...@austin-williams.com bcc=#techadmin# Subject=Open House Registration Report server=#smtpid#/cfif cfoutputreport details go here/cfoutput cfif generate_email eq 1/cfmail/cfif I want to use this setting to either display this report or email the report. I don't understand why the switch is disabling the starting tag but not the closing tag. Thoughts? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austi ~| 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:356932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mobile
If you use a simple AJAX call back to the server that contains the width and height, you are not adding much overhead, and more importantly, you can then ask the user if they want the full or mobile site. I personally do not like it when I am redirected to the mobile site. Most mobile browsers can render the full desktop version just fine in today's world. Why not let the user decide what they want to see instead of forcing a particular version on them. Sent from my iPhone On Sep 27, 2013, at 10:26 PM, Dan G. Switzer, II dswit...@pengoworks.com wrote: While user agent can be spoofed (and pretty easily with most browsers), the reality is it's not a problem you need to worry about. You do generally want to try and avoid user agent when possible, but if your trying to detect the device purely on the server, there really isn't another option. Any kind of client side detection (such as screen width) will require and least a two trips to the server--once to serve up the client-side code that detects the device, then you hit the server again to change the layout. On Friday, September 27, 2013, John M Bliss wrote: I would suggest basing your redirect on screen width rather than user agent strings. This. This is why I ask questions like this one of this list. Answer so simple and yet so genius. Thank you! On Fri, Sep 27, 2013 at 5:50 PM, Brian Cain bcc9...@gmail.com wrote: I would suggest basing your redirect on screen width rather than user agent strings. Also the dev tools in Chrome has a neat little feature to allow you to specify a different user agent as well as screen size for testing on the desktop. Sent from my iPhone On Sep 27, 2013, at 4:13 PM, Dan G. Switzer, II dswit...@pengoworks.com wrote: John, I've looked into the following recently: - http://detectmobilebrowsers.com/ - In my testing, the code they give you works surprisingly well. It does not report tablets as mobile, which is the behavior I was looking for, but not be want you want. They basically give you some CFML and then you tweak the conditional statement for your needs. - WURFL (Java API) - Pretty easily to get up and running w/CF. The licensing is a bit weird, but you get very robust information back. Due to the fact you must load a 16MB XML config file, the initialization time is really slow, so you definitely want to cache your implementation so the init only happens once. - 51Degrees (Java API) - They offer a free version, but it lumps tablets in as a mobile device. You can upgrade to a paid version to differentiate tablets and phones. I like the API better than WURFL and initialization is much faster, but analyzing data is much slower. WURFL is darn quick. I've still be trying to find a good database of User Agents that breaks the strings down into desktop, tablet and phone so that I could run unit tests of the various implementations, but the DetectMobileBrowsers.com code has been as accurate as WURFL in my limited tests of a few dozen user agents. -Dan On Fri, Sep 27, 2013 at 2:26 PM, John M Bliss bliss.j...@gmail.com wrote: Agreed. Unfortunately, client has only approved hours to develop mobile version...not hours to redevelop / redesign existing site so that it's responsive. Basically, when mobile is detected, I'll be rendering a mobile-optimized skin around existing CFML CMS-driven center trough content. On Fri, Sep 27, 2013 at 2:21 PM, Che Vilnonis ch...@asitv.com wrote: You could also look to Responsive Web Design in lieu of creating a separate site. ~Ché -Original Message- From: Ron Gowen [mailto:rsgo...@gmail.com] Sent: Friday, September 27, 2013 2:21 PM To: cf-talk Subject: Re: Mobile i use this: (not sure im cool though) https://github.com/sebarmeli/JS-Redirection-Mobile-Site On Fri, Sep 27, 2013 at 11:16 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! I'm tasked with developing mobile browser-optimized version of existing site. What're the cool kids currently using for mobile Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm -- Dan G. Switzer, II dswit...@pengoworks.com http://blog.pengoworks.com/ ~| 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:356866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Mobile
I would suggest basing your redirect on screen width rather than user agent strings. Also the dev tools in Chrome has a neat little feature to allow you to specify a different user agent as well as screen size for testing on the desktop. Sent from my iPhone On Sep 27, 2013, at 4:13 PM, Dan G. Switzer, II dswit...@pengoworks.com wrote: John, I've looked into the following recently: - http://detectmobilebrowsers.com/ - In my testing, the code they give you works surprisingly well. It does not report tablets as mobile, which is the behavior I was looking for, but not be want you want. They basically give you some CFML and then you tweak the conditional statement for your needs. - WURFL (Java API) - Pretty easily to get up and running w/CF. The licensing is a bit weird, but you get very robust information back. Due to the fact you must load a 16MB XML config file, the initialization time is really slow, so you definitely want to cache your implementation so the init only happens once. - 51Degrees (Java API) - They offer a free version, but it lumps tablets in as a mobile device. You can upgrade to a paid version to differentiate tablets and phones. I like the API better than WURFL and initialization is much faster, but analyzing data is much slower. WURFL is darn quick. I've still be trying to find a good database of User Agents that breaks the strings down into desktop, tablet and phone so that I could run unit tests of the various implementations, but the DetectMobileBrowsers.com code has been as accurate as WURFL in my limited tests of a few dozen user agents. -Dan On Fri, Sep 27, 2013 at 2:26 PM, John M Bliss bliss.j...@gmail.com wrote: Agreed. Unfortunately, client has only approved hours to develop mobile version...not hours to redevelop / redesign existing site so that it's responsive. Basically, when mobile is detected, I'll be rendering a mobile-optimized skin around existing CFML CMS-driven center trough content. On Fri, Sep 27, 2013 at 2:21 PM, Che Vilnonis ch...@asitv.com wrote: You could also look to Responsive Web Design in lieu of creating a separate site. ~Ché -Original Message- From: Ron Gowen [mailto:rsgo...@gmail.com] Sent: Friday, September 27, 2013 2:21 PM To: cf-talk Subject: Re: Mobile i use this: (not sure im cool though) https://github.com/sebarmeli/JS-Redirection-Mobile-Site On Fri, Sep 27, 2013 at 11:16 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! I'm tasked with developing mobile browser-optimized version of existing site. What're the cool kids currently using for mobile browser-detection? This: http://www.cflib.org/udf/isMobileBrowser ...or something else? -- John Bliss - http://about.me/jbliss ~| 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:356862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best means of setting a library of reusable code
I have to agree with Matt. You are setting yourself up for a dependency
nightmare if your cfc functions do not encapsulate their logic.
On Tue, Jun 25, 2013 at 10:50 AM, Matt Quackenbush quackfu...@gmail.comwrote:
Hang on a minute. If I understand this correctly
So, how do I make the variables from application.cfc available to
contact.cfc under
such a scenario? Does the extends functionality of cfc's solve this?
... you're thinking about adding `extends=Application` to your
contact.cfc? If that's a correct understanding on my part, then the answer
is: HELL NO! DO NOT USE EXTENDS!
Your CFCs should be self-contained and any outside variables they need
should be passed in as either arguments or properties. Here's a contrived
example.
// foo.cfc
component
{
property name=datasourcename
function init( required string datasourcename )
{
variables.datasourcename = arguments.datasourcename
return this
}
function doQuery()
{
// your query goes here
return mycoolquery
}
}
// test.cfm
foo = createObject( 'component', 'foo' ).init( application.datasourcename )
writeDump( foo.doQuery )
HTH
On Tue, Jun 25, 2013 at 11:41 AM, Rick Faircloth
r...@whitestonemedia.comwrote:
Alright, that's the confirmation I needed to proceed. So, use 'extends
it
is!
Thanks,
Rick
On Tue, Jun 25, 2013 at 11:21 AM, Russ Michaels r...@michaels.me.uk
wrote:
if you use EXTENDS, then everything in the parent CFC is available tot
he
child.
If you want libraries to use on multiple sites, then you would need to
put
the components in a central location and then adding a mapping to them.
On Tue, Jun 25, 2013 at 4:01 PM, Rick Faircloth
r...@whitestonemedia.com
wrote:
Hi, all...
I've been writing code for every project I've worked on for the last
10+
years.
I did that purposefully to make myself work in a manner which would,
hopefully,
not cause me to rely on known practices because they were familiar
and
understood, but always strive to discover better ways of coding.
Now, however, I'm trying to combine reusing code I've already written
with
enhancing the reused code, instead of writing it from scratch each
time.
On my latest project I decided to take the dive and structure my code
of
HTML,
CF, jQuery, and CSS in away that allows me to create resource
libraries
that I can build upon and reference from within new projects.
I know *not* doing it this way sounds nuts to some of you. But,
again,
see
my
first paragraph. There was a method to the madness of this approach.
But, now I find myself (after days of trying to understand what I've
found
on the
Internet and in the CF docs to little avail) trying to get a working
method for this
approach.
I started first by putting my initial components for the project
*above*
the website's
root folder. I knew this was going to be problematic. I, of course,
immediately
got the error, component cannot be found.
Then, I read about cfincluding an application.cfc into an
application.cfm
in the
website root folder. For kicks and giggles, not a real solution,
because
this approach
is fundamentally flawed, I put an application.cfm in the site root
folder
and
used the relative path capability of cfinclude to pull in the
application.cfc above
the site web root and it's settings into the site's directory
structure.
Knowing that's
not a solution, I continued to dig on the Internet. Nothing has
clicked.
I
think there
are too many gaps in my understanding to make sense of everything I'm
reading.
So, I thought I'd just ask the brains that inhabit the world of
CF-Talk
and
ask
for a simple explanation of how to go about accessing cfc's above a
website
root,
that allows those cfc's access to the variables set up in
application.cfc
when it
resides inside the site root directory structure.
I'm trying to get this to work in the manner that I access virtually
every
cfc currently,
which is through AJAX functionality in jQuery. I can access a mapped
path
created
in application.cfc using AJAX in this manner:
url: location.protocol + '//' + location.host +
'/common/coldfusion/form-processing/contact.cfc?method=json'
However, the contact.cfc has to reference variables setup in the
application.cfc,
which exists inside the website root. Unless I place the
application.cfc
in
the same
folder as contact.cfc, it doesn't work.
So, how do I make the variables from application.cfc available to
contact.cfc under
such a scenario? Does the extends functionality of cfc's solve
this?
Is
that what
I need to understand and
Re: What would you call high traffic for CF8 standard?
I second the DB issue theory. I also run several job boards, and have found that most of my performance issues relate to the database. Sometime I can optimize the DB with the help of the profiler, other times I have simply reworked the code for better efficient. Use of nolock, small simple queries, and stored procedures make a huge difference. I am lucky in the I have Fusion Reactor and Idera's SQL monitoring services both installed. Makes finding bottle necks and doing optimization much easier. BTW, does your site support keyword searches using a full-text index. I know a cool little trick that improved keyword search performance about 5-10 fold on my sites. Brian Cain Sent from my iPhone On Jun 13, 2013, at 4:32 PM, Paul Vernon paul.ver...@web-architect.co.uk wrote: Yeah... again I would say you are getting all you can out of this setup. I'm not finding a lot to criticize :) -Mark Thanks. It just crashed again. Albeit the reliability is much improved over what it was by reducing the time for cleaning up connections and switching the memory allocations around as I've noted previously. This time though, the profiler was running through the crash. I've now got 20 million trace rows to trawl through to see if it really is a DB issue or not... Paul ~| 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:355934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMail alternative
I have had an ongoing problem with ColdFusion dropping some mail messages. The mail log show the messages being delivered to the mail server, but there is no record on the mail server. I found this thread on Adobe's website (http://forums.adobe.com/thread/585718), but there never seemed to be an actual resolution of the issue. I have tried contacting Adobe support, but that has led to nowhere. Most messages go out, but i need 100% reliability for this. Seeing as the problem is not with the CFMAIL tag, or my mail server (everything worked fine before we migrated to CF9 last year), I need an alternative that will completely bypass the CF engine all together. I was wondering if anyone had any 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:355267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMail alternative
Positive they are not there. On Thu, Apr 4, 2013 at 11:33 AM, wrote: but there is no record on the mail server Are you sure the mesages are not in the undelivered folder? I was having the same issue until I realized that my mail server had a limit of 1000 messages sent per hour. So after this limit was reached, messages were simply refused and stored by CF in the undelivered. Removing the limit solved the problem. ~| 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:355273 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: A little help with jquery/cfm
You should move your check into the WHERE clause of the query (WHERE orgname =
'#orgname#' or orglongname ='#orgname#') and change the listfindnocase
condition to checkname.recordcount GT 0. There is no need to return the entire
record set and then convert it to a list. Get rid is the orgnamelist variable
all together. That is a waste of resources.
To be on the safe side you should also use cfqueryparam to wrap the variables
in your SQL statement to prevent SQL injection attacks.
Brian Cain
On Feb 12, 2013, at 7:25 PM, Bruce Sorge sor...@gmail.com wrote:
Hey all,
I have an app that is running great. User enters a code into a form field,
and it checks the db to see if it's valid. If not they can't move on. Problem
is that now the customer wants to be able to enter either the 2-5 character
code OR the long name. For instance, you could enter AS or Adaptive Sports. I
am not sure how to add this functionality into this code below as I did not
write the query, I found it on-line and modified it for my site.
JQuery:
script src=js/jquery.js type=text/javascript/script
script type=text/javascript
pic1 = new Image(16, 16);
pic1.src = images/loader.gif;
$(document).ready(function(){
$(#orgname).change(function() {
var usr = $(#orgname).val();
if(usr.length = 2)
{
$(#status).html('img align=absmiddle src=images/loader.gif / Checking
Code...');
$.ajax({
type: POST,
url: checkcode.cfm,
data: orgname=+ usr,
success: function(msg){
$(#status).ajaxComplete(function(event, request, settings){
if(msg == 'OK')
{
$(#orgname).removeClass('object_error'); // if necessary
$(#orgname).addClass(object_ok);
$(this).html(' img align=absmiddle src=images/accepted.png / ');
}
else
{
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
$(this).html(msg);
}});}});}
else
{
$(#status).html('The Code should have at least 2 characters.');
$(#orgname).removeClass('object_ok'); // if necessary
$(#orgname).addClass(object_error);
}});});
//--
/script
Here is the check code.cfm page:
cfsetting showdebugoutput=false
!--- Set the orgname to blank first ---
cfparam name=orgname default=
!--- Query the organizations table for all of the org names ---
cfquery name=checkName datasource=#request.dataSource#
SELECT orgname, orglongname
FROM organizations
/cfquery
!--- put the names into a list ---
cfset orgnamelist = valueList(checkname.orgname, ,)
!--- Check the list against the name entered. If there is a match, then code
is valid, otherwise conde is invalid ---
cfif listFindNoCase(orgnamelist, orgname)
cfset available = 'span style=color: Green;Code is valid./span'
cfelse
cfset available = 'span style=color: red;The Code b #orgname#/b is
an invalid code. br /Please re-enter your code./span'
/cfif
cfoutput#available#/cfoutput
Hopefully someone can help. The client put out a huge email blast today and
then as an afterthought wanted the added functionality since someone already
tried to enter the long name rather than the code as instructed.
Thanks,
Bruce
~|
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:354489
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: A little help with jquery/cfm
Yes. You are checking on checkcode.cfm. That is the page that needs to be modified. Brian Cain On Feb 12, 2013, at 7:47 PM, Bruce Sorge sor...@gmail.com wrote: The think is that the check is not done when they post, it's done when they enter the code, then shift the focus form the form field. Bruce On Feb 12, 2013, at 8:42 PM, Brian Cain bcc9...@gmail.com wrote: You should move your check into the WHERE clause of the query (WHERE orgname = '#orgname#' or orglongname ='#orgname#') and change the listfindnocase condition to checkname.recordcount GT 0. There is no need to return the entire record set and then convert it to a list. Get rid is the orgnamelist variable all together. That is a waste of resources. To be on the safe side you should also use cfqueryparam to wrap the variables in your SQL statement to prevent SQL injection attacks. Brian Cain ~| 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:354491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Security Issue with CF
Don't get me wrong, I detest hackers and their exploits, but i think the way this one works quite ingenious. My server did get hit, but after reviewing the log files and checking for changes, I don't think they did anything. I am thankful for that, cause they could have done some major damage. We migrated to a virtual environment and from CF7 to CF9 a few months ago. Ironically, we were protected under CF7, but I neglected to fully lock down the server after we migrated. Live an learn. I am surprised there has not been more activity on this considering the severity of the possible compromise. On Fri, Jan 4, 2013 at 12:55 PM, Money Pit websitema...@gmail.com wrote: Things must be bad if they are issuing something that ominous-sounding without a solution. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:353770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: New Security Issue with CF
I agree. It is the insertion method I am intrigued by. It is that type of non linear thinking that we as developers use to create elegant solutions. The tool is ugly, and not that special, but the insertion method is clever. What I don't understand is why adobe would allow something like the scheduler to be called without authentication. Seems like a glaring oversight to me. Brian Cain On Jan 4, 2013, at 5:16 PM, Justin Scott leviat...@darktech.org wrote: The file itself is some tool designed to be used by developers, probably not developed by rhe hacker himself. He just found a way to store it on servers. I've seen this tool make the rounds before through other attack vectors. It's been around since at least ColdFusion MX 6. The undocumented servicefactory it's calling to get datasources only works on CF 6 but was deprecated in 7, if I remember correctly, which is why the datasource list is blank on more modern versions where this is dropped in. The script is old, but the insertion method is new. -Justin ~| 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:353782 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFMAIL Not getting to mail server
Hello All, I recently migrated to CF 9 from 7, and there seems to be an issue with not all cfmail messages going out. I an not getting any errors, and the log files in CF actually show the messages in the mail sent log, but there is no trace of them after that on my mail server or the client end. This problem did not start happening until after I migrated to CF9, and there have been no changes in the code or environment beyond that. This does not happen to all messages, but it happens often enough that is a problem. Does anyone have any ideas of how to fix this issues. I found some threads about this issue and other people experiencing it, but no solutions or help from Adobe on a permanent fix. Thanks, Brian Cain ~| 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:353304 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Query with no results is not defined
Hello, I have migrating from CF7 to CF9, and have found a strange problem. It seems when I try to reference a query that has no results, CF thinks that object does not exist but this behavior is not consistent. I have full debugging turned on for my local machine, and I can even see the query listed in the SQL Queries section. I cannot figure out for the life of me why certain queries, when empty, cannot be referenced for properties like RecordCount. As a temporary workaround I am using IsDefined to see if the object exists instead of .RecordCount to see if it is populated. I have verified that if the query does return data that is works as normal. and it does. Has anyone encountered this behavior, or have any idea why this is occurring? Thanks, Brian Cain ~| 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:352270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query with no results is not defined
It is not in a CFC CFQUERY name=PastDueInvoices datasource=#appdatasource# SELECT r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved, Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) as AmountDue FROM Receipts r LEFT JOIN LineItems li ON li.ReceiptID = r.ID WHERE r.SubscriberID = #session.stUser.ID# AND r.Approved = 1 AND r.DatePaid is null AND IsNull(r.HideMyAccount, 0) 1 GROUP By r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved HAVING Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) 0 ORDER BY r.Approved DESC, r.InvoiceDate DESC /CFQUERY cfif IsDefined(PastDueInvoices) CFIF PastDueInvoices.RecordCount GT 0 IT ERRORS RIGHT HERE! This is copied and pasted directly form the cfm page. The condition to look and the record count attribute was literally the next line of code before I added the IsDefined check. On Wed, Aug 22, 2012 at 4:46 PM, Cameron Childress camer...@gmail.comwrote: On Wed, Aug 22, 2012 at 5:38 PM, Brian Cain bcc9...@gmail.com wrote: Has anyone encountered this behavior, or have any idea why this is occurring? Is it in a CFC? Smells like an improperly scoped query. Show some code? -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:352272 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Query with no results is not defined
I tried that and it still does not exist. On Wed, Aug 22, 2012 at 4:57 PM, Alan Rother alan.rot...@gmail.com wrote: Try explicitly scoping the variable As in variables.PastDueInvoices - first its just good form, second it does make the app run faster, as when you don't provide the explicit scope, CF has to check through a number of scopes for it. It could also explain the issue - if for example anywhere else in your app you are using that var name in say, Application, Server, Request or Session scope. On Wed, Aug 22, 2012 at 2:51 PM, Brian Cain bcc9...@gmail.com wrote: It is not in a CFC CFQUERY name=PastDueInvoices datasource=#appdatasource# SELECT r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved, Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) as AmountDue FROM Receipts r LEFT JOIN LineItems li ON li.ReceiptID = r.ID WHERE r.SubscriberID = #session.stUser.ID# AND r.Approved = 1 AND r.DatePaid is null AND IsNull(r.HideMyAccount, 0) 1 GROUP By r.ID, r.InvoiceDate, r.DueByDate, r.DatePaid, r.Approved HAVING Sum(li.Quantity*li.Cost) - Sum(li.Quantity*li.Discount) 0 ORDER BY r.Approved DESC, r.InvoiceDate DESC /CFQUERY cfif IsDefined(PastDueInvoices) CFIF PastDueInvoices.RecordCount GT 0 IT ERRORS RIGHT HERE! This is copied and pasted directly form the cfm page. The condition to look and the record count attribute was literally the next line of code before I added the IsDefined check. On Wed, Aug 22, 2012 at 4:46 PM, Cameron Childress camer...@gmail.com wrote: On Wed, Aug 22, 2012 at 5:38 PM, Brian Cain bcc9...@gmail.com wrote: Has anyone encountered this behavior, or have any idea why this is occurring? Is it in a CFC? Smells like an improperly scoped query. Show some code? -Cameron -- Cameron Childress -- p: 678.637.5072 im: cameroncf facebook http://www.facebook.com/cameroncf | twitterhttp://twitter.com/cameronc | google+ https://profiles.google.com/u/0/117829379451708140985 ~| 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:352274 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinclude issues
Not to state the obvious, but you are trying to include it from a .cfm page right? You cannot use a cfinclude on a .htm page. On Fri, Mar 2, 2012 at 2:16 PM, wrote: Aren't they all also relative to the original including templates path though even though they're nested? I would say yes. Better do this in the same directory. Any way, I do not relly see a good occasion for using recursive includes, because they will all work on the same variable scope. I sometimes use recursive custom tags though. ~| 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:350207 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinclude issues
Yes Andrew, that was the point I was making. On Fri, Mar 2, 2012 at 2:56 PM, Andrew Scott andr...@andyscott.id.auwrote: Actually you can't being an html file, it will never be run by ColdFusion, and will only be seen as a standard html comment. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sat, Mar 3, 2012 at 7:53 AM, wrote: You cannot use a cfinclude on a .htm page Well, actually you can, ... but it will include nothing ;-) ~| 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:350210 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFinclude issues
Andrew: You must have meant that for the other guy. My original reply said you cannot use cfinclude in a .htm file. I will add the addendum that being the case in a traditional server configuration. Brian Cain On Mar 2, 2012, at 4:06 PM, Andrew Scott andr...@andyscott.id.au wrote: Well the point was lost, because saying you can, implies that it can be called or used by ColdFusion. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sat, Mar 3, 2012 at 8:00 AM, Brian Cain bcc9...@gmail.com wrote: Yes Andrew, that was the point I was making. On Fri, Mar 2, 2012 at 2:56 PM, Andrew Scott andr...@andyscott.id.au wrote: Actually you can't being an html file, it will never be run by ColdFusion, and will only be seen as a standard html comment. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sat, Mar 3, 2012 at 7:53 AM, wrote: You cannot use a cfinclude on a .htm page Well, actually you can, ... but it will include nothing ;-) ~| 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:350218 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SEO Redirection
Hello group, I am working with an SEO person on making some refinements to our sites. We get over 1.5 million pages views/mo. My SEO guy noticed that there were several valid ways to access a detail or results listing page through similar combinations of the URL. Some had upper case instances, some were all lower case, and others had a trailing bit on the end to make it look like a static page. This created up to 4 combinations of URL that all displayed the exact same set of data, not to mention the fact of the www vs. non www issue. I implemented a canonical redirect to make sure all pages went to the properly formatted (all lower case with static page append at the end) URL using a permanently moved redirection header in CF. This all seems to be working correctly, but I have noticed that the site performance is suffering, and some of the requests that should be redirected take longer than the should to actually redirect. I am using FR to monitor the requests, and this is why I know that some of them seem to be taking to long. In theory, they should only take a few milliseconds to redirect, unless I am missing something. Each cf based redirect is followed by a cfexit tag, so the request should end right there with the message to the browser. All of the redirect logic is in a single page. I have included a sample code snippet below. cfif Session.EmploymentPartner.ID LT 1 and (LCase(LEFT(CGI.SERVER_NAME, 3)) NEQ www AND LCase(LEFT(CGI.SERVER_NAME, 4)) NEQ beta AND LCase(Left(CGI.SERVER_NAME, 3)) NEQ dev) cfset thePage=#CGI.SCRIPT_NAME# cfif thePage CONTAINS index.cfm cfset thePage=thePage #lcase(CGI.PATH_INFO)# /cfif cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://#subDomain#.#appdatasource#.com#thePage#; cfexit /cfif Any ideas on how to better optimize this solution for global implementation, or whta may be causing the performance lag. Thanks, Brian Cain ~| 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:349805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SEO Redirection
Good point on that. Thanks for the suggestion.
Sent from my iPad
On Feb 7, 2012, at 4:41 PM, Bobby Hartsfield bo...@acoderslife.com wrote:
I think all of those lcase() and LEFT() calls are unnecessary as well.
lists aren't known for their performance but in this case, I'd think this
would perform a little better. You would have to compare to see. In either
case, I think your use of lcase() is arbitrary.
cfif Session.EmploymentPartner.ID LT 1 and !listfindnocase('www,beta,dev',
listfirst(cgi.server_name), '.')
.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Tuesday, February 07, 2012 5:26 PM
To: cf-talk
Subject: Re: SEO Redirection
cfheader statuscode=301 statustext=Moved permanently
cfheader name=Location
value=http://#subDomain#.#appdatasource#.com#thePage#;
cfexit
You could replace these three lines with a single CFLOCATION tag. I'm
not sure if that's what's causing your performance problems, but
there's really no reason to do this the way you're doing it.
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,
~|
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:349810
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Maximum Request Setting CF6
Greetings, I have a legacy site running CF6.1 Enterprise. I have noticed that it will only process 8 requests at one time and will que the others. Does anyone know where I might be able to change this in CF6? I cannot find a setting for it. ~| 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:348522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Check for list of words in string
Hello all, I would like to check a string against a list of keywords and either null the string or replace the keywords if found. Over the past couple of weeks someone has been probing my sites for SQL injection vulnerabilities. I have used queryparams and other types of validation. but I fear I may have missed something. I am using an old version of formurl2attributes that has been modified over the years. My thought is to check the attributes list at the end of the custom tag, and look for some of the common SQL injection keywords there and mitigate their effectiveness. So in short, how do I search for keywords like select,declare in a string without looping over the keywords? Thanks, Brian Cain ~| 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:348047 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check for list of words in string
For my specific implementation, I decided to use a combination approach.
Remembering this is an attempt to mitigate SQL injection exploits, I check
for select or declare in the query string. I realized forms posed a
slightly different problem, as I have many user posting long text data the
often contains some form of those words. For the forms I check for an
instance of both select and declare and send an email alert to myself with
the pertinent data. I can control this at the granular level as the values
are assigned to an attributes structure I use for processing, letting me
replace the values or further analyze possible exploit attempts.
I did end up using the regex for the query strings, but as always, no one
solution is the perfect fit.
Thanks,
Brian Cain
On Tue, Oct 11, 2011 at 12:52 PM, Brook Davies cft...@logiforms.com wrote:
Wouldn't this also catch words like 'myselection'?
Brook
-Original Message-
From: Matt Quackenbush [mailto:quackfu...@gmail.com]
Sent: October-11-11 7:16 AM
To: cf-talk
Subject: Re: Check for list of words in string
Regular expressions.
if ( reFindNoCase((select|declare),myString) 0 ) {
// at least one of the words is present }
HTH
On Tue, Oct 11, 2011 at 9:11 AM, Brian Cain bcc9...@gmail.com wrote:
Hello all,
I would like to check a string against a list of keywords and either
null the string or replace the keywords if found.
Over the past couple of weeks someone has been probing my sites for
SQL injection vulnerabilities. I have used queryparams and other
types of validation. but I fear I may have missed something. I am
using an old version of formurl2attributes that has been modified over
the years. My thought is to check the attributes list at the end of
the custom tag, and look for some of the common SQL injection keywords
there and mitigate their effectiveness.
So in short, how do I search for keywords like select,declare in a
string without looping over the keywords?
Thanks,
Brian Cain
~|
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:348054
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Email Labs Mailing List API
Does anyone have experience setting up an API call to the EMailLabs API? It accepts SOAP requests, but I am looking for a little jump start. Thanks, Brian Cain ~| 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:346863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
I know that it works within excel. Not sure if there is something else going on when creating a spreadsheet. I imported a tab delimited file that used the single quote preceding the zeros, and excel did not treat it the same way as when you use a single quote using excel directly. Sorry that didn't work. BTW, Steven has the right string format for the CF syntax. BC On Wed, Aug 17, 2011 at 11:46 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Shouldn't that be cfset col1 = '#query1.col1# The ' has to be outside of the # signs. -Original Message- From: funand learning [mailto:funandlrnn...@gmail.com] Sent: Wednesday, August 17, 2011 11:26 AM To: cf-talk Subject: Re: coldfusion spreadsheet leading zeroes issue I tried using a single quote within coldfusion before sending it to excel. Excel still displays the quote. This is what I am doing cfset col1 = #'query1.col1# ~| 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:346814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
You could also try using a single quote as your leading character. This is how would would enter it in excel without changing the column formatting. BC On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies cft...@logiforms.com wrote: This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l 0l0l0l0l0l0l0l0ll0l0 Brook -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: August-16-11 10:35 AM To: cf-talk Subject: coldfusion spreadsheet leading zeroes issue Hi All - I am facing an issue with coldfusion9 spreadsheet functions. It cuts of leading zeroes. This is what I am trying. I am getting array of data and using spreadsheetaddrows. When I am constructing an array, am using quotes so as to preserve the zeroes but with no effect. Adding some characters like ~ helps. But when I am adding space, coldfusion is not preserving the spaces. Is there a better way to handle this issue? 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:346791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion spreadsheet leading zeroes issue
The single quote does not appear. It is a special formatting rule for excel. It makes the column display as a character field by default. It is used specifically to handle leading zeros. Brian Cain On Tue, Aug 16, 2011 at 3:22 PM, funand learning funandlrnn...@gmail.comwrote: If I use a single quote as leading character, then thta single quote would appear in excel sheet right? At what point should I remove the quote? Can anything be done on database side. I mean can the query be formatted in any way? On Tue, Aug 16, 2011 at 2:41 PM, Brian Cain bcc9...@gmail.com wrote: You could also try using a single quote as your leading character. This is how would would enter it in excel without changing the column formatting. BC On Tue, Aug 16, 2011 at 12:56 PM, Brook Davies cft...@logiforms.com wrote: This is an excel issue, not a CF issue. If you set the data type of the column to text it does not happen.. http://www.google.ca/search?hl=enclient=firefox-ahs=vpOrls=org.mozilla%3A en-GB%3Aofficialbiw=1920bih=1084q=excel+truncates+leading+zerobtnG=Searc hoq=excel+truncates+leading+zeroaq=faqi=aql=gs_sm=sgs_upl=0l0l0l18408l 0l0l0l0l0l0l0l0ll0l0 Brook -Original Message- From: fun and learning [mailto:funandlrnn...@gmail.com] Sent: August-16-11 10:35 AM To: cf-talk Subject: coldfusion spreadsheet leading zeroes issue Hi All - I am facing an issue with coldfusion9 spreadsheet functions. It cuts of leading zeroes. This is what I am trying. I am getting array of data and using spreadsheetaddrows. When I am constructing an array, am using quotes so as to preserve the zeroes but with no effect. Adding some characters like ~ helps. But when I am adding space, coldfusion is not preserving the spaces. Is there a better way to handle this issue? 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:346803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
QoQ in Railo
Hello all, I am attempting to migrate an exiting CF site from a server running CFMX7 to Railo. For the most part things are working well, but I have run into 2 problems. The first problem is when attempting to do a query of a query. I get a variable [revenuehistory] doesn't exist error. CFQUERY name=RevenueHistory datasource=#appdatasource# SELECT A BUNCH OF STUFF FROM MULTIPLE DATABASES AND JOIN ALL TOGETHER USING A BUNCH OF UNIONS FOR FURTHER PROCESSING IN CF /CFQUERY CFQUERY dbtype=query name=GetYears SELECT DISTINCT PYear FROM RevenueHistory ORDER BY PYear DESC /CFQUERY This is where the error comes. This works just fine in CFMX7. I was wondering of anyone has heard of any problems with this type of thing. I also am having trouble with links that use / in the query string to pass variables used with a very old version of Fusebox's formAttributes2URL custom tag. http://local.careerspecific.com/jobs.cfm/SiteID/1/CatID/881/Engineering_Jobs.htm A link like the one above gives me a 404 error. Any ideas? Thanks, Brian Cain ~| 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:345598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: QoQ in Railo
Thanks, I will try there too. On Thu, Jun 23, 2011 at 12:16 PM, Che Vilnonis ch...@asitv.com wrote: Have you tried the Railo Group? It's worked for me in the past. http://groups.google.com/group/railo?lnk=srg ~Che -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Thursday, June 23, 2011 1:13 PM To: cf-talk Subject: QoQ in Railo Hello all, I am attempting to migrate an exiting CF site from a server running CFMX7 to Railo. For the most part things are working well, but I have run into 2 problems. The first problem is when attempting to do a query of a query. I get a variable [revenuehistory] doesn't exist error. CFQUERY name=RevenueHistory datasource=#appdatasource# SELECT A BUNCH OF STUFF FROM MULTIPLE DATABASES AND JOIN ALL TOGETHER USING A BUNCH OF UNIONS FOR FURTHER PROCESSING IN CF /CFQUERY CFQUERY dbtype=query name=GetYears SELECT DISTINCT PYear FROM RevenueHistory ORDER BY PYear DESC /CFQUERY This is where the error comes. This works just fine in CFMX7. I was wondering of anyone has heard of any problems with this type of thing. I also am having trouble with links that use / in the query string to pass variables used with a very old version of Fusebox's formAttributes2URL custom tag. http://local.careerspecific.com/jobs.cfm/SiteID/1/CatID/881/Engineering_Jobs .htm A link like the one above gives me a 404 error. Any ideas? Thanks, Brian Cain ~| 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:345600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Shameful
I think this thread just took on a new life. On Thu, May 26, 2011 at 11:57 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Double tap to the chest and one to the head ensures a bullet-proof vest doesn't come back to haunt you. :P (That's my video game experience talking!) -Original Message- From: Mark Drew [mailto:mark.d...@gmail.com] Sent: Thursday, May 26, 2011 12:52 PM To: cf-talk Subject: Re: (ot) Shameful I meant for close quarters assassination, like the Mafia. Of course, this could be my TV knowledge speaking... because everything on TV is true. MD ~| 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:344932 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Shameful
ROFL!!! Sent from my iPad On May 26, 2011, at 3:55 PM, John M Bliss bliss.j...@gmail.com wrote: cfdoubletap centermass=true / On Thu, May 26, 2011 at 3:54 PM, Dave Watts dwa...@figleaf.com wrote: I know about ColdFusion, and I know about firearms, purely through the accident of having worked with both occasionally. Not at the same time I hope ;-) I've been tempted occasionally. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: down?
For split second yes. I freaked a little, and no I haven't been able to get to the HOF website all day. On Wed, May 25, 2011 at 2:46 PM, Paul Giesenhagen p...@quilldesign.comwrote: + 1 -Original Message- From: Jason Durham [mailto:jqdur...@gmail.com] Sent: Wednesday, May 25, 2011 2:34 PM To: cf-talk Subject: Re: down? How many people just freaked out because they thought one of *their own* websites were down? Jason Durham On Wed, May 25, 2011 at 2:27 PM, Michael Muller mich...@mullertech.com wrote: Is the website down? MM Michael Muller cell (413) 320-5336 http://MontagueWebWorks.com ** Powered by ROCKETFUSION ** Information is not knowledge Knowledge is not wisdom Eschew Obfuscation ~| 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:344895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Including a variable within a database response
Easiest way is to use the Replace function built in to CF. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_m-r_32.html http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_m-r_32.htmlIf you have multiple instances of the replacement value be sure to specify the All scope. You may also want to look at the ReplaceNoCase function. Brian Cain On Fri, Apr 1, 2011 at 10:22 AM, Scott Williams myscottwilli...@yahoo.comwrote: Hi all -- I have a script that draws some text from a database, and I would like to embed a person's name within the text. For example, the database field contains this text: Hi #name#. How's it going? I would like the #name# to be replaced with a previously defined variable name. Can ColdFusion do this? If so, how? Scott ~| 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:343464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Output the value of dymanic session vars
Try using cfset var=evaluate(HUMANRESEARCH_SB_MODULE#moduleID#_GROUP#groups.GroupID# = #session.institutionRegister.HUMANRESEARCH_SB_MODULE#moduleID#_groups.GroupID#) cfoutput#var#/cfoutput On Fri, Mar 25, 2011 at 9:21 AM, Torrent Girl moniqueb...@gmail.com wrote: I dynamically created a series session vars EXAMPLE: HUMANRESEARCH_SB_MODULE10_GROUP1 Now I need to output the value along with the sesssion variable name: EX: cfoutputHUMANRESEARCH_SB_MODULE#moduleID#_GROUP#groups.GroupID# = #session.institutionRegister.HUMANRESEARCH_SB_MODULE#moduleID#_groups.GroupID#/cfoutput I get an error on the above. How do I accomplish this? 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:343267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Data Truncation on TEXT field
Check the advanced settings on the datasource in the CF Adminstrator. Make sure CLOB (Enable long text retrival) is checked , and increase the long text buffer to handle the larger data field size. ~| 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:342996 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Undelivr not working as expected
If it is a valid formatted email address CF will send to the mail server regardless. I believe CF will only move something to undeliverable if it cannot connect to the mail server or if the email address in not in a valid format. Brian ~| 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:343006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Serving Content based on Geolocation of IP address
I use a product called ip2location. They have a dll that will return a country code based on ip. Usually work pretty well. It cost around $100/yr. I have mine setup as a com object under windows. Seems to be pretty low overhead. Sent from my iPhone On Mar 10, 2011, at 10:40 AM, Michael Grant mgr...@modus.bz wrote: One of our multi-national clients wants content specific to the location of the end user. Pretty straightforward stuff, but something we haven't done before. Does anyone have any recommendations of products or services they've had good experiences with? ~| 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:342896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
Are you doing the update via a SQL statement or stored proc? On Fri, Mar 4, 2011 at 11:01 AM, Scott Williams myscottwilli...@yahoo.comwrote: Hello all -- I have a form that contains checkboxes which sends multiple record numbers to an action form for processing. For example, it would send: formfield1=ABC formfield2=1,2,3,4,5,6,7 In the database I want to update the formfield1 column to ABC wherever the formfield2 column value is either 1 or 2 or 3 or 4 or 5 or 6 or 7. I've tried a few different ways to do this, but only one record gets updated. Any tips on how I can accomplish this? Scott ~| 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:342753 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Check boxes
That is exactly what I was going to suggest. Good job. ~| 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:342755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I'm confused/stumped - cant figure this out
Why are you using hidden text fields at all? You can put the amount in the options value attribute. ~| 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:342716 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) People using your shop cart to test credit cards.
This may or may not help you, but we do not process new transactions from strangers. We run a SaaS site, and when a new customer signs up for our site, we store the information encrypted in the database, but do not process the transaction. Our sales staff is immediately alerted via email that a new account needs to be verified. We contact the customer directly, or in some cases approve the transaction based on previous contact history. We have a very strong customer service aspect in our sales business model, and using the system of verification have reduced our fraud rate to near zero. Brian Cain ~| 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:342594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE8 Form Submit button not being passed
You could probably avoid a lot of code rewrites by changing from an image button to using styles and a background image. That is what I do and have been able to avoid that issue. Sent from my iPhoned On Feb 23, 2011, at 7:43 AM, Phillip Duba phild...@gmail.com wrote: Unfortunately John, no you aren't doing anything wrong in your base code that worked in IE6. I had to rewrite a number of applications for this very reason as our design team decided Image buttons were what we were going to use and I saw this behavior in newer browsers. Unlike other browsers that post both the .X, .Y and main variable, IE8 (and IE7, I think) don't. Yes, you will need to take this into account on all your applications, Phil On Wed, Feb 23, 2011 at 8:27 AM, John Pullam jpul...@mcleansystems.comwrote: I am testing my application on an IE8 system running Win 7 and CF 9. I do not know if any of these are relevant but the problem does not occur on Firefox or Chrome. Essentially, IE is not passing the FORM.Submit to my post-back form processor. It passes everything else, including Submit.X and Y!! My form is as follows: cfform table trtd width=100bFirst Name/b/td td width=500cfinput name=FirstName type=text required=No Size=20 //td/tr trtdbLast Name/b/td tdcfinput name=LastName type=text required=No Size=20 //td/tr /table input type=hidden name=Submit2 value=any pcfinput name=Submit type=image value=Submit src=../Buttons/MSearch.png //p /cfform When I get the postback on IE8, I use a cfdump to see what I got, and the FIELDNAMES for the form are: FIRSTNAME,LASTNAME,SUBMIT2,SUBMIT.X,SUBMIT.Y but not SUBMIT!!! As I use this technique in other applications to capture a post-back, I'm rather concerned. Am I doing something wrong? ~| 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:342512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to many sites, one codebase (MSOC)
I wrote a custom desktop application in VB to update all my databases at one time. Using SQL scripting this can be easily managed. When I am ready to roll out a change that requires a DB update, I can do it in real time, with minimal service interruption, and without taking the sites offline. It has not failed me yet, and I have been doing it that way for over 6 years. ~| 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:342535 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to many sites, one codebase (MSOC)
Granted most of my changes are minor like updating a stored procedure or view or adding a column. I also run them on a test database first. Updates that may have a major impact on a table with millions of records, would never be done while the sites are up, but regular minor changes and fixes by nature do not have as wide an impact as major updates and fixes. If you are making major changes you would definitely need to to some testing and have a well planned implementation strategy. ~| 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:342537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SELECT - Option selected
I couldn't agree more. I abandoned CFFORM years ago. Sent from my iPhone On Feb 17, 2011, at 6:05 AM, Michael Grant mgr...@modus.bz wrote: In my experience CFForm is more trouble than it's worth. I generally just use regular forms + jquery to get elegant client-side validation. Much more lightweight and gives much more granular control over your form. On Thu, Feb 17, 2011 at 5:27 AM, Torrent Girl moniqueb...@gmail.com wrote: The solution was not to use CFFORM at all. it now works. I have a simple one: cfselect name=endampm required=yes message=Please select an AM/PM for the end time id=endampm option value=/option option value=AM cfif schedule.endampm EQ AMselected=selected /cfifAM/option option value=PM cfif schedule.endampm EQ PMselected=selected /cfifPM/option /cfselect depends on cfselect... in simple cfselect - one based on an in-page query, for example - you can provide a value in the 'selected' attribute and an option with that value will be pre-selected. advanced cfselect - one with a binding - does not support this functionality. but there are javascript work-arounds for that: google 'cfselect binding selected' and you will find them Azadi On 16/02/2011 21:34 , Torrent Girl wrote: ~| 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:342374 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to many sites, one codebase (MSOC)
I have built two applications under this method, and you are using many of the same ideas. Mine have been up and running for years with no major issues. In regard to the domain name issue mentioned by Russ, a simple workaround for this is to use a bit of string parsing. You can parse out the domain, and drop the sub domain into a separate variable to be used for additional processing or styling. For example, take the following theoretical URLs mydomain.com, www.mydomain.com, and blogs.mydomain.com. Using string parsing you can always be assured the mydomain.com will always be your primary reference point to setup DSN and any other site specific variables that need to be set. You can then drop the sub domain blogs into another variable that would allow you to modify settings for the primary domain such as template or navigation links. BTW, I am using IIS with virtual directories to include my code base. What setup are you using? Good luck, Brian Cain ~| 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:342393 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SELECT - Option selected
If you are talking the HTML select element it is selected=selected Sent from my iPhone On Feb 15, 2011, at 4:47 PM, Torrent Girl moniqueb...@gmail.com wrote: this is an old post but I am pulling my hair out as well. Does anyone know the answer to the select=true, select=selected problem? It is not working in IE or FF for me. 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:342311 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL selecting distinct items by date?
Sorry I am a little late in the reply on this one, but did you try using the MAX function. SELECT DISTINCT TOP 5 pivot.CategoryID, Category.Name, MAX(Item.DateAdded) FROM Category INNER JOIN pivot ON Category.CategoryID = pivot.CategoryID INNER JOIN Item ON pivot.ItemID = Item.ItemID GROUP BY pivot.CategoryID, Category.Name ORDER BY MAX(Item.DateAdded) DESC ~| 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:342200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion errors
Error handling is for run time errors. Your second example is a compile error. You cannot use error handling to fix this. You could try a site wide error handler, but that probably won't work either. Brian Cain Sent from my iPhone On Feb 8, 2011, at 7:30 PM, Richard Steele r...@photoeye.com wrote: Is there anyway to catch coldfusion programming errors? cfoutput#999sdflkjsdf;lk#/cfoutput is caught by my error handler. But cfoutput#alsdk;fjlkj#/cfoutpu is not. 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:342027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Charge for meetings
I follow the same basic rule. No charge on the initial consult, but hourly after that. It helps force the client to prepare and think through why they really want. Sent from my iPhone On Feb 5, 2011, at 4:19 PM, Phillip Vector vec...@mostdeadlygame.com wrote: I charge per hour. If you want to have a meeting for that time, I charge for it. Talk away. :) Now, the initial meeting, I tend not to charge for. But those I like to keep short and focused. On Sat, Feb 5, 2011 at 2:05 PM, Paul Alkema paulalkemadesi...@gmail.com wrote: Hi All, I have a question; when you guys do consulting or freelance programming, do you charge for meetings? Or do you absorb meeting time into your fees? Thanks, Paul ~| 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:341879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Subtracting two dates
Use the DateDiff function. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions_c-d_28.html ~| 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:341646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PlainText email
Thanks for that info. That makes a lot of sense now that I think about it in regard to the comparison between the HTML and text portions. The SPAM score I am seeing is -2.6 according to Port25's authentication verifier service. That is for Spam Assassin. I has checked on some other messages, and I was getting scores above 5.0 so I was worried. Brian Cain ~| 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:341521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PlainText email
I have valid SPF records and have verified those are working. I have domain keys setup on a different mail server I manage, and am considering setting them up on the one that sends out our notification messages. I have been putting it off because I would have to upgrade to the latest version of the mail server software (Surgemail). Thanks, Brian Cain ~| 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:341523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PlainText email
There is one coming your way from i...@careersinfood.com Thanks, Brian Cain ~| 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:341533 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would I do this in SQL?
Sorry if this is a repost. I am not sure it posted the first time. I do not think any looping is required. You should be able to do this using sub queries within the where clause. If you are using cfx_prod_custCat as a lookup table simply look for any category that is not listed in the custcat_id field: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE ID NOT IN (SELECT DISTINCT custcat_id FROM cfx_prod_custCat)) You use the same logic for the 2nd part of the UNION clause: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE category NOT IN (SELECT DISTINCT category FROM products)) Basically you use the sub query to pull a list of all products that have a category assigned and the look for categories that are not in that list. Hopefully I am not way off on this and it helps point you in the right direction. Brian Cain ~| 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:341561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would I do this in SQL?
I do not think any looping is required. You should be able to do this using sub queries within the where clause. If you are using cfx_prod_custCat as a lookup table simply look for any category that is not listed in the custcat_id field: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE ID NOT IN (SELECT DISTINCT custcat_id FROM cfx_prod_custCat)) You use the same logic for the 2nd part of the UNION clause: UPDATE Categories SET hasproducts = 0 WHERE category IN (SELECT DISTINCT category FROM Categories WHERE category NOT IN (SELECT DISTINCT category FROM products)) Basically you use the sub query to pull a list of all products that have a category assigned and the look for categories that are not in that list. Hopefully I am not way off on this and it helps point you in the right direction. Brian Cain ~| 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:341562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How would I do this in SQL?
Sorry that I answer didn't take inheritance into account. Is there a maximum number of levels of subcategories, or will it always be an unknown? I have done looping with tSQL in the past using cursors, and it really is a pain. You could use a UDF (User Defined Function) and return a table variable. Here is a link for an example of returning a table variable: http://sqlt.tripod.com/recursivity.htm You could probably modify this example to return a bit value if the category or any parent has a product assigned. In theory if you write the function correctly you could write a single update statement that sets the hasproducts column equal to the funtion value passing in the category as a parameter. Something like UPDATE categories set hasprodutcs = fnHasProduct(category) where fnHasProduct id the name of your UDF and accepts the category as a parameter. The real work would be in writing your UDF. You would want you to thoroughly test your UDF, but it could provide you with a powerful and simple execution that even incorporates a little OOP using tSQL. ~| 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:341569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: why is cf_builder so slow? (was: expensive)
Not to get on the DW bashing wagon, I actually prefer DW for all my work, but I can be buggy as hell. I actually wrote a batch file to kill it when it won't close properly. I found for me when it would hang on close and I would kill the task it would hang on start the next time. I finally discovered that by deleting temp files and a certain registry entry I could fix the problem without have to spend the day uninstalling and reinstalling. Brian C ~| 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:341572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
PlainText email
Hello all, I am sending email messages to users of a site I run. In an effort to lower the SPAM score. I am thinking about switching some of the more vital communications to plain text only email. I haver tested this and the emails go out fine. When check the email in my Hotmail account or Outlook, it displays just fine as plain text. No problems. However, in my GMail and Yahoo accounts, nothing is displayed for message content. When I view the original in GMail, I see the message content. I am using ColdFusion MX7. Below is the original message (minus header information) as received by GMail. Return-Path: i...@careersinfood.com Message-ID: 5782296.1296074847303.JavaMail.SYSTEM@Automation Date: Wed, 26 Jan 2011 14:47:27 -0600 (CST) From: i...@careersinfood.com To: bcc9...@gmail.com Subject: Your CareersInFood.com profile is about to expire. Mime-Version: 1.0 Content-Type: multipart/alternative; boundary==_Part_91883_30388397.1296074847303 X-Mailer: ColdFusion MX Application Server X-Server: High Performance Mail Server - http://surgemail.com r=1553965877 --=_Part_91883_30388397.1296074847303 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Your Login ID: bcc9...@gmail.com 215568 The profile you posted on CareersInFood.com is about to expire. Please visit CareersInFood.com to update your profile now. If there are no changes needed in your profile, just login to your account and update your profile without making any changes. This lets us know that your information is current. Updating your profile ensures that prospective employers and recruiters have the most current information available. You can update your skill set and your personal profile while you are there. If your profile is not updated it will be deactivated and will no longer appear in Employer/Recruiter searches. http://www.careersinfood.com/info/Jobseekers.cfm --=_Part_91883_30388397.1296074847303 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit --=_Part_91883_30388397.1296074847303-- Any help would be appreciated. Thanks, Brian Cain ~| 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:341448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: PlainText email
Thanks for the info Wil. I did read your blog, and my original design was coded exactly the way you specified using 2 mail parts (text and HTML) and specifying the type as HTML in the cfmail tag itself as seen below. cfmail to=#Candidates.EmailAddress# from=#SysSettings.Postmaster# subject=#Expired# server=#SysSettings.MailServer# CFMAILPART type=text Your Login ID: #Candidates.EmailAddress# #Candidates.CandidateID# #ExpiredContent.Text# /CFMAILPART CFMAILPART type=HTML #ExpiredContent.HTML# pYour Login ID is #Candidates.EmailAddress#/p /CFMAILPART /cfmail I was noticing that the HTML part of the message was raising my SPAM score. Many of the messages we send are purely informational and do not require the niceties of HTML display formatting so in an effort to reduce the SPAM score I simply removed the HTML part of the cfmailpart tag, leaving the text cfmailpart in place. This is when my problem started. It appears as though including a cfmailpart of type text without an HTML counterpart was causing the problem. I am sad to say that the only fix I could find was to do something close to your example of the improper use of the cfmail tag. If I simply include the mail message with no cfmailpart tags and do not specify type=HTML in the cfmail tag my message is displayed correctly, or at least as I intended it to. I do like your use of the textMessage function. I may incorporate something like that in my system. I will definitely help cut down on redundant coding. Thanks, Brian Cain ~| 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:341468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: DSN Connection String - failover faster/better?
Hi Kris, I don't really have a suggestion for your issue, but I was wondering what factored in to your decision to use mirroring instead of a DB cluster. I use a 2 node database cluster running MSSQL 2K5 and can drop the primary node and see my system recover (including running CF requests) in less than 30 seconds. I am not a database expert, but love the setup I have now. Thanks, Brian Cain ~| 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:341472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
