ColdFusion

Hi All I'm trying to find some help / pointers to create a work/schedule/calendar section for my website. I need 1 month across the top and my resources/programmers down the left. Quite a simple layout but I've been struggling for 4-5 days, any help/pointers etc. would be gratefully received. ThanksGary

The small Australian organisation I consult for has a problem. The CF application I created for them some 8 or 9 years ago and which they have been happily using ever since, seems to have reverted to the developer version thus restricting them to a single workstation for the application when they need 3 or 4. We originally purchased CF8 and in 2018 moved to CF9 but we have no idea what our CF serial number is and therefore can't correct the situation. I have spent a fair amout of time trying to figure out how this situation arose without finding an answer. How can we find out what our serial number is?

Hello everybody!I'm posting this here to have a place to gather any information about using Postgres 12 with the most recent releases of Coldfusion. In our current environment (Postgres 12 and CF2018), we are getting errors thrown by Postgres indicating a very mismatch between the client (CF's JDBC Postgres driver) and our Postgres 12 database server. We do not see these errors when connecting to our Postgres 11 server. I will document here our updating attempts to resolve this issue. First, we will update to CF2021. This may resolve the issue, but I'm not optimistic as the support matrix only says Postgres 11. If that does not succeed, we will try simply replacing the jdbc driver jar and test that. Hopefully it won't break coldfusion and will resolve the errors. If anyone else has done this, I'd love to hear how your experience went. If anyone from Adobe has any advice or news on if/when Postgres 12 will be officially supported, that would be great to have!thanks, everyone!

Moved from an old laptop to a new Surface computer. Trying to connect my Localhost (127.0.0.1) installation on Windows 10 on the IIs server to my existing MySQL database. CF Administrator works fine, as do my CF templates (except for queries, of course). Got this message:"The standalone MySQL JDBC driver is no longer shipped with ColdFusion.Please download it, put it in cf_root/lib folder and restart ColdFusion."1. Where to I get the correct MySQL JDBC driver?2. Does is go under C:\ColdFusion2021\cfusion\lib  ?Thanks in advance. 

Hi i have an value:  20191111153402IT is: YYYYMMDDHHMMSSHow can i convert it in an mysql DATETIME Format? Anybody an idea? Kindly RegardsThorsten

What could possible go wrong, right? Since we bought CF 2021 I googled "coldfusion download" which took me here https://www.adobe.com/support/coldfusion/downloads.htmlUm, no Linux 64bit installer? Ok, so I logged into my adobe account and got here: https://www.adobe.com/products/coldfusion/download-trial/try.htmlActually, I don't want to try it 30 days ... we already purchased it ... now I need to fill in a marketing survey?! REALLY?Well, ... after hitting the "Download" button I got to a page with some getting started content, but no download. I tried a few times with mostly random answers to the survey. Frustrating ... Turns out the download doesn't start in Chrome 87 so I needed to switch to Safari browser to get the ColdFusion_2021_GUI_WWEJ_linux64.bin Ok, since I want to update our CF docker image which we use for development I searched for silent installation properties.https://helpx.adobe.com/de/coldfusion/using/install-coldfusion-2021.html#Sil

I am having an issue with the square API and want to make sure I'm not doing something stupid. Here's my code: <cfset stFields = { "order": { "idempotency_key": "xxxxxx-215d-4dce-b92a-90c306eb5eba", "location_id": "xxxxxx", "total_money": { "amount": 99999, "currency_code": "USD" }, "order": { "location_id": "xxxxx", "customer_id": "asdasd" } }, "idempotency_key": "xxxxxx-215d-4dce-b92a-90c306eb5eba", "ask_for_shipping_address": false, "merchant_support_email": "consectetur@loremipsum.com", "redirect_url": "https://abc.com" } >  I keep getting the error: {"errors":[{"category":"INVALID_REQUEST_ERROR","code":"VALUE_TOO_LOW","detail":"`order.total_money.amount` must be greater than 1.","field":"order.total_money.amount"}]}Yet... It looks to me like there's a value...  Any ideas??? 

We have just recently updated from CF11 to CF2018.One thing we do often as we develop is use CFDUMP to view the contents of variables and objects as we're coding.  We've grown quite fond of ColdFusion's neat little CFDUMP tables that make viewing objects so convenient such as this little example:However, since installing CF2018, CF when we use a CFDUMP inside a CFC we no longer get this nice view.  We get a plain old HTML table that's much harder to read..especially as the objects grow much larger:Viewing the source code of the dumped page, CF is not inserting the CSS nor JS for it's CFDUMP tables when used within a CFC.  Everything is fine if the CFDUMP is used on a CFM page.  This was not a problem in CF11 nor any version prior.Any ideas how to get CF to 'dump' out the CSS and JS when used in a CFC?

We have many queries which do something similar to:WHERE dateCol > <CFQUERYPARAM VALUE="#someDateString#" CFSQLTYPE="CF_SQL_TIMESTAMP"> Today, users informed us that existing reports were returning unexpected results.We use datetime2(7) columns in an MS SQL server. As an example, we have data (3 rows) in a table with dateCol values of "2020-03-01 10:00:00.54321".We run a query with a clause of: WHERE dateCol > <CFQUERYPARAM VALUE="2020-03-01 10:00:00.54321" CFSQLTYPE="CF_SQL_TIMESTAMP"> These queries have been in place for years, and up until today they were working fine.  The example query was returning 0 rows (as the timestamps were equal).Today, the query is returning the 3 rows as if the converted value (from whatever CFSQLTYPE does internally) is earlier than 2020-03-01 10:00:00.54321. Removing CFSQLTYPE="CF_SQL_TIMESTAMP" makes it work as expected.  Running the query in SSMS without CFQUERYPARAMVALUE at all makes it work as exp

We have ColdFusion 2018 with Java version 10.0.1.  There is also installed on the server JDK 12.0.1.  Is the JDK necessary and required?  We have security notice that JDK should be updated to version 15.  Can this be done without causing problems for ColdFusion?  Thanks,Jim

We're running an older CF10 instance on Windows Server 2012 that we finally got approval to upgrade. The goal is to bring it in line with other instances of the same application, so we're upgrading to CF2016. During the upgrade process, we chose "Configure my web server for ColdFusion 2016 (recommended)" as opposed to "Enable the built-in web server (coexist)". The upgrade process went fine, with 1 reported error.  Looking into the log file, it was an error related to the connector, which made sense as we had left the old CF10 instance and conenctor in place. We got onto CF Administrator, chose not to migrate anything (we do a full review of settings against a reference server manually), and verified some basic settings. We went through the process of updating CF (to 11, then to 13), then stopping CF10, removing the connector for CF10, and adding the connector for CF2016.  This all went as expected. We then set the CF2016 Application Server to ru

Good morning,       I have a very strange occurence on several web pages.  I have some cfc binds setup on a couple of web pages that are being called from another folder directory instead of the current directory the cfc's reside in.  For example, one of my binds should be calling a cfc file that exists in the same folder that the web page exists in, but it is calling from a completely different directory:Current directory of web page and cfc file: /var/www/vhosts/egtyctest.com/egtgup2.egtyctest.com/XXX/XXXWhen page is erroring out, rawtrace: /var/www/vhosts/GUP_EGT/XXX/XXXXThe GUP_EGT folder does exists with the same file structure as the egtgup2.egtyctest.com folder. I have other cfc function calls that are calling the correct cfc files from the correct path, but they are not bound to a cfselect or cfinput.  Any insight on this issue will be greatly appreciated. Thanks, Daniel

Does anyone know if the Developers edition can be installed in an Azure environment?And the same thing for the 30 Day free trial.  Can that be installed in an Azure environment? I know the new version is suposed to be capable of it, but can the "freebies" also be set up in a cloud environment to do some proper testing and understanding of the new features before I recommend my company to buying it. Thanks

Hello, Has anyone had success with centering or spanning the entire PDF with a header image?  When I add a header image with the code below, it is always left aligned no matter if I use the align attribute (which says it is for text) or if I increases the width of the image (it appears to be cropped). <cfhtmltopdfitem type="header" image="pathto/simple_head.png" /> I would like to use the Coldfusion to PDF capability because I need to deliver my user accessible PDF's on demand. Thanks!

Good morning CF community,       I have a new install of ColdFusion 2018 Entereprise on a CentOS 7 box, and have run into errors being thrown if on a web page that has cfstoredproc call, and the query scripts in my database procedures have a table name that is in all caps.  All table names on the database are lowercase.  My companies current live ColdFusion setup, on a webserver we are migrating from, does not have this issue.  This setup processes queries from procedures just fine, even if the table names are capitalized in their scripts.  For example, on our current live setup, if a query has: "SELECT STU_LAST FROM xx_xxx.TABLE_NAME, it processes just fine with no errors.  On the new server, it throws an 1146, Message: "Table 'xx_xxx.TABLE_NAME' doesn't exist", SQLState: 42S02, even though the table does exists but its name is all lowercase: 'xx_xxx.table_name'.  Is there a parameter I can set to ignore case senstivity from

I'm trying to get ColdFusion 2018 running using the official Adobe Docker images.  In the past we've used the CommandBox images with great success but this app is using cfhtmltopdf and I need the PDF server.I have built a docker-compose:https://gist.github.com/jimpriest/fbf64333531f6d36030aa4ab0f6424f0I'm using a Dockerfile in order to install Commandbox and CFConfig to restore my server settings.This runs, my app fires up.  I can open CFAdmin and confirm the connection in the PDF Service tab (I get an "OK").But when trying to generate a PDF I get a vague error:ServiceManagerConversionException: Error occurred while generating PDFThis same code works fine on a normal ColdFusion 2018 install so I am going to assume this is not a code issue.This page (https://helpx.adobe.com/coldfusion/pdf-generation-in-coldfusion.html) mentions needing to install some imb-type-1 fonts in Linux (which is what the Docker container is using) and if I shell into both the ColdFusion container and t

I have a CF9 installation which has been stable for a long time, maybe years.  Two days ago, after a Windows update, my CF datasources no longer worked. The message I get on everyone one of my datasoruces is: Connection verification failed for data source: HomeOnSqlServerjava.sql.SQLException: [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. My SqlServer database is running fine; the ODBC32 and ODBC64 applications show the datasources are all valid. So I thought that since CF9 is old I'd upgrade to CF2021.  I did the install but I get the same message with CF2021 as I did with CF9.  So then I went back to Windows and tried to uninstall the update which seemed to cuase the problem, but that didn't fix the problem. My guess, but it is only a guess, is that when Windows 10 did this last update it must have changed some setting or removed some service which the CF ODBC datasources require. Does anyone have any idea how I go a

Hi, We have a legacy CF application that has a number of Java classes as part of its API (we do not have easy access to these). A long-running issue has been that database connections keep rising and are never released. We have tried the JDBC and ODBC drivers for MSSQL with the same overall result. Changing lots of settings in the DSN settings has also yielded no different result. We have a lot of "IF @@TRANCOUNT > 0 COMMIT TRAN" commands when we look in the MSSQL sys.dm_exec_connections table. We wondered if autoCommit was an issue, but have not found a way to effectively use it in the DSN/driver settings. We use the latest MS JSBC driver, version 8.4.1. We wondered if the Java classes were not properly closing the connections - this seems to be the concensus by many developers, however not even CF can close these "stale" connections and eventually the server crashes (web requests pile up and JDBC connections go to zero). Any advice appreciated.

Team, starting to reseach what it would take down the line to move out internal CF website to allowpublic internet access. From previous work, I do understand this server itself would be locked down with no Internet access/FW rules would be needed for internal DB /share connections. etc Any external links/call from Web would also need to pinholed. We are going to CF 2018 this year. Looking for any documentation/gotchas need to consider this new DMZ server.Our SSL Cert also needs allow access ext/internal. ty Jose  

We have CF2018-based systems that heavily utilize the CF PDF creation subsystem.  These systems were initially deployed on CF Standard Ed., but we found the PDF single-thread limitation in that version to be too constraining.  We upgraded to Enterprise, as the PDF subsystem is supposed to be multi-threaded.  However, there are some situations where PDF generation requests can deadlock, and negatively impact overall system performance.  The only fix for this situation has been to restart the CF App Server service.   Adobe has a hotfix available, https://tracker.adobe.com/#/view/CF-4198342, which they will provide on request.  This fix has also been included in CF2021.

We noticed today that the system time on our server where CF is running was three hours off. The admins fixed the system time, but the time that ColdFusion outputs using its Now() function is still three hours off. Does updating the system time require a CF restart? Could it be that ColdFusion separately manages its time internally once it comes up, unrelated to system time?

I have a situation where an excel file is created on the server via ColdFusion and if I have it downloaded to my local machine, via my code, I will get what a appears to be a previous version of the file. If I copy the file from the server to my local machine it is what I expected. The file should have 30 rows but the downloaded version has 60 rows. I have watched the file change the time stamp on the server during the code running so I know the file was changed. I have tested the code on 2018 on a different server without this happening. Trying to determine if there is a server setting or a issue in 2016. Any ideas.

We just installed CF 2021 Enteprise on our Dev server (Win Server 2019) last week.<cfquery name="qUserGroups" dbtype="query"> SELECT groupName FROM request.store.groups WHERE groupID IN (#qUsers.userGroupList#) </cfquery>Whenever a Query of Query gets a shared scope variable, this error occurs:"Error casting an object of type class coldfusion.runtime.RequestScope cannot be cast to class coldfusion.runtime.Struct (coldfusion.runtime.RequestScope and coldfusion.runtime.Struct are in unnamed module of loader coldfusion.bootstrap.BootstrapClassLoader @69909c14) to an incompatible type. This usually indicates a programming error in Java, although it could also mean you have tried to use a foreign object in a different way than it was designed." I have also tried setting the value to a local variable or even the application scope, but the error is the same. Help! 

We're exporting some data to CSV files and when using CFFILE (write/append) with CHARSET set to "utf-8", the file seems to be properly encoded, but there's not BOM (byte order mark) at the beginning of the file. As far as I know, this is standard practice as the BOM is optional.  Some applications (like Notepad) open the file just fine, and render the UTF-8 accented characters, angled quotations, etc. just fine. Excel, however, has issues when opening the file if the BOM is not present.  If I manually add the BOM to the beginning of the file using another application, Excel opens it fine (and so does Notepad). Is there a simple / recommended way to add the BOM to the file using CFFILE or other built-in functionality? The BOM character entry in UTF-8 is U+FEFF (65279) or EF, BB, BF in raw hex.  So currently, I'm starting our file output with CHR(65279), and this does seem to work. Thanks

Hi All, I run a online browser based game, and there used to be chat in SWF format but thats no longer working for obvious reasons. I now need to locate a chat I can use so other players can communicate between themselves. Can anyone point me in the right direction please? ThanksAnthony.