ColdFusion

I have a search results page that lists part numbers that engineers have to work on, but I only want part numbers displayed on the results page that have a C and then a number after the C in the part number. How do I write this in the Where statement in my CFQuery? If I write Where Part_Number Like 'C%', it lists all the parts that have anything after a C in the part number like CBT-BGA. I want it to find only part numbers like this: C4560. I also tried this: Where Part_Number Like '^C[0-9]', but this doesn't show any results. Thanks for your help.

I am creating datasource wth ms-access driver it give following errorColdFusion 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.. please help i try following suggested by cold fusion support team still facing same issuePlease try the below instructions and let me know if it works: Step 1: Uninstall any existing “Microsoft Access database engine ” from add\remove program. Step2: Ensure that you don’t have any MS Access related data source defined in ColdFusion admin page(under Data Source). Step 3: Ensure that you have removed all the DSN entries from odbc administrator(both 32 bit and 64 bit under system DSN). 64 bit odbc path: C:\Windows\System32\odbcad32.exe32 bit odbc path: C:\Windows\SysWOW64\odbcad32.exe Step 4: Download and install 64 bit MS Access Database Engine from the link: http://www.microsoft.com/download/en/details.aspx?id=13255 St

Working on a new project that utilizes cfhttp to make a call to a remote site. The authentication to this site uses a unique account key that is passed in the url. This key is decrypted and passed in at the time of the cfhttp call. I'm able to make calls without any issues (get, put, post, etc) but upon reviewing logs(http.log and coldfusion-out.log), I noticed the account key is saved in plain text. I tried placing the key into a cfhttpparam as a type url but the log still reveals the same plain text key. I would like to prevent the key from being "stored/logged" anywhere for obvious reasons. Is there some way to modify the logging level? Any way to modify the logs if a certain string is found? Maybe some other method that I should use? I appreciate any advice.

Hi, I have a question regarding licensing/cores. Say, for whatever reason, ColdFusion 2021 was installed on an 8 core VM, but is only licensed for 4 cores (2 x Standard licenses). Is it possible to limit the number of cores CF uses by some mechanism other than reducing the number of cores the VM has? I'm thinking Java startup parameters, or something similar. Or is the only way to get CF to use four cores by reducing the VM core count to 4? Many thanks!Mike.

Recently I tried to upgrade colfusion 2021's JVM to newest version from 11.0.1 to 11.0.19. By doing that I get db connection error now. I am using aws Aurora db service. Any pointers please? Thanksexact error is :com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureif I point back to old JVM i.e. is 11.0.1 all works fine

Lockdown tool is stuck on "Change Permissions of IIS Website: ... Input Logs".  It also messed up the permissions on server webroot.  Files are now missing an owner.  Any insight would be appreciated.

I have an ADFS server acting as the IDP,  CF2021 update 5 using a simple SP setup running on RHEL 8/httpd. Oracle JDK 11.0.17, SELinux is disabled.  Signing and Encryption are disabled on the SP. SSO was working until I created a security sandbox around the code webroot.  I created a default  security sandbox around the web root, I started getting this error message:  "Invalid SAML Response. Not match the saml-schema-protocol-2.0.xsd" I enabled all Tags and Functions, "Other", and opened up the File/Folder permissions to absolutely everything, but it still fails. If I remove the security sandbox, it starts working again. coldfusion-out.log shows this: 01/31 10:26:40 [ajp-nio-127.0.0.1-8020-exec-3] WARN Error executing validateXML: schema_reference.4: Failed to read schema document 'bundle://5a95f7f4-292b-4044-9e7d-2bd1e4eb78ed_272.0:1/schemas/saml-schema-protocol-2.0.xsd', because 1) could not find the document; 2) the d

As the subject describes, optimizing PDF files yields the error message "The document could not be saved. Cannot save to this filename. Please save the document with a different name or in a different folder." and the file gets turned into a .tmp file. Optimizing the .tmp file and saving it to the previous name correctly saves it as a PDF, however, this wasn't necessary before. Due to the work environment, these files must stay within this folder and follow a certain naming convention that cannot be changed. Is there a reason these files keep converting into tmp files? Any help is appreciated. Thank you!

I am using this code amd works fine in my environment but when I try it in different CF 2018 environment is giving me an error the form,SAMLRespose  does not not exist. Any help appreciated. accountSettings = createObject("java","com.onelogin.AccountSettings");accountSettings.setCertificate(reReplace(request.company.getCertificate(),"-----BEGIN CERTIFICATE-----|-----END CERTIFICATE-----","","all"));// Generate an AuthRequest and send it to the identity providerb64Coded = createObject("java","org.apache.commons.codec.binary.Base64");xmlString = toString(b64Coded.decode(trim(form.SAMLResponse)));  

Anyone has run intot this cookies issue?Imagine I have these 2 subdomains ("www" and "test", as part of the ".foo.com" domain), like this:test.foo.comwww.foo.comIm having the issue where If a user logs in into a CF app hosted in one of these doamins it logs the user out of the app on the other domain. This I guess has to do with the CFID and CFTOKEN cookies that get saved on the browser somehow.I also noticed that there is a setDomainCookies setting for an app in CF, but setting it to true or false does not seem to do anything.Amy ideas what to do in this case? Is there a way to tell CF that it should handle cookies for one subdomain independently of any other subdomain (or main domain)???

We have encountered an error which we have tracked back to the Progress JDBC driver for SQL Server.  This Progress KB post describes the error exactly: https://community.progress.com/s/article/exception-thrown-when-retrieving-multiple-large-result-sets-using-sql-server-jdbc-driver-6-0 The timing, along with Charlie Arehart's presentation (https://www.carehart.org/presentations/Hidden%20gems%20in%20CF2021.pdf - see slide 38) indicates that the 6.0.0.000367 release is probably what we have.  (If someone can tell us how to find the actual version number... please pile on) The progress article indicates that the problem is resolved in  6.0.0.000381 (or later).  We can't download this directly from Progress without a Progress login, so... how do we get the updated driver?

I'm trying to read a page with cfhttp and extract code from it using #find. I've done this before and it works fine. The problem is that the page I'm trying to read has lots of embedded AJAX mechanisms — when I use my browser's "inspect" function on particular attributes I can see all the code, but when I simply say "show page code" (or use cfhttp) I just get the top-level static code without the sub-components that load when the page loads (the code of which are visible when I select elements and click "inspect" using the browser's debug tools). Is there a way to tell coldfusion to read from a specific http location and load the entire file, the way a browser does, rather than just retrieving the top-level file and ignoring the javascript and other mechanisms that fill the page dynamically with code as it loads? Thanks in advance for anyone's help or advice. Jordan

I am taking over a codebase from another developer. The codebase is written using FW/1 4.3 and curently runs on Windows Server 2016 with ACF 2016. The current hosting account belongs to the developer, and will be shut down at the end of the year.I am testing setting up the clients site on a new install of the server and ACF version that they offer when opening a new hosting account, which are Windows Server 2022 and ACF 2021.I have setup the site in IIS and configured CF. A test site with a fresh install of FW/1 runs smoothly, but when I setup a site with the clients codebase in it I get this error:Exception occured before FW/1 was initialized Exception in onError cannot simultaneously fetch multiple bags (org.hibernate.loader.MultipleBagFetchException)followed by this error:Unable to create requested service [org.hibernate.engine.spi.CacheImplementor] (org.hibernate.service.spi.ServiceException) Error message: net.sf.ehcache.CacheException: Another CacheManager with same name '_ORM_d

As part of generating an XML document (using CFXML and ToString), we have a section for user comments. As it's user input, we have to treat it as potentially malicous so we wrap the user comment with<![CDATA[#userComment#]]>This doesn't cover the corner case of the userComment containing ]]> itself. So we tried to use replace to "escape" the corner case like so<![CDATA[#replace(userComment, "]]>", "]]]]><![CDATA[>", "ALL")#]]>This works in testing"Test ]]> comment" becomes "Test ]]]]><![CDATA[> comment" but when we use CFXML (and then toString), it seems that CFXML strips out the ]]><![CDATA[.Can we use the CDATA approach or should we drop that and just use EncodeForXML? More detailsCF Version: 2021 Update 6Code summary:<cfxml variable="xmlReport" casesensitive="yes"> ... <COMMENTS><![CDATA[#replace(userComment, "]]>", "]]]]><![CDATA[>", "ALL")#]]></COMMENTS> ... </cfxml> <cfset xmlStri

I am wondering if anyone has any ideas about this: I am trying to solve some sort of mail issue with ColdFusion 2016:The same message keeps appearing in the mail spool several times per minute.Nothing seems to be actively sending it out - it doesn't seem to be a scheduled task or a human doing it. I have no idea what could be causing this. If it matters, the mail is being sent via a Google Workspace account and does make it to its destination - repeatedly.I have tried restarting the server but the problem still lives on. I'd emphasize that it seems to be one particular email that was originally generated by ColdFusion...and if I go back to the source and change the code for the email/text of the email, it doesn't actually change the email that keeps appearing in the mail/spool directory.

Hello, I'm on Coldfusion 2021. When I try to load a pdf from a cfdocument it doesn't see the CSS at all. The thing I'm exporting to it has a lot of div in it, and the format is always wrong. Does cfdocument not work at all with CSS or is there a hot fix for this? Thanks,Chad

After the upgrade to CF 2021 Enterprise, when we attempt to unzip a file we are getting a new error message I have not seen before: "Exception while extracting 69_campaign.zip: Uncompressed contents cross maximum permissible size of 405.52734375 KB" The file is only 41526Kb in size (small) and the import routine worked perfectly BEFORE the upgrade. I can find no info on this error anywhere - help?

Seems there is a cache stuck somewhere that has old database fields.  For example, it keeps telling me I am missing a PK called p_id.  That is an old field that does not exist any longer the DB. ```Incomplete primary keys provided.The table you are attempting to update, products requires the following primary keys ('P_ID,RECORD_ID,'). Ensure that all the primary keys are provided in the form.``` I can simply change the name of the table and everything works fine. So Coldfusion has to have that table metadata cached but I have tried everything to clear it out and I cant find anywhere to completelty wipe out that metadata. Anyone ran into this and have any suggestions?

Hi all, I test the use of access="package" in a cfc function and it doesn't work, although I do exactly what the documentation says. It says that1) cfcs in the same folder are considered a package and2) a func having access="package" can be accessed by the functions of the all the other components of the same package (folder). Please see the simple code below. All 3 files are in the same folder.When I call  index.cfm  I get the message "Variable CFC2FUNC is undefined" <!--- index.cfm ---><cfobject name="oX" component="cfc1"><cfset x = oX.cfc1func()><cfoutput>#x#</cfoutput> <!--- cfc1.cfc ---><cfcomponent><cffunction name="cfc1func" access="public" returntype="string">    <cfset local.ret = cfc2func()>    <cfreturn Ret></cffunction></cfcomponent> <!--- cfc2.cfc ---><cfcomponent><cffunction name="cfc2func" access="package" returntype="string"&

I have a table with the column StatusSubStr char(2)In it are many instances of "00"I want it to print in a table cell with another string from the tableStatusStr char(2)which contains either 1 or 2 number characters#FQ.StatusStr#.#FQ.StatusSubStr# prints as an example 1.01 or 1.10but when StatusSubStr = "00"it prints 1 or 2it only prints the string StatusStrThey were both integer fields in the database and I tried every kind of cast and concatenation I could find doing them both in mariadb before returning the results and in Coldfusion with the results.  I finally changed the database to char(2) on both fields with alot of confidence that it would work.  I filled all the StatusSubStr directly with "00" because some were null, and with lpad(statussubstr, 2, "0") so that the field has every record filled with 2 characters.  And cold fusion still refuses to print the string "00".  Any help would be super appreciated.  This piece should have taken me

We are running CF2021 2021,0,04,330004 on Centos 7.9.I jsut started noticing extra character in the subject line. I'm not sure where its coming from, I tried to use all combinations of cfmail - script and tag, with subject being a variable and hard coded string. I added the utf-8 to the cfmail without any change. cfmail( to = "me@example.com", from = "them@example.com", subject = "Example email" ) { WriteOutput("test") } savecontent variable="local.mailBody" { writeDump(now()); }; variables._mailto = "me@example.com"; variables._mailfrom = "them@example.com"; variables._mailsubj = "Example Email"; local.mailService = new mail( to = variables._mailto, from = variables._mailfrom, //subject = variables._mailsubj, subject = "Example Email", body = local.mailBody, type = 'html' ); local.mailService.send(); mailerService = new mail(); /* set mail attributes using implicit setters provided */ mailerService.setTo("me@example.com"); mailerService.setFr

I am not sure if anyone is old enough to remember Coldfusion 9? I need to come up with a tactical plan to remediate a security issue with an enteprise app using Coldfusion 9, wrapped in .Net running on Server 2008.Have a strategic plan however need to buy 24 months for it to be in place and the tactical is to try and re-deploy it to server 2012 or 2016 with as little code work as possible.I understand that only 2008 is supported for CF9 however has anyone tried deploying it to Server 2012 onwards? What issues are encountered? Any help would be appreciated.

After applying update 16 to our Coldfusion (2018 release) server, the remains available externally but CF Admin is inaccessible, with a "The Cron service is not available" error.  Looking through other threads, I checked neo-cron.xml and does not appear to be corrupted, and I tried replacing it with the pre-update file with no result. Uninstalling the update returns CF Admin to an accessible state. Error text is:The Cron service is not available.This exception is usually caused by service startup failure. Check your server configuration.The error occurred in Application.cfm: line 105
Called from Application.cfm: line 89
Called from Application.cfm: line 4
Called from Application.cfm: line 1
-1 : Unable to display error's location in a CFML template.Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.BrowserMozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) l

CF:2016 | IIS10 I know this is a little more of an IIS question, but wondering if anybody can advise I need to put keywords into a URL without using actual variables and then redirect and collect the keyword Example:https://SomeWebSite/discount1 The folder discount1 does not exist and that is the keyword I need to detect on a CFM page. I guess I could set up a redirect on 404 errors, to go to a CFM page, and then use CFM to pick up the refer information and then find the word in the URL. After typing this I tried it out using a redirect in IIS for 404 errors, setting it to removed with a 302 redirect to an absolute URL, a CFM page. In the CFM page I displayed the HTTP_REFERER only to see that it was blank, so it's not passed on and therefore I can't extract the discount1 at the end of the URL I'm wondering if anybody knows how to retain the original URL or how I should do it so that it actually works. Thanks  

Hi , Can you please help me with this error mentioned below : The description for Event ID 4 from source ColdFusion 11 Application Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event:ColdFusion 11 Application Serverthe message resource is present but the message is not found in the string/message table