The official community for ColdFusion.
Recently active
I have a CFC method that uses a cfscript to define a structure that is initialized with details from a query and used to create an HTML output which is saved using <cfsavecontent>. The compressed html struct is then returned to the calling AJAX to render the output on the screen. I cannot post the code because of company policies but the url looks something like this : http://appurl/componenetName.cfc?method=methodname&returnFormat=json. Now during a security testing, the person replaced the json with 'abc' and it throws an invalid Return Format - which is totally acceptable, but - I want to show a general application Application error instead of the CF error. How and where do I catch this error? Will a cftry and cfcatch work? I tried defining error in the ajax call but I still get the error. I tried to use if,else to see if no input is passed to throw the error, but that still doesnt change the invalid returnType. Any help on this will highly apprecia
Guys , i have a coldfusion 2016 website running over IIS 7.0 . I want to ensure it is not suspitble to HTTP smugllingi want to enable HTTP 2 to resolve this issue .. Question : what all places i have to make changes to enable HTTP 2 ?1. IIS2. is there any setting in coldfusion 2016 process as well to enable HTTP 2? below is some reference material on what HTTP smuggling is :http://projects.webappsec.org/w/page/13246928/HTTP%20Request%20Smugglinghttps://www.youtube.com/watch?v=PFllH0QccCs Thanks
testing my post
1) I installed IIS with ALL features and subfeatures; 2) I created the hosts generic.lab and api.generic.lab in hosts file then I created the sites (one for host) in IIS using defaultAppPool:a) the generic.lab was located in D:\websites\generic.lab\wwwrootb) the api.generic.lab was located in D:\websites\generic.lab\SubDomains\api 3) I installed ColdFusion 2018 developer mode in C:\ColdFusion at port 8594 with ALL features and ALL updates (from 1 through 10), then I ran the IIS_connector.bat in C:\ColdFusion\cfusion\bin\connectors; 4) I enabled the “Allow REST Discovery” in ColdFusion Administrator > Server Settings > Settings > API Manager Section; 5) In api.generic.lab site, I wrote the web.config:<?xml version="1.0" encoding="UTF-8"?><configuration> <system.webServer> <httpProtocol>
1) I installed IIS with ALL features and subfeatures; 2) I created a host "api.generic.lab" using hosts file located in C:\Windows\System32\drivers\etc then a website "api.generic.lab" in IIS using DefultAppPool; 3) I installed the ColdFusion 2018 developer mode with all features in "C:\ColdFusion" and at port 8594, then I ran the IIS_connector.bat located in "C:\ColdFusion\cfusion\bin\connetors"; 4) I installed ALL ColdFusion updates (from 1 through 10); 5) In ColdFusion Administrator > Server Settings > Settings > API Manager Section I've checked "Allow REST Discovery" option; 6) I configuerd the web.config this way:<?xml version="1.0" encoding="UTF-8"?><configuration> <system.webServer> <httpProtocol> <customHeaders> &nb
I created a login page then using .cfm page to save the data and redirect the page to main site. We are going to use subdomain page for marketing and I have everything else going. I just can't keep user logged in when the redirect to the main site. I think the main site might be issue since its using javascript and php on main site. Here is the subdomain as well. https://2020.hotonhomes.com/landing.html Any ideas?
I have problem when trying to output characters like (⇒) (≈) (♦), Chinese words etc when using CFDocument. These characters were gone in the PDF output result. What is the better method to solve this issue.
Hi I was referred here by the Chat help.We seem to have issues with large spikes in response times and corresponding drops in traffic and as the JVM virtually hangs. This seems to be happening at “coldfusion.server.j2ee.pool.ObjectPool:checkIn” “coldfusion.server.j2ee.sql.pool.JDBCPool:checkOut “ and “coldfusion.sql.CFDataSource:getConnection” which can take a ridiculous amount of time. Our Data Centre people are adamant that there is nothing wrong with the Oracle Database (10g) side of things. JVM restarts can on occasion help, but not always. We are running CF10 HotFix 8, JAVA 1.7.0_60, with Apache 2.2.27 underlying.Response time vs call drop off.This reflects in very slow connection requests: We see a variety of timed_waiting and blocked threads during this time but nothing that indicates the source issue, with most being blocked on “coldfusion.server.j2ee.pool.ObjectPool:checkIn” Pool setting are as follows from CF Admin: Any advice on possible causes/solut
Our group has set up a ColdFusion Admin on a remote server. I have installed CF Builder 2018 on my PC. I am trying to connect to a SQL database which has been mapped on the remote server. I am in the RDS Dataview to access the data. I get an error 'Premature EOF encountered'. Is it possible to access the data on my PC from the remote server? What am i missing.
Trying to find a matrix or anything that describes which CFTAGS have equivalent CFSCRIPT counterparts? I was under the impression that all tags in 2016 have cfscript counterparts, however CFCONTENT and CFHEADER do not seem to have cfscript versions? A list of what is or isn't supported in cfscript would be ideal.Thanks.
Coldfusion Session Timeout:Been reading through numerous posts regarding this.sessiontimeout and how to adjust it depending on who/what is running. For instance, My users log in, and I want their sessions to end in 10 hours (I know, but I have people who don't do anything for hours and don't want to have to log back in). I have a program that runs, and I need those sessions to end in 5 seconds of inactivtity (or I end up with hundreds of sessions showing up on fusionreactor). Reading through the various articles, I'm getting mixed messages.So, my question....If I invoke a remote CFC from another server, it creates a session. If I put at the top of the Application.cfc<cfif findnocase(ListLast(CGI.SCRIPT_NAME, "/"), "Viewall") gt 0> <cfset this.sessiontimeout = CreateTimeSpan(0,0,0,5)> </cfif> Did I just set the sessiontimeout for EVERYONE or just for that "Viewall" call?REALLY, thank you for your time.
Guys,I'm using the CFML event gateway for asynchronous which works as discribed, however, within the listener cfc I cannot access my application's CFCs as they are not within the Coldfusion /cfusion/wwwroot folder but rather in a different directory. How can I reference an existing CFC within the context of the gateway CFC
For YEARS have used same CF11 development server and no problems. Suddenly I am getting a License error. License Error.You tried to access the Developer Edition from IP address (xx.xx.xx.xx). Already two IP addresses are accessing ColdFusion concurrently. The Developer Edition supports access by any IP address, but only two at a time, apart from the localhost. The additional IP addresses accessing ColdFusion are: 107.178.239.218,185.220.100.249 I have tried everything to reset CF. Restarted the service. Rebooted server. Cold booted. I have also added these to IP addresses to IIS forbidden IP's. I have not changed the server at all. No upgrades. My single scheduled task on same server has stopped working.
CF code formatting seems like a very basic feature for a code editor, but I can't seem to find/enable it in ColdFusion Builder. I would think such a basic and useful feature that was available in Dreamweaver CS3 would be included by Adobe. The HTML and CSS formatters work great, but I wish they would implement it for CF code. Am I not seeing it, or is it missing?
I have little experience with application.cfc files. I've used only rudimentary functions without really understanding, as long as I got the needed result.Today, I want to do something that I'm finding it hard to find answers for, and I know, for some, this is child's play. I'd just like you to share a word-based description of what I need to do. Once I understand it at a high level, and know which functions to incorporate, I can learn what I need to.As I hope the following diagram illustrates, when my user arrives at the root of my site, I want them to see the page contents. Anything they click will take them to another page in another folder. All requests will go to various files in the same folder. It's at this point, before a new page opens, that I want to test whether the user is logged in, or whether they need to create an account. All users must have an account.If the user is logged in, they need to proceed happily along to their requested page.What I don't want to do is push a
I have 4 seemingly identical servers running Windows Server 2019 and ColdFusion 2018 (on IIS10). I recently ran through the drill of applying the latest CF updates, starting with Update 4 and then Update 10 (which was cumulative). On three of the servers, this went fine - after Update 10, I had to run wsconfig and "Upgrade" my connector for IIS, and everything ran fine after that. But on one server, when I go to run wsconfig after Update 10, I get an error in the DOS-style window that starts with "java.io.IOException: Cannot run program "ExecuteAppCmd.exe": CreateProcess error=2, The system cannot find the file specified", and then a long java trace, and the wsconfig dialog does not list my connector (even though it's there and running). And if I try to "Add", I get a message saying "All the IIS sites are already configured by some other version of ColdFusion". The first time through, I ended up recreating my site in IIS and reinstalling CF2018 to restore m
Hello,I would like to retrieve the index of a record that has just been inserted.<CFQUERY name="Com_impr" datasource="#session.dbname#"> INSERT INTO Impr_commandes (SiteName, ICImp_ID, ICClient_ID, ICLivre_ID, ICProd_ID, CDate_crea, ICQuantite ) VALUES ('#SiteName#', #Impp#, #get_Clients.Client_ID#, #get_Livre.Livre_ID#, #get_Prod.Prod_ID#, '#DateFormat(now(),"dd/mm/yyyy")#', 1 ) SELECT Scope_Identity() AS [IC_ID]; </CFQUERY>This buggy!Is this the best method?Thank you in advance for your help.
Hello, all, I'm working on some legacy code, and the original developer was manually setting a "last modified" date on documents he worked on. I learned that there is a programmatic way of doing this, and I'm trying, but the value returned is 0. <!--- I got this from Pete Freitag's blog. ---> <cfset thisFile = CreateObject("java","java.io.File") /> <cfset thisFile.init("" & cgi.script_name & "") /> <cfset lastMod = thisFile.lastModified() /> <cfset lastMod = DateFormat(DateAdd('s',lastMod,"January 1 1970 00:00:00"),"mmmm dd, yyyy") /> Last mod is reporting as January 1, 1970, which means that it's 0. Please advise. V/r, ^ _ ^
Hello,I'm running CF 2018 in Developer mode on my local PC running Win-10 64-bit. Over the past year, I've created several server instances on the Coldfusion Server, and I've had no problem, other than that a couple of them have required periodic restarts. Recently, one of them failed to start at all. As I dug into it, deleted the server instance and attempted to create it anew or create other server instances, I discovered that I can no longer create a server instance that will start and run. FWIW, this is true whether I select the option to create a Windows Service or not. I've opened the Windows Event Viewer, and I don't see anything that would point me toward a solution. But I have little experience at interpreting server logs.I'm wondering if it might work to delete CF 2018 from my C: drive and install it on a different drive.Or, as I hope, is there a simple fix for this?Thanks!John
I can see my license key in my account but i cant find anywhere i can download old products i have purchased?
I am tasked with upgrading from ColdFusion11 to ColdFusion 2018.I have installed the 30-day trial version of ColdFusion 2018, it's patched to the latest update.I am having an issue with CFChart, specifically the URL attribute/parameter.The onClick SEEMS to be calling something client-side, and then throwing an error ("SyntaxError:Unexpected token <"), when, it should transport the user to the URL (the way it works, flawlessly, in ColdFusion11).I have no idea what else to report, to get help with this.I have made every attempt to find a solution, via Google, before posting here.Can anyone help?
I have this code for CF where i am trying to fetch the rows of the tables by minimizing the load on server <cfset var offset = 0> <cfset listoverloop = "users,roles,adresses,email"> <cfloop list="#loopoverLst#" index="k"> <cfquery name="local.sTotalRecords" attributeCollection="#variables.dataAttr#"> select count(1) as totalRecords from #table# </cfquery> <cfset local.offsetrequired = local.sTotalRecords.totalRecords gte 1000 ? 'yes' : 'no'> <cfset local.rowsTofetch = "1500"> <cfquery name="insertData" attributeCollection="#variables.dataAttr#"> SELECT * FROM #k# ORDER BY 1 DESC OFFSET #local.offset# ROWS FETCH NEXT #local.rowsTofetch# ROWS ONLY <cfsavecontent variable="createTt"> <cfloop query="insertData"> write my inserts <cfset local.offset += local.rowsTofetch> </cfloop> </cfsavecontent
Team, I am new member to Admin team. I have been tasked to upgrade all windows servers to CF11/patch 19. I do understand V11 is EOL. I need to understand if this would be a major lift planning for CF 2016? or CF2018 from V11. Because of some important seurity fixes and to familirie myself with product. planning on update going in next 3-4 weeks. I am keeping in mind other players involved in my env: Oracle current ver 12cMySql V 5.7PowerPDF v3IIS 8.5Java.... Thank you Jose DuenasLead Systems Administrator
Have the CFLOGIN and CFLOGINUSER tags been implemented in CFSCRIPT? I can only find one place (cfdocs) that seems to indicate it but nowhere in official Adobe documentation. I also can not find more than one example on the entire web of someone using CFLOGIN in script form. Can someone please help? (I am well aware of most people's dislike of CFLOGIN and that's probably why there is not more info on the matter.) Thanks!
I have a MySQL query that returns locations based on a computed column. I can apply a limit clause to the results, but I can't figure out how to apply a WHERE clause. The computed column is an integer, and I'd like the results to be less than a given number from the distance column, as in: SELECT MID,AptName,Address,City,State,Zip,ROUND((ACOS((SIN(#latitude#/57.29577951) * SIN(lat/57.29577951)) +(COS(#latitude#/57.29577951) * COS(lat/57.29577951) *COS(lon/57.29577951 - #longitude#/57.29577951)))) * 3963,2)AS distanceFROMtbl_mapsWHERE distance < 5.00 (the query runs fine without this line)ORDER BYdistance ASC; Any help appreciated.John
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.