ColdFusion

In my application, I am getting an error saying "The type for attribute format of tag document could not be determined". This is happening during PDF generation using cfdocument tag. Note that we are working with PDF files in Memory (ie , we are using the coldfusion option to write a PDF file to a variable by using the name attribute). Attaching the stack trace here. 

I just installed Coldfusion 2018 standard on a new Windows Server 2016 VM.  The installer I used has Update 2 pre-installed, and I'm trying to upgrade to Update 7.  From what the documentation states, I need to apply Update 4, and then 5,6,7 separately.  However, I'm having 2 issues: One: the interface in CFAdmin doesn't actually have the download links available for anything (it appears to be hidden in an accordian box).  Since I'm running this on a server, I don't really want to install other browsers to find one which renders this correctly. Two: after giving up on installing via the admin console, when I try to download apply Update 4 manually via the jar file, it fails with a message saying "some errors occurred during the install".  It points me to an installation log that doesn't seem to indicate any errors.  I also tried to manually install Update 3 with the same results. Any direction would be appreciated!

I am looking/investigating some error we've been having with a CF app. And looking at Application.log, it is not listing the full URL being process when the error occurs. I would like to change this behavior but I do not know how to do this? Can you please help? Example of an entry in Application.log------"Error","ajp-nio-8016-exec-2","03/13/20","15:02:40","","File not found: /testapp/index.cfm The specific sequence of files included or processed is: /opt/www/apps/testapp/index.cfm'' "----Thanks

Hello, I have got the source code for a webapplication written using CFML. In the current production environment, this is uing bluedragon engine and IIS as webserver.  The legacy server has windows 2008 server and IIS 6. Can you please help in setting this up in windows 7/10 with latest versions of IIS. 

when I am fetching the date from the database it's showing one date before.for example - if date in the database is - 2020-02-26then when i fetch to my coldfusion using select date from db it shows - 2020-02-25. I checked for the now() which is showing correct.- showing accurate now date and time. issue is only when i am fetching it from the database. 

Just upgrade from ColdFusion 9 to ColdFusion 2018. A sybase stored procedure ran successfully in ColdFusion 9, but get error in ColdFusion 2018. The code to call the stored procedure <cfstoredproc procedure="sp_cm_set_project_details" datasource="#APPL_DATA#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_exist" value="#ref_proj_exist#"><cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC" dbvarname="@ref_proj_id" value="#ref_proj_id#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_name" value="#trim(ref_proj_name)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_location" value="#trim(ref_proj_location)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_city" value="#trim(ref_proj_city)#"><cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname="@ref_proj_prov" value="#trim(ref_proj_prov)#"><cfprocparam type="In" cfsqltype="CF_SQL_NUMERIC"

I am looking for an existing tool, resource, program, etc. to display the results of nightly tasks.  I want to make this available for employees outside of the IT sphere, to make it easy to see that tasks have or haven't run. An ability to retain and display historical ST data would also be beneficial.Thanks.

Need to switch to LDAPS (LDAP over SSL) before Microsoft turn off LDAP in January 2020 - but cannot get it to work.Created certificate on Cold Fusion server (checked is using ldp.exe).Exported it to a Base64-encoded X.509 format xxx.cer certificate file.Added it to the cacerts file using keytool, this being under the JVM listed in the Cold Fusion Admin page (and checked contents using -v option).Amended the existing cfldap tag to include port="636"  and secure="CFSSL_BASIC"Ran test - and it failed with :An error has occurred while trying to executequery :simple bind failed: xxxx.xxxx:636.  One or more of the required attributes may be missing or incorrect or you do not havepermissions to execute this operation on the server. Has anyone any ideas to fix it?

hi,I am trying to update a word document by using rtf, word2007, and coldfusion 8 as such: <!-------------------------------------------------------Generate a unique ID for the file in the temporary serverdirectory and get the file that is to be merged.---------------------------------------------------------><CFSETTING ENABLECFOUTPUTONLY="YES"><CFSET OUTFILE=GetDirectoryFromPath(GetCurrentTemplatePath())&"files\xx.doc"><CFSET SOURCEFILE=GetDirectoryFromPath(GetCurrentTemplatePath())&"rtf\xx.rtf" ><!-------------------------------------------------------If the file exists then delete the file from the server.---------------------------------------------------------><CFIF FILEEXISTS(OUTFILE)><CFFILE ACTION="DELETE" FILE="#OutFile#"></CFIF><!-------------------------------------------------------Read the RTF file into memory so that it can be modified.--------------------------------------------------------><CFFILE ACT

In CF10, is there a way to set the cache region when using cfscript query functions? For example:sqlString = 'select * from dual';qs = new query();qs.setName('testME');qs.setcachedwithin(createTimespan(0,0,5,0));qs.setAttributes('cacheRegion', 'users');  //This doesnt seem right? 

I enabled Windows authentication in IIS 7 for a site powered by coldfusion 10. After I logged in, a coldfusion page that dump all the CGI shows REMOTE_USER and AUTH_USER are empty.  The tomcatAuthentication has been set to "false" in server.xml. Does coldfuion10 support IIS Windows authentication? If yes, is there any document on how to configure it? Thanks.

Hi, I am running ColdFusion10 Enterprise and we found two of our sites vulnerable to the Chrome80 update for SameSite cookies. I have "Use J2EE session variables" checked and Session Cookie Settings set for HTTPOnly. The issue is our main site iframes this supporting site in and we get console message "A cookie associated with a cross-site resource at *Domain Name Here* was set without the `SameSite` attribute. It has been blocked". Since these are different domains it doesn't work. I am trying to find out if there is a way to set that SameSite value to "none" for the jsessionid cookie.  I tried a few things thru the Java and JVM settigs but nothing worked there and in fact actually hosed it up once and had to revert it. Any ideas/suggestions/solutions are greatly appreciated. Thanks. 

Hello,static files is not working in coldfusion when I remove enablecfoutputonly from cfsetting tag. Is there a reason for that? As showed below picture, jquery is not working. Is it a bug?   

Hi, I recently upgraded a CF10 Server to CF2018. In ColdFusion 10, ODBC queries to DB2 (CHAR) fields returned trimmed values. Now in CF2018 it returns the full char length and many comparisons to other tables in MySQL or SQL are returning empty. I was able to fix some by adding SELECT trim(fieldname)... But the server host many applications with thousands of .cfm pages; so it will be a dauting task to fix all those queries. I found a JVM argumment setting of "-Dcoldfusion.trim.dbresult=true" listed for CF11; but it does not apperas to be working in CF2018.Any idea if this can be enabled in a DSN or any other CF setting? Thanks!

Hi,  I am using ColdFusion 2018 and an Oracle 12c Database.   I would like to use LDAP to authenticate my users. As of now the users are being authenticated by their Usernames in an Oracle Database, upon logging-in their roles are checked to see if they have an adequate role and then they are made available different screens depending on their roles. I would like to do the same but within an LDAP authentication method. How can I do this ?  RegardsIQ

Hello,   We are using LDAP connectivity strings to connect to the database instead of using Hostnames. In the ColdFusion Admin settings page I am unable to find a place where I can enter this information. Is there any way I can do this ?   I tried entering the LDAP string in the Advanced setings page but it did not work. Or LDAP server settings are similar to the one shown below. LDAP Server : oid1.city.ca:389:636Context : dc=city,dc=caDBService: pctestD     I dont want to use LDAP directly on my pages as this may require a lot of modification. Instead I would like to define LDAP Database connectivity using the LDAP settings, please advice. ThanksIQ 

I created coldfusion applications in coldfusion developer version but when I moved the applications in Coldfusion 2018 Enterprise server, the applications don't work. Do I need to configure the Coldfusion 2018 Enterprise server?  If so,what do I need to do. I need your help. Error message:An error occurred while executing the application. Please try again or contact the administrator.

Hi dev, I'm using CF2018. Here I've tried to use writeToBrowser action in cfimage tag. It's working fine while run via webroot but it's not working ( Image disaplyed as blank in browser ) while I'm using virtual host. But both are having same code and running places or differnent. Here is my sample code:<cfimage action="read" source="C:\ColdFusion2018\cfusion\wwwroot\download.jpg" name="google" ><cfimage action="writeToBrowser" width='200' heigth='200' source="#google#" />Note : I did  console on image on the browser my test application & my virtual host application have same value in img tag like below.<img src="/CFFileServlet/_cf_image/_cfimg-5097624825542879602.PNG" heigth="200" width="200" alt=""><img src="/CFFileServlet/_cf_image/_cfimg2796608237126268946.PNG" heigth="200" width="200" alt=""> But webroot show the image virtual host not showing the image in browser.

Hi,Just installed CFBuilder 2018 on Windows 10 64bit. install correctly, builtin Coldfusion 2018 also installed correctly. the problem is when goto Data Source in CFAdmin, it does not let me configure MSAccess datasource. Microsoft Access is visiable in dropdown, when I press Add then it gives me this error line. "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources." it saying "ODBC Service is not running". when i goto windows services list there is not coldfusion services are available. not even ColdFusion Application. what should I do?

ColdFusion v11,0,10,300066Oracle v12.01.00.02Has anyone worked with setting up Oracle datasources utilizing Oracle Wallets?  cwallet.sso? Auto login.  I have successfully implemented it in Java applications where I am able to create and provide a set of properties to the JDBC connection method, in addition to some other configuration. The CFIDE Administrator Data Sources GUI does not appear to give me the option to implement Wallets.  Is there a way to configure them directly?  Any help would be greatly appreciated!Thanks!

Attempting to make the LockDown tool work with IIS_lockdown_silent.properties.txt.# Silent Properties file for Adobe ColdFusion Server Auto-Lockdown Installer# Web Server : IIS# Platform : Windows(All) I filled out all the parameters, such as SERVER_IIS=1SERVER_APACHE=0CF_ADMIN_USERNAME=[ my entry ]CF_ADMIN_PASSWORD=[ my entry ]SYSTEM_ADMIN_USER, domain ,pwdCF_USER_UNAME, domain. pwd, etc. When I run the program: ColdFusion_2018_Lockdown_WWEJ_win64, I am prompted to enter all of the parameters that are in the txt file. Question: Where should IIS_lockdown_silent.properties.txt reside when I run ColdFusion_2018_Lockdown_WWEJ_win64.exe? and how do you execute the program to use the parameters? Thanks!Bill R.  

Hello, all, For the last several months, I've been working on code that was written many, many moons ago by someone who left for greener fields back in 2013 or 2014.  It is chock full of one of my pet-peeves: isDefined(). So, I'm cringing everytime I look at this code with isDefined() all over the place.  After several months, I've decided:  Every current CF dev at my work knows StructKeyExists() and even (like me) prefers it.  I finally decided to do something about it, and I'm sharing it for anyone who is interested. We use Dw, here, but this will work in any IDE that has a RegEx Find/Replace.  // Find and replace isDefined("{scope}. with StructKeyExists({scope}," FIND: isdefined\(\s*(['"])\s*(url|variables|server|cgi)\. REPLACE: StructKeyExists($2,$1 Of course, feel free to add scopes, I just used the four for brevity.  I hope someone finds this useful. V/r, ^ _ ^

Guys, I'm going to mark this one as solved. In reviewing a previous thread I launched on this, once again, I followed Nancy_OShea's advice from 2/21 to reset my DW preferences. And that produces a working DW site with DW's live view displaying my site properly. I was away from my computer for a week and a half, and my previously defined site was simply not there when I returned today. This, obviously, is a completely different issue. My apologies for not reviewing my previous questions/solutions on the forum so as to avoid unnecessary threads. Many thanks for your replies.John

Hello. I have updated Coldfusion 9 to 2018 on a Windows 2016 server with IIS 10 installed. For some reason I am now not able to access any of my pages. I get a 401.3 error. I have added IUSR, IIS_USR, Default App pool to the permissions of the folder of the page. Also I have enabled anonymous login as well and still get the 401.3 error. I am at a loss to what is different. 

Thanks to Charlie's blog and Pete's tweet, we have another hidden gem in ColdFusion (2018 release).  ColdFusion (2018 release) imports environment variables into the server scope. For instance, <cfscript> writeDump(server.system.environment) </cfscript> The snippet above returns a struct that contains environment variables. ColdFusion (2018 release) also imports Java system properties. For instance, <cfscript> writeDump(server.system.properties) </cfscript> The snippet above returns a struct that contains Java system properties. Pete has also documented these scopes in the cfdocs site.