ColdFusion

I found a good convo here from 2013 that yielded one recommendation, and a few stay-away-froms. But that was two years ago. Much can change! Who would you recommend for a good hosting partner today?My husband's small business is besieged by what is likely a routing or peering issue at Cogent. Regardless, neither our host, Newtek (previously Crystaltech), nor our service provider are willing to help -- not that these situations can be solved, from what I've heard from networking pros and others on the 'net complaining about similar problems. (And by help, I mean having someone in their network ops group call someone down the line in hopes of getting the attention necessary to solve the problem.)We don't have a choice in service providers due to his location. So, it looks like my best bet in solving the problem is going to be switching hosts. I don't want to -- we've been with them for like 15 years, no kidding! But... this problem has grown from something that popped up briefly once or

Hello,we need  to know if compatible version of ColdFusion 11 Enterprise Server on a Windows x64 with server applications IBM Websphere 8 ND.At the next link just yourself appear compatible with Windows x32, but it seems to me very strange:http://wwwimages.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/cf11/coldfusion11-support-matrix.pdf

We have a webservice component developed in Coldfusion to handle a data feed from an external system.  External system is a java environment feeding data to our application through the webservice component.  When a bunch of messages are submitted ColdFusion handles few messages and rejects remaining messages in the server level(like 3 out of 10.  There is no patter we could capture with this connection.  Message counts are random.).  ColdFusion Server runs on IIS.  ColdFusion does not throw an error message to the external system for the unprocessed messages.   I am not sure if this is an issue with IIS or ColdFusion server. Any help would be much appriciated!

Good morning, I am seeing this warning on all instances of ColdFusion on one of our servers. It was patched to Update 7 this morning and those entries were not there before.Below you will find the excerpts from coldfusion-error.log file before Update 7 was installed and after (I have skipped some lines that show stopping logs for easier readability). After seeing this warning, I did some research that suggested turning on TldLocationsCache logs, which I did by uncommenting this line:org.apache.catalina.core.ContainerBase.[Catalina].[localhost].level = FINEin:${catalina.home}/conf/logging.properties fileHowever, I don't know where to find these logs; they are not in coldfusion-error.log or the coldfusion-out.log files. Can someone point me in the right direction finding those logs? Thank youOriginal log file (Nov 12 - last run before Update 7 was installed, Nov 23 Update 7 was installed):Nov 12, 2015 10:51:30 AM org.apache.catalina.core.AprLifecycleListener initINFO: Loaded APR based Ap

We are in the process of setting up a new CF 11 server. We are getting this error "error javax.mail.AuthenticationFailedException: 451 4.7.0" in the logs when we use cfmail that has been working for years on a CF9 server. Also the mail is in the Undelivered folder. We can drag to Spool, but it just comes back.We do use MS Exchange 2013 and we have added our CF11 servers IP in the Frontend connector that we use to relay mail to allow email from our CF server.Did something change with how ColdFusion processes email from CF9 to CF11?Our current cfmail parameters.<cfmail to="#theSendTo#"  cc="#theSendCC#"  server="mail.xenegrade.net"  from="#theFrom#"  username="<ourDomain\ourUsername>"  password="<ourPassword>"  subject="#theSubject#"  replyto="#theFrom#">

I'm trying to generate a 3 tab Excel spreadsheet using cfspreadsheet.  My code worked in CF10, but errors in CF11 (fully patched as of 11/1/2015).  The error is:The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbookFirst thing I tried was to comment out all SpreadsheetFormatSomething functions, but that failed.  I do see that another user encountered the error (https://bugbase.adobe.com/index.cfm?event=bug&id=4022999) but I have not found any solution. It looks like when Adobe "improved" the spreadsheet functions for CF11, they probably added/cloned a POI style with every new cell.  Does anyone have a solution/wokaround for this problem?  Will Adobe fix/patch this anytime soon?Thanks in advance for the help,Steve

Hi GuysI'm still working on a CF9 environment and starting to develop a new system, that is going to be used for multiple clients and that is going to include lots of "addons". Some versions of this system won't have all add-ons and will have a sub set of them.To try and make this as flexible as possible, I am trying to create a parent persistent entity, that creates my database table, has primary key, most details etc. Then for each addon I won't to include an extended class of the parent that includes some additional mapping to the addon specific persistent class. I then want to be able to call the parent entity but have it include these extended properties. Is this possible? I have tried using "mappedsuperclass" but as I have an even high level entity linking one-to-many to this parent entity, that starts to error.I'm not even sure if this possible but any help would be great as my head is now fried looking at relational databasesMany thanksTom

Any good CF development companies that you can help me out for some maintenance work?

I have classes that are no longer active once the date of the class has passed. However, the class will need to be displayed for seven more days in the backend. I tried using the script below to accomplish this but I keep getting an error “variable DATE is undefined.” Am I heading in the right direction or is there a better way to accomplish this?<cfquery name="getClasses" datasource="#application.dsn#">select *from (classReg INNER JOIN classes ON classReg.classID = classes.classID) INNER JOIN instructors ON classreg.instID = instructors.instID<!--- adding seven days to the class date (date) comparing it to the current date ---> where #DateFormat(DateAdd('d', 7, date),'yyyy-mm-dd')# > #DateFormat(now(), 'yyyy-mm-dd')# </cfquery>

Was in IT many years ago, then went into management and have become useless.  Have seen ColdFusion in action and would love to play with it.  Learn-in-a-week is starting to accumulate non-productive days.ColdFusion 11 installed, MySQL 5.7 installed - all running, Sample files down and verified, Port 3306 seems OK , created database from Command line.  When using CF Administrator  get the message that connection to database server could not be created.Any help from the community would be gratefully received

Hi can we get the source for the adobe modified mod_jk 1.2.41 so that we may compile it ourselves?  It seems that the binaries delivered in the update do not work on our platform (Centos 5.11), as starting the webserver (Apache) yeilds the following error:Starting httpd: httpd: Syntax error on line 276 of /etc/httpd/conf/httpd.conf: Syntax error on line 2 of /etc/httpd/conf/mod_jk.conf: Cannot load /opt/coldfusion11/config/wsconfig/1/mod_jk.so into server: /opt/coldfusion11/config/wsconfig/1/mod_jk.so: undefined symbol: ap_get_server_descriptionThis was similar to the error which had us compile our own mod_jk originally with the source provided here: ColdFusion10 RHEL connector configurationWe would like to keep our connector up to date.  Please provide the source for the new release of mod_jk.Note:  I did try to compile the ASF version of mod_jk, which did not work, so I can only assume that Adobe is still modifying the protocol.Thanks

I am migrating from CF9 to CF11 and have some web service client code that interfaces with Salesforce.com.  After the WSDL is parsed with createObject() the method arguments in CF11 are not the same as they were in CF9.    For example, in CF9 the login() method only requires 2 arguments, username and password.   In CF11 there is an extra parameter called LoginScopeHeader.It looks like it has to do with the operation elements.     CF9 appears to be using this definition in the WSDL file:    <!-- Login Message Types -->             <element name="login">                 <complexType>                     <sequence>            &nbsp

I have an oracle data source which works fine in a web app but wont work if I write a cfquery inside a cfclient. I would like to know what the problem is or is it a bug.index.cfm:    <div id="actual_1"></div>  <cfclientsettings  enableDeviceAPI = "false"  detectDevice = "false" >    <cfclient>   <cftry>    <cfinvoke component="querydb" method="getDbdetails" returnvariable="variables.ServerForms"> </cfinvoke>         <cfset document.getElementById("actual_1").innerHTML+=variables.ServerForms>    <!---<form action="listcsar.cfm" method="post">     <input type="submit" value="View my CSAR">         </form>--->    <cfcatch>     <cfset document.getElementById("actual_1").innerHTML+= cfcatch.message & "<

Hello, all,Is anyone aware of a good CF developer forum?  I've looked around, and I'm not seeing much as far as CF goes.  Mostly forums that have very little activity.V/r,^_^

We have a webserver connected to an old database.  The old database server is end of life.  When we set that up we did not need a secure connection.  Now we have a new database on a new database server.  Our IT department is requiring this to be a secure connection (even though it's an intranet).Using ColdFusion Administrator I tried simply editing the URL of the server, but I get this error:Connection verification failed for data source: xxxxxxxxjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]The SQL Server login requires an SSL connection.That's when I heard from my IT people that it needs to be a secure connection.I have no idea how to do that, and Google didn't offer me any help, probably because I don't know what to search for.Could one of you wonderful people please offer a sugg

I don't have the option to add more than 1 user, I am using Standard:When I expand Security, I only have 2 options.Can I add more users?Thanks

I am using Coldfusion 11 Standard Update 4 on a VMware virtual server with Windows Server 2012 Datacenter.We are having a problem where pages using <cfspreadsheet> or <cfdocument format = pdf> stop responding. Web browser just sits there loading page. All other pages seem to be working just fine. This has been going on for several months.Sometimes I can restart the CF Application from 'services' and it starts working again. Most of the times I have to reboot entire server. Sometimes several times before it starts working again. It may work for days or just a few minutes before I have to reboot again.I can't figure out what's causing it, or how those 2 tags are related. As I said, all other CF pages work just fine.Thanks for any help.

We started with a working instance of Windows Server 2007 R2 using IIS 7 with Coldfusion 9 Enterprise Edition installed that hosts multiple sites (in fact its still currently running now).  Made an exact copy of it to a new instance.  It worked just as the old one did though we could only run each site through localhost as the old domains have not been transferred over to point to the new server.  We uninstalled Coldfusion 9 Enterprise Edition and then installed Coldfusion 11 Standard Edition.  This is of course where things started going horribly wrong.Being a new install using the Coldfusion Web Server Configuration we added all the sites. At first just nothing worked.  500.* errors always.Multiple tries of removing and adding sites through the config manager didn't work, then we noticed that Coldfusion 9 had not properly uninstalled and removed its vestiges from IIS.  AboMapperCustom was still listed in all the site's Handler Mappings.  Force remov

I am trying to write  a regex expression to match a string that is between 6 and 20 characters long, has at least 2 digits that do not have to be consecutive, and any number of alphabetic characters that do not have to be consecutive. All non-case sensitive. I've gotten this far, but it's still not working:^(?=\D*\d{2,}).{6,20}$Should match "abc3def1", but it doesn't because the digits aren't consecutive even though there are two of them. This does match: "abc34def1".Please help!

It is crashing our servers...  We set Maximum JVM Heap Size (MB)   to 1024...  but it doesn't change anything.  Ideas?Thanks!

When I am installing cf11 using IIS as the web server I cannot get the cf administrator to work. IIS tries to download the index.cfm rather than running it. This is only a problem with administrator as if I browse to my site, it will run the cfm, but obviously I have no datasources configured so it falls overI have tried http://127.0.0.1/CFIDE/administrator/index.cfm and http://localhost/CFIDE/administrator/index.cfm Both just ask if I want to open or save the index.cfmDoes work ok if I use the inbuilt web server and go through port 8500, but need to get this installed on our public facing servers using IISAnyone any ideas

CF11 w/update 6 cluster on Windows Server 2012 R2.  Secure profile.  The cluster includes two instances, one on a remote VM, and one a "home" instance (on same VM as IIS website and cfusion instance in which I create the cluster), and I think I set it up more or less in a standard way.  Everything works fine after I set it up.  Restarting the remote instance works fine.  Restarting the "home" instance--even after no changes to anything--results in the instance hanging during startup and may not be shut down except via Task Manager.  Any help from cluster experts out there would be greatly appreciated.  I'm happy to provide additional setup or diagnostic info.Setup detailsNothing unusual about the configuration, except maybe that the home directory for the website is in an alternate directory per lockdown recommendations.  I also add maxThreads and connectionTimeout attributes to the Connector node for AJP/1.3 in server.xml.  When registering

How do I set content security policy sandbox?Thanks!

I recently ran into a frustrating issue while doing some date comparisons within ColdFusion Query of Queries (QofQ) and selecting records with dates less than a specified date using <cfqueryparam>.Luckily I was already familiar with the "quirky" behavior of QofQ when it comes to dates and how you need to use createODBCDate() (or createODBCDateTime()) before making comparisons.  If you're curious why I'm using cfqueryparam's in my QofQ date comparisons you can find a bunch of articles about why this is done but here's a popular one from Ben Nadel if you're up for some reading: ColdFusion Query of Queries Unexpected Data Type ConversionAnyway, I came across a slightly different issue where the date comparison was ignoring time differences within the same day.  Check this out:Here's my reference date:<cfset o.referenceDate = "{ts '2015-11-16 23:59:59'}" />Here's where I set up a query object (3 rows with 2 dates that come before my reference date and 1 date after)&lt

need to transfer a couple CF licenses. 'Contact Support' wants me to post here (???)... Any Adobe help on creating a license transfer ticket?