The official community for ColdFusion.
Recently active
ColdFusion 2021 and cfhtmltopdf fail to correctly render a PDF that uses the SegoeUI font. ColdFusion Admin indicates the font is installed. The PDF is generated but there is no visible text. Inspection of the generated PDF indicates there are no embedded fonts. Code to Reproduce Problem <cfset fntPsName = "SegoeUI"> <cfsavecontent variable="pdfContent"> <!DOCTYPE html> <html> <head> <style> body { <cfoutput> font-family: #fntPsName# ; </cfoutput> font-size: 18px; color: black; font-style: normal; font-weight: normal; background-color: white; } </style> <title><cfoutput>#fntPsName#</cfoutput></title> </head> <body> <cfoutput> <h1>#fntPsName#</h1> </cfoutput> <!--- https://www.lipsum.com/ ---> <h1>What is Lorem Ipsum?</h1> <p><strong>Lorem Ipsum
Can the output of the analyzer be exported to a text file, or any sort of file? Thanks
Hi!I have an action file that creates a record with a hashed password: <cfquery datasource="#ds#"> INSERT INTO tbl_User(Email, RoleID, password) VALUES ('#email#', '#session.UserRoleID#', '#hash(form.Password,'SHA')#'); </cfquery>The password field in my new database record begins with "2879EA..."The next file in my registration process invokes a CFC method: <cfinvoke component="users" method="get" Userid="#session.UserID#" returnvariable="userData"> </cfinvoke>It sets the password variable using that query's results: <cfset password=Trim(userData.password)>And populates the update form: <tr><td>Password:</td> <td><cfinput type="password" name="Password" size="17" maxlength="50" required="Yes" value="#hash(Password,'SHA')# " message="You must enter a password." style="font-size: 83%;"> </td></tr> When I click the update button,
Hi,I have batch & js file which convert to word to pdf using cscript.exe.when I execute batch file directly it convert the files. But if call through browser using below cfm file I my coldfusion page never end the execution and no output files created.<cfexecute name="C:\Windows\System32\cmd.exe" arguments="/c #expandpath('./Word2PDF.bat')#" timeout="2000"></cfexecute>
I tried over the weekend to reply to https://community.adobe.com/t5/coldfusion/2021-odbc-agent/td-p/12216384, I click the post button, and nothing happens. I click it again, it tells me I'm flooding and need to wait an hour. Is it me? Thanks
I* don'[t have IIS locally (sadly) so I'm trying to define the default doc that opens when you click 127.0.0.1:8500. I want it to be default.cfm.Looking through tomcat docs I thought I found it at C:\ColdFusion2018\cfusion\runtime\conf\web.xml: <welcome-file-list> <welcome-file>default.cfm</welcome-file> <welcome-file>default.cfml</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> </welcome-file-list> But now it defaults to index.cfm (which I did not
Hello, Been digging through the docs the last few days and i'm about out of hair to pull out. I've been leveraging the zip file based distribution of CF2021, have it up and running without any aparent errors in the server on a Windows 2019 Server. However, when I go to utilize the wsconfig utility I get the following error and honestly, i'm just sitting here spinning my wheels trying to figure this out.>C:\ColdFusion2021\cfusion\runtime\bin\wsconfig Exception in thread "main" java.lang.UnsatisfiedLinkError: C:\ColdFusion2021\config\wsconfig\cfwin32.dll: Can't find dependent libraries at java.base/java.lang.ClassLoader$NativeLibrary.load0(Native Method) at java.base/java.lang.ClassLoader$NativeLibrary.load(ClassLoader.java:2430) at java.base/java.lang.ClassLoader$NativeLibrary.loadLibrary(ClassLoader.java:2487) at java.base/java.lang.ClassLoader.loadLibrary0(ClassLoader.java:2684) at java.base/java.lang.ClassLoader.loadLibrary(ClassLo
I've been trying for 2 days but it never downloads.I contacted support who advised me to call on Monday. I have 4 enterprise licenses for 2018 (under my business, not personal account) and I'm trying to do my due dilligence in justifying the upgrade in the face of cloud / IaC pressures so I need to know the upgrade path for POC, licensing, etc..But I can't download 2021 developer edition. I'm left with a phone number, a case number, and an open-ended task on Monday to so what anyone should be able to do - download a trial (developer) edition.
We have been having this issue for a while, and our hosting provider is unsure of it as well as the server has had Java and CF updates and patches, but it still occurs. We have looked at all of the online resources we could find, but can't find anyone else with a similar issue. We have a SIMPLE ColdFusion created CAPTCHA on our site and we notice that about 1 in 20 images has a UNIQUE character within the image. We have tried to narrow it down but the only thing we can determine is it is based on an 'Arial' font that is being used. Each time it shows up the unique character is different, so not always the 'r' or something like that. We have tried using ' fonts="Times New Roman" ' or another font, but that seemed to work for a while, but now anytime we specify the font, the CAPTCHA no longer displays ( not errors...but it ends the code at that point ). So we currently had to remove the font to get it to work. The character looks like a bunch of lines ' |||| ' so it is impossible to tell
Hello Community Members, I've written a query that generates Cross Tab or Pivot. Image Below. My Query is as followsSELECT * FROM(SELECT TOP(100) PERCENT production.Line_FK_ID,Lines.LineName,production.OP_FK_ID,Operations.OperationName,[Shift].ShiftID,[Shift].ShiftName,production.op_Time_From,production.ProductionFROM productionJOIN Operationson Operations.opID=production.OP_FK_IDJOIN Lineson Lines.lineID=production.Line_FK_IDJOIN [Shift]on [Shift].ShiftID=production.Shift_FK_IDWHEREShiftID in (1)and op_date in ('2021-07-08')Order by production.op_Time_From) ReportPIVOT(Sum (Production)FOR OP_TIME_FROMIN ([06:30:00],[07:30:00],[08:30:00],[09:40:00],[10:30:00],[11:30:00],[13:00:00],[13:30:00],[14:30:00])) As Pivot_ReportI want to make PDF report in which Production Line Wise for 6 operations for each hour. I am unable to Pivot the Hours Horizontly. The CFDUMP is as follows
Hi,Please be kind, this info is coming from one of our programmers, it's likely I will get terms wrong as I am a Blood Banker, not a programmer, hence my username. 🙂We are running CF 2021. We are trying to connect to an offsite Oracle database.When she tried to create the connection in Data Sources she got "The ColdFusion ODBC Server service is not running or has not been installed." In the pic below of IIS you can see the error when she tries to start it. Is there something I need to install too?Thank you!
I am wondering how framework one (fw1) making `view()` function available in views , like ColdFusion in built functions?. For example, in the below code , the `view()` function can be called like any ColdFusion in built functions. How fw1 making it possible?. #view(‘components/contact’)# The function `view()` has been defined in /framework/one.cfc
I am having difficulty locating documents for Terms and for the EULA for (2) no-cost Adobe Products (ColdFusion Builder and ColdFusion Report Builder). Adobe LiveChat just indicated I would have to reach out to the Adobe Community for assistance. Any help in obtaining these documents (or links) would be greatly appreciated.Thanks,Jeff
Hello, Due to a gigantic issue that Microsoft has said that they won't fix NTLM needs to be disabled in Windows environments. However it appears that CF only supports NTLM or BASIC authentication when integrated through IIS. What exactly are we supposed to do if CF hasn't been updated in 20 years to support Kerberos 5?
Hi,I have an application for which the final output is a pdf report about an applicant from a database of applicants.If I print the form just once, all the stylesheet formatting is applied correctly.If I try to loop through the database and generate multiple reports of multiple applicants, the styles and formatting get applied ONLY to the first report, and then the subsequent reports do not have any styles applied which of course makes them unacceptable.I've tried loading the stylesheet before the loop and inside the loop, no difference.The styles being lost are for divs and tables and cells. Fonts are handled separately by calling functions within the report which apply them on the fly.to text based on the section and type of output.Is anyone familiar with this problem? Is there a workaround? I really really really need this to work.Thanks,RIchard
I was wondering if anyone could provide some advise regarding an app that I've had on my mind for a while back but haven't been able to get off the ground due to being in full-time work. Anyway, I attended the CF development week and that revived my interest in developing my app further but I’m a bit unsure as how to progress and wondered if you have any suggestions or advice. Currently I can see four ways forward for me:- 1) Finding time outside of work to build on my original idea and develop a working prototype. This would mean I would have to learn CFML and programming to a more advanced level than my current knowledge and also find time outside of work. The upside being I would have developed my coding skills and would have the developed some the source code. 2) I raise the funds to hire developers to build the product for me. I imagine that this would be costly! However, not impossible. 3) I find a team of likeminded developers who find the project intere
Hey folks, We're experiencing a strange ColdFusion 8 Application Server service restart nearly 1 time per hour for the past week. The only thing we can find in the CF logs that looks like it may be the cause is a constant logging of this error in coldfusion-out.log:Content disposition corrupt: Content-Disposition: form-data; name=model In the Windows Server Application log, we see the following three items when the service restart happens. #1 (Error):Faulting application name: jrun.exe, version: 4.0.7.43137, time stamp: 0x47d93af8Faulting module name: ntdll.dll, version: 10.0.17763.2028, time stamp: 0xbf07433aException code: 0xc0000005Fault offset: 0x000a2af9Faulting process id: 0x2284Faulting application start time: 0x01d77e25459648a7Faulting application path: C:\ColdFusion8\runtime\bin\jrun.exeFaulting module path: C:\Windows\SYSTEM32\ntdll.dllReport Id: 9aa3cc7c-c480-40f7-b7b6-7a9383589c96Faulting package full name:Faulting package-relative application ID: #2: (W
Is there a way I can OPEN an MS Word document with CF? I don't want to CREATE one, but only open one that exists already (then let its Autoexec function do a whole lot of stuff with the document). Thanks. -Dale
I'm having problems with the cfsetup.bat tool included with the zip installer of CF 2021. On a clean install, updated to Update 1 and installed the following packages: caching, debugger, mail, scheduler, sqlserver, zip, I encounter some problems exporting and reimporting settings using cfsetup.bat. If I export METRIC using the command:cfsetup.bat export METRIC c:\METRIC.json c:\ColdFusion\cfusion And then immediately try to import it again with:cfsetup.bat import METRIC c:\METRIC.json c:\ColdFusion\cfusion It fails with the following error(s):ERR: Invalid setting key (cfstatHost) for category: (METRIC).ERR: Import of cfstatHost in METRIC is unsuccessful.ERR: Import of METRIC is unsuccessful.ExitStatus: FAIL Why would this be the case? The default for this setting was unchanged from "127.0.0.1" and I can clearly see the setting in the UI so I know this must be a setting somewhere... Additionally I have the same problems with the RUNTIME settings. Exporting those
Hi,When checking the box next to "Enable TLS connection to mail server" in CFadmin, no email will go out. It all ends up in the Undelivr folder. However, if I also include useTLS = "yes" in the CFMAIL tag, it works perfectly. I have CF Enterprise 2018. Anyone have any ideas why this is happening? I'd rather not be forced to find the hundreds of places I've used the CFMAIL tag and add useTLS. Oddly, from my Dev version of CF 2018, I don't have to include useTLS... and it's using the same email server. Thank you!- Shawn
I wrote my code in CF 2018 on my local dev environment. I had no issues with it in 2018. When I load the same code into CF 2021 Standard I'm getting an error when I try to move a file from one directory to another after reading it. Basic set up is I read the excel file and then move it to a different directory. The file gets moved but errors out on deletion. When I try to manually do anything to the file in Windows, I get a message that the file is being used by coldfusion.exe and cannot be deleted or modified. The only way I've been able to release this lock on the file is to restart the ColdFusion service. I tried waiting to see if it gets release but it didn't after 24 hours. Any ideas on how to get the file moved to a new directory and deleted from the original after I'm done reading it?
HelloI speak for my client, he is on Windows Server 2019 is on a license of Coldfusion 10.It is since a week he has this kind of message: Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Not enough space on temporary disk. Resources: • Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option. You have how to solve this problem.Kind regardsMichel
Hi,Suddenly, the Data Source that was working quit working for me in CF2016. The error is:I was following this post to set up DataSource. Below is my set up. It worked since Nov 2020. But, today, it quits working! The connection string is EncryptionMethod=SSL;Encrypt=yes;TrustServerCertificate=no;HostNameInCertificate=*.sql.azuresynapse-dogfood.net; I wonder if the "HostNameInCertificate" changed. I believed I got the HostNameInCertificate from an error message in CF2016 when I set it up back in Nov 2016. Any idea on how to solve this? Thanks! DChan
Could anybody provide a example YAML script that demonstrates how to take updated code and deliver it to a remote test server? I'm having trouble wrapping my head around what to deliver after a merge request. I'm completely new to GitLab and the whole CICD pipeline process, and the examples I'm seeing are for mostly builds of other languages. My process is as follows pull from develop edit code unit test with dev server commit changes push changes UAT merge request Thanks for any clarification you can offer on what commands would be used to automate this.
Now that I have PMT monitoring remote instances, I can see a few more questions that need answers. What we have is half a dozen separate instances of CF Ent 2021 running on an Amazon EC2 server,I am running PMT and datastore on my office server. Each CF instance is one separate web site in IIS to allow for application isolation. Here are questions I need help with: 1. In PMT on the Connectors page, I see no info for any of the instances being monitored. I see that connectors are filtered by Sites so ....2. Under Topology / Servers I see all my instances. But under Topology / Sites, I am not seeing any at all. It simply says no sites available. Which might explain why I also don't see any connectors? I assume if I can't see any connectors then PMT also can't autotune them.3. When I set an instance to enable datasource monitoring, it seems to pick up each of the unique DSN names in each instance, but does not show any data at all? No queries, nothing. Even if I change the
Remix with Firefly Community Gallery
Thousands of free creations to fall in love with and remix in Firefly.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.