ColdFusion

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.

Can anyone help me make this loop work.  This is how my structure is created: <cfset resData = ConvertXmlToStruct(gatewayResponse.Filecontent, StructNew())><cfset resTran = 'resData.Body.PosResponse.Ver1.0.Transaction.ReportBatchHistory.Details'><cfloop index="idx" from="1" to=#StructCount(resTran)# step="1">    more cf code....</cfloop> Here is the structure: I thank you in advance.

Apologize in advance for not seeing the obvious query to get the result set I need, but a picture is worth...Thanks for your advice.

Good morning,       I am having an issue when attempting to add a new or remove an existing web server via the ./wsconfig -i gui command on my CentOS 7 box.  I am getting a message when attempting to add or remove: "This web server is already configured by some other version of ColdFusion.".  This is a new install of ColdFusion 2018 and the server has never had another instance of ColdFusion installed.  However, I have had to un-installal/re-install ColdFusion on a couple of occasions.  I would really appreciate any insight on how I can fix this issue as I am currently testing some test web applications before moving production applications over to this new server. Daniel

Hi!I hope nobody minds, this is not strictly a Coldfusion issue. But I like my chances here better than in any of the other, more general forums. I'm trying to embed a video in a div on my site's homepage. Whether I use the iframe embed code that YouTube provides, or create it as an <object>, the video will play, embedded, within the div for all screen sizes but my iPhone screen. In that case, it zooms to fullscreen when the video starts, and I can click the control on the video as it's playing to force it back into the div. You can view/test this behavior at  https://test.aptmaps.us/index_video.cfm. This is just a borrowed video, so it doesn't relate to the site's content.  I've searched for an <iframe> or <object> method that might force the video to play "minimized," but I can't find anything. Anybody know the trick I'm missing? Thanks! The code I'm using is either of the two following below. FWIW, I'm incorporating bootstrap styling, so the div

Hello,We recently migrated our applications from ColdFusion 9 to ColdFusion 2016. One of our applications SFTPs files using cfftp tag.We noticed that CFFTP tag with ColdFusion 2016 no longer works. We worked with our internal IT team and the remote SFTP server team to resolve all issues with firewall. When we connect with WINSCP from our end, we were able to successfully connect to the remote server but when we use CFFTP from ColdFusion 2016, it seems stuck in the CFFTP tag. It does not even time out.Initially we thought it's the same code as CF9 and since CFFTP worked in CF9, it should work in CF 2016 but it did not. Later we realized that some of the tags were deprecated and we corrected that and ran the tests. But our efforts were in vain.We get this error message in the FTP log: "Information","ajp-nio-8016-exec-1","06/20/18","14:06:00","","Starting FTP request {action='open'}"We used the below code to connect:<cfftp action = "open"   connection = "myConnection1" &

Good morning,       I have a ColdFusion 2018 install on a Cent OS 7 server.  I have changed the document base via the server.xml file, and added the PreResources base for CFIDE and WEB-INF: <Context path="" docBase="/var/www/vhosts" WorkDir="/opt/coldfusion2018/cfusion/runtime/conf/Catalina/localhost/tmp" ><Resources><PreResources base="/opt/coldfusion2018/cfusion/wwwroot/CFIDE" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/CFIDE"/><PreResources base="/opt/coldfusion2018/cfusion/wwwroot/WEB-INF" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/WEB-INF"/></Resources></Context> After saving the sever.xml file, restarting coldfusion server, I am able to see my local web sites just fine on the browser, but the admin page is grayed out with a search bar.  I have done some initial research, and have tried editing the neo-runtime.xml file for the CFFormScriptScrc, a

We are going to migrate several servers from Coldfusion 2016 to 2018.During our tests we have the following problem:We use a SOAP webservice for communication between two servers.The caller of the webservice is still CF 2016, the called server was migrated to 2018. Since the migration the webservice throws the following error if the returned data contain boolean elements: <br> <pre>AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: org.xml.sax.SAXException: No deserializer for {http://rpc.xml.coldfusion}CFBoolean faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException: No deserializer for {http://rpc.xml.coldfusion}CFBoolean at org.apache.axis.encoding.DeserializerImpl.onStartElement(DeserializerImpl.java:453) at org.apache.axis.encoding.DeserializerImpl.startElement(DeserializerImpl.java:393) at org.apache.axis.encoding.DeserializationContext.startElement(Deserial

This is about as mission critical as it gets in the US Federal World. PDFs generated by ColdFusion must be section 508 compliant. It looks like the biggest issue is tagged content. Has anyone successfully generated a tagged pdf in ColdFusion 11???