ColdFusion

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?

Can any one help me on this "Cannot extract the embedded forn 'PCBOHZ+TimesNewRomanPS-BoldMT' some characters may not display or print correctly"

Hi,I have an image edition module that permits to rotate an image 90º right or left.It rotates the image, rewrtite it in the same file and redisplays it:  <CFIMAGE    ACTION="rotate"    ANGLE="#rot#"    SOURCE="#path##getItem.fileName#"    DESTINATION="#Path##getItem.fileName#"    OVERWRITE="yes"    >    <!--- Invert width and height --->    <CFSET width = GetItem.height>    <CFSET height = GetItem.width>..............  <IMG SRC="#path##getItem.fileName#"        WIDTH="#width#" HEIGHT="#height#" BORDER="0" ALT="">The height and width are indeed inverted, the file is correctly modified, but the image displayed does not look rotated.It looks like the browser still displays the file in the cache, although the Last-modified parameter of the file has been modified and set to after the date

I have some old application in ColdFusion 5 connecting to Oracle 9 and SQL.  We have upgraded to Oracle 11 making it incompatibel.  Is upgrading to ColdFusion 11 an option?  Are there known issues and challenges?

I have a popup form action page that opens by using the form/target="_blank"  attribute.The new document does a database insert and then creates a PDF using the <cfdocument> tag.I'm trying update some elements on the parent/opener form page as it is common for the client to continue using the parent, make some changes, and generate another PDF. If I comment out the <cfdocument> tag my code works fine, the parent document is updated as I expected.I'm not sure how to proceed, help much appreciated!thanks, LyndonJavascript I'm trying to run just before the <cfdocument> tag:<script>        window.opener.document.getElementById('photoListTitle').innerHTML='test update';</script>Tag Attributes:<cfdocument        localUrl="yes"        format="PDF"        pageType="custom"        page

Hello,I get the error message "Could not determine OpenOffice installation"  when I call  CFDOCUMENT tag to convert a DOC file to PDF format.The the path of the OpenOffice installation (/opt/openoffice4/) is correctly  set in CFADMIN - Document. I am still receiving the same error message thoughThe OS platform is Linus RH 6   (2.6.32-504.23.4.el6.x86_64)Coldfusion version : 10,282462Any idea/tips about this issueThaks in advanceOthmane

I just had my site scanned and I noticed some strange errors that were triggered. When my scanner supplied the following search text (minus the quotes):"X-CRLF-Safe-9b4de84877858f2fe7b59d6da03dbaa819ae590be0f88b961ae8d36f09fab4e5: no"the cfsearch tag through the following exception:"Error executing query : undefined field X-CRLF-Safe-9b4de84877858f2fe7b59d6da03dbaa819ae590be0f88b961ae8d36f09fab4e5"To me this appears to be a SQL injection vulnerability in SOLR or the CFSEARCH tag. I can duplicate this on both CF10 and CF11. Ideas? Is this a known vulnerability? Is there a fix?My CFSEARCH tag is coded as follows:<cfsearch name="qSearch" collection="myCollection" criteria="#FORM.searchText#" contextbytes="300" />

Hi guys, I need my cfoutput to align horizontal, for some reason it keeps puping up vertical. Any suggestions?<table width="95%" border="0" cellpadding="0" cellspacing="3">  <cfoutput query="getTeamMembers"><tr><cfoutput query="detailled"> <td width="100"> <cfif HasCV eq 1> <a href="ADM/#LastName# #FirstName#.pdf" target="_blank"><img src="../../../../Photo's/#id#.jpg" width="70"  /><br />#FirstName# #LastName# </a>    <br />#Position# <cfelse> <img src="../../../../Photo's/#id#.jpg" width="70" /><br />#FirstName# #LastName#<br /><th width="21%" style="vertical-align:top; text-align:left">#Position#</th> </cfif> </td>   </cfoutput></tr></cfoutput>

I have a question about coldfusion. By Mistake I delete my project from file system, my question is any way I can rollback my project. I am using Coldfusion builer 3.

Could someone help me with a rough database schema or a responsive timesheet application for web.

I have a client who sends out postcards to his clients.  Currently he is using a MS Word mail merge system, and he wants to switch to a more automated system using ColdFusion.  I have the original document as a PDF, and I'd like to use ColdFusion to populate the fields.  He also wants to be able to edit the non-filled information.Is it easier/better, to use the original PDF and fill the form using cfpdf, or should I generate the entire document in ColdFusion (using cfdocument, maybe?) and then convert to a PDF?Thanks!

Hello.Does anyone know where I can find a 32 bit 8.0.0 to 8.0.1 updater?  I realize 8.0.1 is EOL, but perhaps somebody has run into a mirror, here?Thank you for any answer or pointer you can provide.

Where can I find the ColdFusion 8.0.1 Updater?I can see hotfixes for 8.0.0 and 8.0.1, but nothing to take me from 8.0.0 to 8.0.1......

Windows 8.1 -- MSSQL8 2RThe error code your SQL guy will want to know is MS SQL error 3201.What am I doing wrong?Thanking you in advance.

Hi all. We would like to implement a counter of events in the header of our application without resetting the session, meaning the session should time out as if no call to a cfc and function were made. We are thinking that if we polled a function, the session would never time out. We don't want to use websockets because they are a bit buggy in CF10-hence the polling route.Anyone know how we can do this?Thanks for your time.-Andy