ColdFusion

While running getAll is cfimap we get the following error when we hit an email with a blank body and an attachment.http://localhost:8002/test/email_imap_test.cfm?folder=problemStack Trace java.lang.ClassCastException: com.sun.mail.imap.IMAPMessage cannot be cast to javax.mail.internet.MimeBodyPart at coldfusion.mail.EmailTable.getAttachmentName(EmailTable.java:795) at coldfusion.mail.EmailTable.populate(EmailTable.java:309) at coldfusion.mail.IMapImpl.getMails(IMapImpl.java:377) at coldfusion.tagext.net.IMapTag$1.run(IMapTag.java:647) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.tagext.net.IMapTag.handleRequest(IMapTag.java:643) at coldfusion.tagext.net.IMapTag.doEndTag(IMapTag.java:536) at cfemail_imap_test2ecfm1030837708.runPage(C:\Data\backofficeV2\www\test\email_imap_test.cfm:33) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTa

I have a page which displays some iamges and everything works fine.  When I use cfhtmltopdf to generate a PDF of the page some of the images are rotated 90 deg and others are rotated 180.  Most of the images appear correct, but as I say, some are rotated.  I get the same results if I use cfdocument. I have tried using style="image-orientation:from-image;", but that made no difference. Does anyone have a suggestion of what I might try?  Thanks

Having just recently migrated my intranet to CF2018 Enterprise (from CF10), I'm finding some weird behavior in my Excel spreadsheets.  I use SpreadsheetNew("true") to create spreadsheets and then directions like this to format the rows and columns:<cfset SpreadsheetFormatRow(s,{bold='true'},1)><cfset SpreadsheetFormatColumn(s,{dataformat='##.00'},13)>This ends up producing my first row all in bold (correct), my 13th column formatted as _.00 (correct), but then my 13th column also ALL in bold.  Basically, any column I apply formatting to ends up extending the row formatting all the way down.And if I do it in reverse:<cfset SpreadsheetFormatColumn(s,{dataformat='##.00'},13)><cfset SpreadsheetFormatRow(s,{bold='true'},1)>That part works, but in specialized cases where I've tried to bold particular cells (to highlight data), that instruction is ignored:<cfset SpreadsheetFormatCell(s,{bold='true'},s.RowCount,13)>No cells in column 13 are bold except f

I go to https://www.adobe.com/support/coldfusion/downloads.htmlClick on ColdFusion (2018 release) Downloadswhich takes me down the page where I click on ColdFusion (2018 release) - Developer Edition (Free)which takes me https://www.adobe.com/products/coldfusion/download-trial/try.htmlAdobe ColdFusion(2021 release)Start your 30-day free trialI have filled out the form and am able to download 2021; however I need to download 2018.  I have also gone to https://helpx.adobe.com/coldfusion/release-note/coldfusion-2018-release-notes.htmlwhich accomplishes the same thing as above.

In Adobe ColdFusion (2021 release), the mask D in date formatting functions, such as, DateFormat has been fixed to return the day of year. Since this can cause a few backward-compatibility issues, we've added a flag in jvm.config, the details of which are explained the KB document.   For more information on this behavior, see the following: Charlie Arehart's blog CF-4210921   For more information, see the KB document.   We'd like to thank Charlie Arehart for reporting this. Meanwhile, you can follow Charlie's blogs and on his Twitter handle.

Hello - I recently installed ColdFusion Standard 2018.  I tried to add an MS Access data source, but I noticed that the ColdFusion 2018 ODBC Server was not started.  When I try to start it, I see the error in the attached.  Has anyone encountered this?  Any suggestions?  I am not able to start the service.  Thank you.

I make the request to coldfusion api from .net core api as shown below Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); var httpWebRequest = (HttpWebRequest)WebRequest.Create("http://url"); httpWebRequest.ContentType = "application/json"; httpWebRequest.Method = "POST"; var jsonSeri_ = Newtonsoft.Json.JsonConvert.SerializeObject(_frmCustomerTicket); Encoding iso = Encoding.GetEncoding("iso-8859-9"); Encoding utf8 = Encoding.UTF8; byte[] utfBytes = utf8.GetBytes(jsonSeri_); byte[] isoBytes = Encoding.Convert(utf8, iso, utfBytes); string msg = iso.GetString(isoBytes); using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream())) { streamWriter.Write(msg); } in coldfusion api I get the request json as below<cfif cgi.content_type EQ

I added to JVM arguments -Dfile.encoding=UTF8 and application server service not starting.Here is the error. So is there a way to undo what I have done.  Because there is no way access to the Administrator panel.   

Hi all,While importing date value using cfspreadsheet tag, I am getting date in m/d/yy format although the XL sheet is having date in m/d/yyyy format.When I convert them using dateformat function the dates like 1/1/1925 ( between the year 1900-1929 read as 1/1/25 by cfspreadsheet tag) got converted in to 1/1/2025 for m/d/yyyy format which is incorrect. The issue is for all dates between the year 1900-1929. Rest of the dates are converting fine even though they are having 2 digits in year. EX: The date 1/1/1930 which got converted into 1/1/30 by cfspreadsheet tag on applying m/d/yyyy dateformat function got converted into 1/1/1930 which is correct. If any one has Idea about this issue please help. ThanksSunil 

Hi, Would really appreciate help with solving something that I am sure is pretty straightforward. I've got a form with a variable number of form fields, that I need to submit to a separate Coldfusion page to record the results in a database.  Basic stuff.  The number of form fields can grow to well over the permitted value of form fields that the server will allow, and I don't want to change that for security reasons. The form contains fields along the lines of :person1address1age1person2address2age2,etc ...where the number could be considerable depending upon the condition that generated the list of people, and as a result, with 3x the number of form fields per person, it has been known to push it over the limit. So my question is, is there a way of passing a large number of form fields safely?   I've read that JSON, or a combination of jQuery and JSON might be an option, but I'm finding examples difficult to come by.  I've had no expe

Goal: To have consistent behavior of handling form and URL scope variables as structures containing arrays, therefore, eliminating issues with comma-separated values. Form fields and URL query parameters can have the same names. If two form fields (or query parameters) share the same name, ColdFusion will concatenate their values, separated by commas, and assign them to a single key in the form scope. The same applies to the URL scope. Therefore, a user-submitted value that contains a comma can cause program flow issues/errors later on. Years ago, ColdFusion added "sameFormFieldsAsArray" as an application setting. This is great, but it is limited to only the form scope. It does not affect the URL scope which can also have multiple parameters with the same name. While trying to find a solution that works for both form and URL scopes, I found documentation on using getPageContext().getRequest().getParameterMap(). This is where I ran into the first issue. With URL

Note: ColdFusion does not support Big Sur. Before upgrading the OS, check the support matrix. Adobe ColdFusion Builder (2018 release)  and ColdFusion Builder (2016 release) are NOT COMPATIBLE with Big Sur. If you launch ColdFusion Builder on macOS Big Sur (macOS 11), it behaves unexpectedly and produces exceptions. We are working on making ColdFusion Builder to be compatible with Big Sur.  Meanwhile, you can review the current system requirements for ColdFusion Builder.

Hello, We are using ColdFusion 2016 Configured with IIS 10 With MicroSoft SQL server Being the Database, We use Fusion Reactor to Monitor Application Load,Application is Crashing When the Running Transactions :Web Request Exceed 25 and Goes down at 30 until a Restart is done, Is there a setting where we can increase the threads?Our Application is Internal and gets around 15-20 Requests every Minute.I have Looked All over but Didn't get the Answer, I am new to ColdFusion Administration Please guide me in the Right Direction.Thanks,SAI

Hi all. I've been running our application on ColdFusion 2018 locally with hotfix 9 installed, and ColdFusion 11 running on another server. The method below, despite the fact that it actually returns a string rather than the specified "boolean", has been running without error for a couple of months on both of these servers.<cffunction name="getFirstTwoIpOctets" returntype="boolean"> <cfargument name="ipIn" type="string" /> <cfscript> firstTwoIpOctets = ""; if (reFind("^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}$", arguments.ipIn)) { firstTwoIpOctets = listGetAt(arguments.ipIn, 1, ".") & "." & listGetAt(arguments.ipIn, 2, "."); } return firstTwoIpOctets; </cfscript> </cffunction>Yesterday, we set up a new ColdFusion 2018 server with hotfix 10. On this server, the erroneous return type of boolean now throws an error. Can anyone tell me why an error would be thrown on the new server and not t

Hi, I am calling a cf script via the command line and passing various parameters one being an aws url.  cf .\testScript.cfm cfpass=cfpassword dsnname=dsn_blaBla badparam=someUrl-staging.ctnszulukwoz.eu-west-1.rds.amazonaws.com It doesnt like parameter badparam. Wrap the string in quotes and it still doesn't like it. Take it out and hardcode it in the script and it works. I need to pass it in as a parameter though.  Anyone know what format will work here? Thanks

The last time I saw this specific question asked was many years ago. However, I was wondering if Coldfusion 2018 release could see a 32-bit ODBC connection with its ODBC Socket option? It seems 64-bit Microsoft programs like Power BI Desktop will no longer work (or see) a 32-bit ODBC driver unless you install the 32-bit version of the software. Can anyone confirm 32-bit ODBC support still in CF or better yet is anyone using a 32-bit ODBC driver in CF2018? Thank you.

We use CF Builder 3 and 4 on various machines at work. When one hovers the mouse over a tag, a little yellow popup appears to explain what the tag is for. The explanations are inane, and rapidly become annoying because the popup appears right over the top of what you are trying to see.I tried defining the settings in Window > Preferences > Java > Editor > Hovers to enable these only on CTRL-SHIFT to no effect. Perhaps I am staring right at an option in Windows > Preferences > CF > Profiles > Editor, but cannot seem figure out how to turn this "feature" off. We like using Code Assist, but intensely despise the silly patronizing yellow tag "help". Can someone please advise how to turn these off? Thanks in advance.

Hi,I am trying to create a Data Source for a Azure SQL database.  I am able to connect when I use the administrator username/password of the Azure SQL database.  But, I am told that it is not the most secure way to do things.  So, may be db_owner is good enough for this Data Source Connection.  I created a new login to Azure SQL database, create a new user using this login to the database and give db_owner permission to this new login.  From Management Studio, I can login with this new login and password.  However, when I set it up like this in the Data Source in ColdFusion 2016 Administrator, I got an error,  "The root cause was that : java.sql.SQLNonTransientCoonnectionExcept: [Macromedia][SQL Server JDBC Driver][SQL Server] Cannot open database "......" requested by the login.  The login failed;" If I were to use the administrator username/password, the connection will be OK.What am I missing? What is the "minimum permission" needed

Hi, Would anyone know why datasources created using setMSSQL aren't showing in CF Admin Datasource screen? They show when I call getdatasources() in a script but not in Coldfusion Administrator. Thanks

I have seen a few older posts that have presented this same issue, but there was no resolution in the thread.  I have posted on those threads asking if they found a solution, however thought I would present the issue myself and hopefully someone has a fix/workaround.CF10, W2008R2, IIS 7.5. Using a group with NTFS permissions and trying to limit the access to the pages.  Anyone can view the page if putting in a username and password in the Windows security popup, click ok and immediately prompted again, click cancel and you can see the page contents.  Tested with an html page and html page is blocked properly.  It is my understanding that IIS passes the control to cf, cf diplays the cfm page.  Since this is IIS 7.5, the checkbox for check if file exists that was working in IIS6 isn't there any longer, it is now items under Handler Mappings.  I saw in one thread dscussion about editing a wildcard mapping, but it was vague, and didn't have the settings I nee

hello community! I am creating a report with the <cfreport> tag, It sent a query by parameter. The problem occurs when any of the query data has some special character. For example: BİEM İLAÇ SAN. VE TİC. ACE. This is the result : B?EM ?LAÇ SAN. VE T?C. ACE.  How can I make the result correct?

Hi,I'm able to use CFcontent and CFheader tags etc. to generate a Word doc with dynamic data on the fly and such Word doc has several pages.  An issue is the last page has double headers and footers.  The following is the process:1) <cfsavecontent      variable = "WDcontent">2) Use Microsoft XML and Word style guide<html xmlns:o="urn:schemas-microsoft-com:office:office"      xmlns:w="urn:schemas-microsoft-com:office:word"       xmlns="http://www.w3.org/TR/REC-html40"> <head><style>p.MsoHeader, li.MsoHeader, div.MsoHeader    {margin:0in;    margin-bottom:.0001pt;    mso-pagination:widow-orphan;    tab-stops:center 3.0in right 6.0in;}p.MsoFooter, li.MsoFooter, div.MsoFooter    {margin:0in;     margin-bottom:.0001pt;     mso-pagination:widow-orphan;    

I have installed ColdFusion builder (CFBuilder) (v3.2.1) as Eclipse (v4.17) plugin and I see that the Quick Diff functionality does not work with CFML Multi Page Editor.I am using the Code Assist Dictionary Version as ColdFusion 2018.I am not sure if this a bug in the CFBuilder or I am missing something here?

Hi, I'm really hoping someone can help me.  Since recent CF updates, then SQL Server updates, both within a week, connection to db is broken and I can't create the datasource in CF Admin anymore.  I've reinstalled CF and SQL server mulitple times, but that didn't help. In SQL server I:  checked ports: All 1433, All TCP/IP. All set to 127.0.0.1I've tried mixed mode authentication and Windows.  Was using Windows authentication before and it worked fine. So, leaving it on Windows Authentication.  I checked firewall. I ran queries in SQL Server to see if I am the user of the db, I am. I've done more things, just can't remember them all.  A troubleshooting guide would be awesome.  But I don't think such a thing exists for ColdFusion. Here's the error in CF Admin I'm getting:Thanks in Advance...!  Connection verification failed for data source: Organizations2java.sql.SQLNonTransientConnectionException: [Macromedia][SQ

Hello    I am trying to hash a password with bcrypt algorithm (try to match password with an off the shell software), but I keep getting error, it works for algorithms "SHA-1", "SHA-256" etc...<cfset hashpw = #hash(password_from_form, "SHA-1")#>, <cfset hashpw = #hash(password_from_form, "SHA-256")#>   but  <cfset hashpw = #hash(password_from_form, "BCrypt")> don't work,  got error : The BCrypt is not supported by the security Provider you have chosen.   Is there no bcrypt algorithm in coldfusion hash function ?   Have been working on it over a week but without luck.   btw, I am using dreamweaver 8.    thank you so much in advance.