Questions

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

Hello, all, Got a doozy of a question.  One of the projects that I have been working on for the last eight years has many sub-sections, each isolated from the root; they all have separate application.cfc/cfm files.  Likewise, they were all developed at different times and in different ways.  As such, each also has a different version of jQuery, all of them out of date.  I'm tasked with updating all of them to jQuery 3.5.1.  I did just the root, so far, and it broke.  Searching Google, I believe the issue to be that I updated from an old version to the new without grabbing the migration 3.3.0 file and including it. My question:  If I update all the old versions (1.3.x, 1.4.x, 1.6.x, 1.8.x, 1.10.x, 1.11.x, etc.) will the current migration library work across all of them?  Is there anything else that I need to do?  Will including the migration library introduce vulnerabilities that were addressed in v3.5.1? V/r, ^ _ ^

Starting getting this error on the ODBC connection last week. [Macromedia][SequeLink JDBC Driver][ODBC Socket][TOD][ODBC][Unknown]OPTCHG: Option value changed ColdFusion has been running on this server without issue since 2015 and I can find any changes to the server that would have caused this.Simply query to a AcuXDBC connection<cfsetting requestTimeOut = "360"><CFSET SOURCE = 'CUSTOMER'><CFSET KEY = '12345678'><CFQUERY NAME="SHIPPED" DATASOURCE='#SOURCE#'>SELECT COUNT(*) AS SCOUNTFROM PUBLIC.CFDRNwhere PO_NUMBER = '#KEY#'</cfquery>

I am trying to get solr working on a new install of ColdFusion 2018. After spending hours searching the internet and the forums and I still don't know how to do what I need to do and I'm ready to give up. Doing this in Verity was so easy. I have several directories of XML files that point to specific pages in multiple huge PDF files. All I want to do is to search these XML files and pull back the page number in the PDF document. So, for example, I have a simple XML file like this: <records file="S_VN50701A.pdf"> <record><apn>002-0-080-215</apn><page>3</page></record> <record><apn>008-0-110-225</apn><page>5</page></record> <record><apn>008-0-140-050</apn><page>7</page></record> <record><apn>008-0-140-105</apn><page>9</page></record> <record><apn>008-0-140-140</apn><page>11</page></record> <r

We are pleased to announce that we have released the updates for the following ColdFusion versions: ColdFusion (2018 release) Update 6 ColdFusion (2016 release) Update 13 The updates fix bugs that were reported in the previous update release. We had previously released the preview updates of these releases. If you had applied the preview updates, you can retain the preview builds. You must however revert the update URL to the default one to receive future updates. IMPORTANT: If you will be using the Administrator interface to perform the update, note that you must first update to Update 11 for ColdFusion (2016 release) or Update 4 for ColdFusion (2018 release) due to a recent change in code signing certificate, which is used for verifying the download of the update.   These are mandatory pre-requisites before updating, unless you download the update yourself and apply it manually.   We also recommend that you upgrade the web server connectors after

Hello everyone, I'm currently having an issue when using cfgridupdate on a cfgrid, whenever I use it, all the columns are shifted by 1 (but not the headers). My code is almost identical to the one given in the adobe documentation of cfgridupdate (https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-g-h/cfgridupdate.html), so it should be working normally, but it's not. Here is below the code I'm using :<!--- If the gridEntered form field exists, the form was submitted. Perform gridupdate. ---> <cfif IsDefined("form.gridEntered") is True> <cfgridupdate grid = "FirstGrid" dataSource = "cfdocexamples" Keyonly="true" tableName = "COURSELIST"> </cfif> <!--- Query the database to fill up the grid. ---> <cfquery name = "GetCourses" dataSource = "cfdocexamples"> SELECT Course_ID, Dept_ID, CorNumber, CorName, CorLevel, CorDesc FROM CourseList ORDER by Dept_ID ASC, CorNumber ASC </cfquery> <h3>cfgrid Example</h3>

ı wrote a report at coldfsuion.now ı must sent old information to other company but at sql it is hide '20200817' now ı must add it HHmmss too.how can ı change all data at sql?ı can add random time too.what will ı add not important but ı must turn all data that format  "yyyyMMddHHmmss" anybody have any idea?

Fill out the form and it takes you to a 404.