Skip to main content

ColdFusion

The official community for ColdFusion.

10000+ Posts
Jdsplicer
JdsplicerInspiring
 Questions
scott.davey
scott.daveyParticipant
 Questions
cfhtmltopdfitem _LASTPAGENUMBER Not Working

Hey all. I have a footer in my PDF document and I'm trying to show "Page 1 of 2", for example.  <cfhtmltopdfitem type="footer" align="left"> <cfoutput> <body style="padding: 0px; margin: 0px; width: 100%; border-top: 1px solid ##000000;"> <p style="padding: 0px; margin: 5px 0px 0px 0px; width: 50%; float: left;">As of #dateFormat(now(), "mmm dd, yyyy")#</p> <p style="padding: 0px; margin: 5px 0px 0px 0px; width: 50%; float: left; text-align: right;">Page _PAGENUMBER of _LASTPAGENUMBER</p> </body> </cfoutput> </cfhtmltopdfitem> When I render the PDF, it shows "Page 1 of _LASTPAGENUMBER", so it looks like it's not getting a proper value for _LASTPAGENUMBER. I have also tried using: Page #cfhtmltopdf.currentPage# of #cfhtmltopdf.totalPageCount# But it outputs the same thing as above.

1681
scott.davey
D
dougg21886269Participating Frequently
 Questions
J
jfb00Inspiring
 Questions
D
Dordrecht7177366Inspiring
 Questions
"Prepared statement handle 1" error.

Hi, All.I'm running cf2021. Our application has been running smoothly during development for months, but we suddently got the following error message in the browser when accessing the site: After that, everyone else accssing the site got the same message. I'm seeing the following in the application log for the same times as the user attempts  (URL changed for privacy purposes):"The prepared statement handle 1 is not valid in this context.  Please verify that current database, user default schema, and ANSI_NULLS and QUOTED_IDENTIFIER set options are not changed since the handle is prepared. The specific sequence of files included or processed is: C:\inetpub\wwwroot\blabla\index.cfm, line: 55"I found comments at https://community.progress.com/s/article/Queries-with-ANSI-NULLS-ON-OFF-fails-with-SQL-Server-JDBC-Driver about this error, and it said it is related to SQL pooling. I looked at the advanced settings for my datasource (out of the box settings) and th

4590
D
F
faizank94658980Known Participant
 Questions
F
faizank94658980Known Participant
 Questions
F
faizank94658980Known Participant
 Questions
J
jfb00Inspiring
 Questions
B
BILL314613570ssyParticipating Frequently
 Questions
Coldfusion site can't be reached after changing fileExtensions allowUnlisted="false" in IIS 10.0

Hi,I am having issues with connecting to my ColdFusion website after changing  fileExtensions allowUnlisted="false" in IIS 10.0.   If I change allowUnlisted back to true, then the website works perfectly. Neither the IIS logs nor the ColdFusion logs show offer any assistance in debugging this problem.  There is a proxy if that matters.My web.config is shown below. (I have tried without the mimeMap settings and I have tried resetting the IIS connector)Any assistance would be greatly appreciated! Thanks!<?xml version="1.0" encoding="UTF-8"?><configuration><system.webServer><security><requestFiltering allowDoubleEscaping="false" allowHighBitCharacters="false"><fileExtensions allowUnlisted="false"><add fileExtension=".cfm" allowed="true" /><add fileExtension=".cfc" allowed="true" /><add fileExtension=".json" allowed="true" /><add fileExtension=".htm" allowed="true" /><add fileExtension=".css"

8182
Charlie Arehart
Community Expert
marks58765777
marks58765777Participant
 Questions
UPS REST API Issue

Hello, I am working on integrating UPS REST API and getting error message:{"response":{"errors":[{"code":"110609","message":"All package dimensions are required and each must be greater than 0 for package 1."}]}} This is my code:<!--- Get UPS Access Token Information ---> <cfhttp url="https://wwwcie.ups.com/security/v1/oauth/token" method="post" result="ups_authorization"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /> <cfhttpparam type="header" name="x-merchant-id" value="#UPSAccountNumber#" /> <cfhttpparam type="header" name="Authorization" value="Basic #ToBase64(clientID & ':' & secretKey)#" /> <cfhttpparam name="grant_type" value="client_credentials" type="formfield"> </cfhttp> <cfset ups_access_token_json = DeserializeJSON(ToString(ups_authorization.filecontent)) /> <cfset ups_access_token = ups_access_token_json.access_token /> <!--- Get UPS Shipping Rat

9091
BKBK
Community Expert
S
Simon37327989obueParticipant
 Questions
M
Manoj36229141q88dInspiring
 Questions
F
flyingmonkey1Inspiring
 Questions
New CF2023 Install on Linux Can't get CFLDAP to Work

I have a newly setup REHL 9.3-0.5.el9.x86_64 server. I have Apache 2.5.47 running on it. I installed CF2023 using the GUI installer and set it up with the Production Profile. I upgraded to Update 7 and then upgraded the Java to 17.0.11 and in the CF Admin I can see that it is running Tomcat version 9.0.85.0. In Apache I setup two virtual hosts and on my windows machine I edited my hosts file so that I can access both of those sites through a web browser on my local computer. I can access the CFAdmin just fine and .cfm test pages work fine. I am having problems getting the cfldap tag to work. I have setup many CF servers over the years from CF2008 until the current version and to get LDAP to work all I ever had to do was install some LDAP security certs into my java key store, restart CF, and then it would work. I have done that for my new server as well but I get an error on my test page “One or more of the required attributes may be missing or incorrect or you do not have permiss

8251
F
C
charlieCFParticipant
 Questions
J
John BlayterParticipant
 Questions
ColdFusion won't start in Docker Container

I am having an issue where the ColdFusion service inside of the Docker Container is not starting up. When I look at the Logs view in Docker Desktop all that returns is the following.  [] Checking server startup status...  This setup has been working for months and all of the sudden after the 14.5 update on MacOS it stopped working.  Chipset: Apple M3 MaxMacOS 14.5Docker Desktop Version 4.30.0 (149282)Docker Engine: 26.1.1 Docker Container Setup Script # variables cf_administrator_pwd=ColdFusion123 # Run the docker conainer docker run -dt --name mysite -p 80:8500 -v $PWD/www:/app -e acceptEULA=YES -e password=$cf_administrator_pwd -e enableSecureProfile=true --platform linux/amd64 adobecoldfusion/coldfusion2023:latest # Wait 10 seconds sleep 10 # Install All docker exec mysite /opt/coldfusion/cfusion/bin/cfpm.sh install all  When I look at the logs in the container I am seeing that ColdFusion is started /opt/coldfusion/cfusion/logs/c

7102
Charlie Arehart
Community Expert
Q
Quoc373044825aqjParticipant
 Questions
Q
Quoc373044825aqjParticipant
 Questions
M
mindf4rtParticipant
 Questions
Coldfusion Performance Monitoring Toolset Site unavailable available notifications

Hi, Every server I configure with the PMT (CF+PMT2021) it can't figure out the connectors, it has dubplicate entries for all connectors, once by ip, once by application name.It keeps switching over from ip to sitename connector constantly, and everytime it does I get an alert saying site unavailable, site available. This happens like 1000 times a day depending on the amount of connectors. I am fine with just ignoring this as everything seems to work fine and the PMT is just buggy I guess.The only problem I have is there is no option to disable these notifications, all alerts are turned off in every section on the nodes as well as the PMT alert settings itself. Anybody have any clue? <rant>It doesn't seem the PMT is used by many, as there are like 10 topics in total about it on this forum (2 of which are mine now, one on another account) and not properly updated by adobe as the 2021 PMT still says "© 1995 - 2020 Adobe. All Rights Reserved." It is also a pita to

4201
BKBK
Community Expert
A
Aleksandar34715023f1z9Inspiring
 Questions
Redirection for pages that no longer exist

So, hello again. On my website inside my root folder I had folders for some guides, however I moved them to another location. What I would need now is when they try to go to https://almarsguides.com/Aion/ , they are moved to https://almarsguides.com/Computer/Games/Aion/ . Because right now they will be redirected to page 404.  One important thing to note is that this should work for all guides. If let's say they go to https://almarsguides.com/Aion/professions , they should be redirected to https://www.almarsguides.com/Computer/Games/Aion/professions/ I will have to do this for other folders too, but this is the main idea. Is it possible to do this in Application.cfc because it seems that my htaccess doesn't work well?

23944
BKBK
Community Expert
Todd in Italy
Todd in ItalyInspiring
 Questions
Tasks in https on a SmartCard required server

Greetings,We have a ColdFusion 2021 installation on Server 2022 that calls all of its scheduled tasks via http://localhost. Now that we have implemented SmartCard login for the server, and set the server to https only and Client Certificate required, the tasks of course will not run. Any call to the server, even from localhost, will now require an https connection and must provide a valid certificate. I don't beleive the scheduler can provide that, though we could issue a soft cert for it and have it available to the engine if needed. Do you know of any guidance on how to do that?Alternatively we could run the tasks as Windows tasks, but it seems like the cfm files that contain the tasks scripts might need to be altered to run from the cf.bat in either cmd or powershell. It also looks like the cfms may need to be altered to run that way vice running in the browser. Do you know of any guidance for our developers on how to alter the cfm tasks to be run via cf.bat instead of via the brows

2061
Todd in Italy
phillipd88347257
phillipd88347257Participant
 Questions
Firewall Settings for ColdFusion 2021

We have recently switched from one Antivirus/Firewall app to Windows Defender for Servers.  I tried replicating our settings into Windows Defender Firewall to allow our ColdFusion Webservers to operate.  End result, our sites were unable to be reached. Can someone provide a complete list of Ports/Port Ranges that require access? Windows Server 2019 running ColdFusion 2021.  SQL 2019 backend.  Apache webserver.  Traffic comes in as HTTPS (443) to our primary firewall, then using a VIP is transferred to our Load Balancers.  The Load Balancers do SSL Offloading, so the traffic is forwarded to the ColdFusion server on HTTP (80).  I have Firewall rules for both 443 and 80 to allow access.  I also have rules to allow the SQL access using the specific ports we have designated in our Data Sources (Within CFadmin).Turning off the Defender Firewall allows the websites to work again, so I am apparently missing a rule or two.Thanks,Phillip

5161
BKBK
Community Expert
D
Doug_E_FreshInspiring
 Questions
P
paul_durrantInspiring
 Questions
pintuk86858408
pintuk86858408Participant
 Questions

Resources

Community Guidelines Help Center Learn tutorials
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices