Questions

I am trying to move a site that was on CF11 to CF2021 and there is an issue with moving the POI portion which creates excel files to CF2021. The first thing I did look for is to find the version of POI on CF11 (which is 3.12) and the version of POI on CF2021 (Which is 3.17).  The code that is giving me trouble revolves around coloring the foreground of cells.First the workbook is created: <cfset wb = createObject("java","org.apache.poi.hssf.usermodel.HSSFWorkbook").init()/><cfset fontRedUnderlineBold = wb.createFont()><cfset fontRedUnderlineBold.setColor(createObject("java","org.apache.poi.hssf.util.HSSFColor$RED").getIndex())><cfset fontRedUnderlineBold.setUnderline(1)><cfset fontRedUnderlineBold.setBold(true)> <cfset cellStyleCurrency = wb.createCellStyle()/><cfset cellStyleCurrency.setDataFormat(createObject("java","org.apache.poi.hssf.usermodel.HSSFDataFormat").getBuiltinFormat("($##,####0.00_);[Red]($##,####0.00)"))/>&l

Greetings all!In CF 4.51 the following validation code:"<INPUT TYPE="hidden" NAME="minPermSal_range" VALUE="MAX=999999;MIN=10000">"Produced the server side response if your field entry was invalid:*********************************************Form Entries Incomplete or InvalidOne or more problems exist with the data you have entered.The value entered for the Minpermsal field must be between 10000 and 999999 (your entry was 5).Use the Back button on your web browser to return to the previous page and correct the listed problems.*******************************************In CF2023 we get:*********************************************Form entries are incomplete or invalid."<ul><li>The range for the MINPERMSAL field ('5') must have numeric values. </li></ul> Go <a href="javascript:history.back()">back</a> and correct the problem."***********************************To begin with the validation message is incorrect the field in question is de

I am running CF2023 on IIS (moving from an older version of CF).  When I run the configuration tool, it adds two types things to IIS (several handler mappings and an ISAPI filter).  My question is about purpose/necessity the ISAPI filter.  If I remove it, everything seems to continue working as it should.  Let me explain why I want to remove it. The presence that ISAPI filter changes how 404 errors are handled.  When it is not present, all 404 errors are handled by IIS.  When it is present, however, CF handles the .cfm 404s and IIS handles the rest.  I am concerned aboout this for two reasons:  (1) I leverage 404 pages to do my own, in application URL rewrites.  IIS sees the 404, passes it to a template of my choosing, and I then process the cgi.query_string that is passed in.  I can, for example, call a URL that uses a slug (like wordpress does).  My 404 processor checks the slug against the database and calls the proper

Using coldfusion 10.Have a page which import data from a txt file to database. It was reading and importing perfectly earlier. Recently, it is showing request timeout after 10 minutes. Records expected to process was around twenty thousand. File had no changes, so is that happening due to any server settings configuration changes?        

I have a situation where my site uses a Application.cfc file for error trapping. This by itself works fine. I now have some JavaScript I need to add to the entire application so the default would be to add it to Application.cfm but of course I can't use Application.cfm and Application.cfc. Is there a way to add the JavaScript at the Application level either in Application.cfc or some other way?

During installation of CF 2023 I didn't enable the PDF service since I didn't think I would use it.  Now I'd like to add it.  Does anyone know how to do this?  Currently when I go to Data & Services / PDF Service I get this:   Element ENGINE is undefined in THISPDFSERVICE I'm hoping I don't have to uninstall CF and reisntall it.  Thanks

Hi support,  can you help to identify the issue below? the error appears when the number of calls increases compared to normal activity.   Error count: 0 Bytes received: 1467 Bytes sent: 1939691 Free memory: 20162003096 Total memory: 20439891968 Active Sessions: 0""Information","scheduler-1","01/17/24","17:36:30",,"Max threads: 2500 Current thread count: 10 Current thread busy: 0 Max processing time: 350123 Request count: 58 Error count: 0 Bytes received: 1467 Bytes sent: 1939691 Free memory: 20161956776 Total memory: 20439891968 Active Sessions: 0""Information","scheduler-0","01/17/24","17:37:30",,"Max threads: 2500 Current thread count: 10 Current thread busy: 0 Max processing time: 350123 Request count: 58 Error count: 0 Bytes received: 1467 Bytes sent: 1939691 Free memory: 20161834128 Total memory: 20439891968 Active Sessions: 0""Information","scheduler-0","01/17/24","17:38:30",,"Max threads: 2500 Current thread count: 10 Current thread busy: 0 Max processing time: 350123

Hi,I know that this was question was asked in https://community.adobe.com/t5/coldfusion-discussions/cf-2018-auto-lockdown-states-the-server-is-not-running/m-p/12174409 but no answer was given.  I know that I ultimately figured it out but forgot to document it.When I run the CF 2021 lockdown tool I get the following error:"ColdFusion server is nor running.  Please start the server and try again." But Coldfusion's instances  (2) are running! the lockdown logs look like:2024-01-19 15:53:51 INFO - ColdFusion is not running. Please start ColdFusion using services and try again.2024-01-19 15:54:00 INFO - Path:d:\ColdFusion2021\lockdown\cfusion2024-01-19 15:54:00 INFO - LINE_DEBUGGER_ENABLED -> null2024-01-19 15:54:00 INFO - developer_enabled -> false2024-01-19 15:54:00 INFO - REMOTE_INSPECTION_ENABLED -> null2024-01-19 15:54:00 INFO - ajax_enabled -> false2024-01-19 15:54:00 INFO - robust_enabled -> false2024-01-19 15:54:00 INFO - FLASHFORMCO

 anyone knows what this error isError executing query : Unexpected EOF; was expecting a close tag for element <str> thank you

We migrated our Coldfusion 2023 Windows Server to a new server over the weekend, and "cfhtmltopdf" has stopped working.  It can generate a PDF fine and display it, but when actually trying to save it to the server, we get this:<cfhtmltopdfdestination="c:\filename.pdf"  source="http://#CGI.Server_Name#/filename.html" overwrite="true"></cfhtmltopdf> Jan 31, 2024 13:16:12 PM Error [ajp-nio-127.0.0.1-8022-exec-24] - Connect to 127.0.0.1:8995 [/127.0.0.1] failed: Connection refused: connect http://127.0.0.1:8995/PDFgServlet/Jan 31, 2024 13:16:12 PM Error [ajp-nio-127.0.0.1-8022-exec-24] - Error occurred while generating PDF. Not sure if this helps, but http://127.0.0.1:8995/PDFgServlet/ brings up: HTTP ERROR 400 Bad RequestURI: /PDFgServlet/STATUS: 400MESSAGE: Bad RequestSERVLET: PDFgServletPowered by Jetty:// 9.4.51.v20230217 The service for Coldfusion2023add-onservice is running, and port 8995 is open.   Any ideas/suggestions?

I am facing an issue while creating pdf using cfdocument tag where the content are Arabic characters. When I am printing the Arabic in web page(HTML) everything works fine, but when I put the same characters in pdf few ligature(joint letters) are missed out. I have added the code below which creates the pdf in the same location where the file is run and display the content on screen. I have underlined the characters on screen display, which are missed out while rendering the texts in pdf. Is this a bug in cfdocument? Any help is much appreciated.  <cfprocessingdirective pageEncoding="utf-8"><cfdocument name="TT" format="pdf" fontEmbed="Yes" margintop="1.1" marginbottom="0.5" backgroundVisible="Yes" pagetype="a4" orientation="portrait">اسم المالك<br>المبلغ المس&#1

Good morning, In order to be able to put an icon, I test if the file exists!   <CFIF fileExists ("#DIRV#")> <A href="../../Admin/_ebooks/Libre_Video.cfm"><img src="../../Admin/_Pictures/Video.gif" width="30" height="30" title ="Presentation Video" /></A> </CFIF> But since I'm in a loop, I'm going to get negative answers! Here is the error message:Security: The requested template has been denied access to /SoLivres/_Ouvrages/APED/Auteurs/IRLES/UNE_ENFANCE_PIEDS-NOIRS/Videos/UNE_ENFANCE_PIEDS-NOIRS.mp4. The following is the internal exception message: access denied ("java.io.FilePermission" "/SoLivres/_Ouvrages/APED/Auteurs/IRLES/UNE_ENFANCE_PIEDS-NOIRS/Videos/UNE_ENFANCE_PIEDS-NOIRS.mp4" "read")Thank you for your help. Bonjour,Afin de pouvoir mettre une icone, je teste si le fichier existe ! <CFIF fileExists ("#DIRV#")> <A href="../../Admin/_ebooks/Libre_Video.cfm"><img src="../../Admin/_Pictures/Video.gif" width

I'm getting this warning in the coldfusion-out.log everytime the application restarts. It started after I installed CF2021 update 12 on Centos 7.9. Using mod_jk connector. I've looked in this post: https://community.adobe.com/t5/coldfusion-discussions/weirdness-after-cf-auto-lockdown-tool/m-p/14111440, however I did not run the lockdowntool.Could someone please explain what this package is used for and is this warning something to look into closely? WARN [main] - Unable to determine dialect of the StAX implementation at jar:file:/CF_HOME/coldfusion2021/appinstance1/lib/bundleaxis/wstx-asl-3.2.9.jar!/ Thank you!

OK.  One last item to cure with respect to applicant searches.In CF 4.51 the collection for applicants was based on a huge folder containing .txt files.In CF 2023 the colleciton is based on a huge folder containg: .doc, .docx, .pdf & .txt files. The code that worked against the .txt file collection was.****************************values (#getCurrentSearchID.theSearchID#, #Replace( replace( URL, "/", "" ), ".txt", "" )#)****************************Basically, it stripped off the .txt part of the file name & the "/" that solr inserts into the value of URL> so that we are left with the file # to use in further processing.I have tried the following against the folder with the 4 extensions mentioned above.***************************values (#getCurrentSearchID.theSearchID#, #Replace( replace( URL, "/", "" ), (".doc" or ".docx" or ".txt") ", "" )#)***************************CF is not happy with my (".doc" or ".docx" or ".txt") construct.  Would very much appreciate an

So, on my website I have this code that works when it comes to sending an email to the website owner. This is from contact form. Somebody will populate stuff and send to the owner.    <!--- Send email after successful registration ---> <cfmail server="131.153.102.58" from="support@almarsguides.com" to="#form.email#" subject="Sample CF e-mail"> This is the body of a test email. </cfmail>  However, I want to make registration where user will recieve email to finish registration, however, this is what is happening.   <cfmail server="smtp.gmail.com" port="587" useSSL="false" username="AlmarsGmailEmail" password="TEST" from="support@almarsguides.com" to="#form.email#" subject="Sample CF e-mail"> This is the body of a test email. </cfmail>    I changed password here

Hello, I have recently installed cfmx 2023 but however I'm unable to access the admin page using the credentials I have provided via silent install. I have done two things here -->1. It first had localhost(default I believe) in allowedAdminIPList but then I have removed it and restarted cfmx.  so, now I can see the admin page(planning to restrict through in next phase but wanted to get somewhere) . However,  when I provide the admin credentials it gives me 4032.   later, I tried changing the admin.security.enabled from true to false. and I was  able to view the admin page without passing credentials. However, I believe thats not the right way and its a security risk.  I'm not quite sure what the issue is here. can someone provide any inputs on what could be the issue? Stack details:CFMX version : 2023OS : RHEL9Tomcat : 9.0.86JDK17 Thanks,Manoj

So, does anyone have a clue why coldfusion would return a different value from a mysql datetime?I've got a 4 hour difference. Is there some setting I'm missing? Orm or Query. This is bizarre.(Aside from cf adding in milliseconds of 0) Orm record: Database record: Query records: Database records:  

Does not seem to be a rhyme or reason to this, but every once in a while I getjavax.servlet.ServletException:Application v1 could not be found.The App CFC in the dir has the name component {  this.name = "v1";  this.applicationTimeout = createTimeSpan(1, 0, 0, 0); I saw some other answers that could be the application timing out, but it happens more than once a day.

Hi,We have functionality where we store a mapped pdf in AWS, then when we want to create a pdf with our own values, we read in the binary and use cfpdfform with action populate, then use cfpdfformparam to populate our values. This works fine but when we want to create a lot at the same time, we create them, add them to a directory then do a cfpdf action="merge" on that directory to get what we need. Dependant on the amount i'm getting timeouts if its anything around the 100 mark. Just wondering is there an alternative way of doing it. We're using CF2018. Is there anything in more recent releases which make life easier with pdf generation? Thanks 

Our website has been getting alot of direct calls to pages that require parameters that are hidden. The requests are missing the parameters and so the page fails since the parameter is not defined. I was going to just define all undefined parameters but that whould just hide the original problem of the site is being Hacked. I would rather log that the page was requested without parameters and then redirect the call to a "page not found" as if the page did not exist. I'm not sure how to accomplish this. Any Ideas or other solutions?

Hello Community!Recently we migrated to Windows Server 2008 and IIS 7. After that we have been receiving calls from our customers that once they get to the checkout button they receive a message: "The page cannot be displayed blah blah." After reading the reports from customers service, I detected a pattern in the errors: They all occur on our secure pages. Before blaming the servers or the users' browser, I want to make sure that I can do on my end, assume responsibility and try to make things better. Have any of you experienced some issues with IIS 7, SSL and coldfusion pages? Does anyone have been on the same situation? Do you have any thoughts to improve my code if the coding is the problem?Thanks! Ysais.

Hello,I am building a system where intranet users are allowed to drag and drop files into a div on our site, which after some validation will then automatically upload them to a file server. One of my requirements is: when the file which was uploaded is a .msg file (Outlook Email), extract any files which are attachments to that email and upload them individually.  I cannot find an existing solution to accomplish this online.The closest thing I found is this https://stackoverflow.com/questions/16473421/coldfusion-extract-information-from-a-msg-file  which is fantastic, as it includes everything I need except how to extract the attachments. I believe it is possible with the correct usage of the org.apache.poi.hsmf.MAPIMessage object. With the following code I am able to see each attachment object, and it's filename and extension. I just can't figure out how to save each object to the file system.  Any help is GREATLY appreciated!!<cfscript>&

Hi, Adobe writes: The JVM flag -Dcoldfusion.searchimplicitscopes will be removed in the next major release of ColdFusion, hence disallowing searching of an unscoped variable in the implicit scopes. This may require application code changes. We are currently on Coldfusion2021.  Does "next major release of ColdFusion" mean something like Coldfusion2025 or some other version than Coldfusion2021 and until we upgrade to that version we can continue to use the flag?

I am playing around with the the SAML SP and IdP configurations in CF2021.  I am using CF as both IdP and SP.When I call initSAMLAuthRequest() I receive the following error:coldfusion.util.KeystoreUtils$CertificateException: Errors found in the certificate at coldfusion.saml.SamlHelper.stringToCert(SamlHelper.java:779) I assume this error is related to the IdP certificate. This certificate is a self-signed certficate that was generated with the following command:openssl req -x509 -newkey rsa:4096 -sha256 -days 3650 \-nodes -keyout idp.key -out idp.crt \-subj "/C=US/O=IdP Test/OU=SSO/CN=test.internal" \-addext "subjectAltName=DNS:test.internal,IP:192.168.1.2" I used the Manual IdP configuration option and pasted the contents of idp.key  into the Signing Certificate box without the ----BEGIN|END PRIVATE KEY----- bits.  It looks like MIIJQg....Tnw== If I leave the -----BEGIN PRIVATE KEY----- bits in there then then I receive an error saying "The input string

Hello there. Me again 😛I have a website where I have a link https://whatever.com/membersDataNow, this folder membersData has other folders as well but the main point is that access to it should not be allowed. There should be a new page that is being shown each time somebody tries to enter and its IP doesn't match the IP of the website owner.  I would like to do this with Application.cfc or if it's not possible, do it with  https://whatever.com/membersData/index.cfm file inside. Keep in mind that index.cfm is always hidden in URL.