Questions

I'm brand-spanking new to MySQL, using ColdFusion, and I'm having sporadic issues with queries on localhost. Sometimes they work, and sometimes they throw an error. If I reload the page executing a query five times, it might display the page correctly only one or two of those times. The execution times for the pages range from 5 to 15 seconds, whether there's an error or not. Works the same in two different browsers. The behavior is the same, whether I pass a username/pw to the database or not. Pages with no queries execute in the normal millisecond range.MySQL Server 8.0.13 Windows 64 bit ODBC datasource (AptMaps2), which is referenced from within Coldfusion administrator, where I created a CF DSN with a different name (AptMaps). ColdFusion2018You can see from the error text, even if the page sends back an error, the variable gets passed properly.I have no understanding why, but I suspect there is a problem in how I've configured my DSN. Thoughts?Error Executing Database Query. [Macro

Hi,I tried to run wsproxyconfig on Centos 7 and it's nothing happen. I execute this sudo sh ./wsproxyconfig.sh and after press enter and going back to prompt. Do you guys know how to configure websocket proxy on Centos 7 with web server is Apache/2.4.6?Thank you so much.

I have installed CF for many different versions for the past 20 years. To run under iis, I select JEE "External Server" This has always allowed me to run under iis server. The current installation file does the usual fork at 1) Standalone Server (which gives you a single server under the coldfusion directory structure, or 2) External Server, which has always allowed the cf server to run under the IIS server under /inetpub/wwwroot/[web site name].Choosing the External Server option, the install package drops me off with "Installation Complete." Then it tells me I "may now deploy Adobe Coldfusion 2018 to your application server."I do not get the usual dialog box within the installation routine that allows me to configure my servers (IIS). So, where do I go? What do I further install to get up and running? Help!Thanks!John

I am trying unsuccessfully to create a <cfgrid> (ColdFusion 9) with an initial selection and I can't seem to get it to work.  Note this could be none, some, or all of the rows.There doesn't seem to be an option to easily to this.  I looked at the selectOnLoad attribute, but that will only select the first element.I then looked at the onload attribute.  I created a JavaScript function but calls to ColdFusion.Grid.getGridObject('mygrid) are returning null in it. It appears that this is still too early in the process (although this seemed like exactly what I wanted).I then tried registering my own event listener with      ColdFusion.Event.registerOnLoad(initializeGrid,null,false,true);This seemed to be better. I could actually select my rows (and see the selection), but they were immediately unselected by what I assume was some sort of refresh at the end of the load. So this is close, but still doesn't seem to happen after the grid is completely lo

Ever since installing the ColdFusion 11 Update 15, my Scheduled Tasks keep refusing to work.I have to restart CF (during off hours) to get everything going again, but then eventually it stops again.Anyone else experiencing this?

During the Security in ColdFusion: A 360 degree outlook session at CF Summit this year, it was discussed that in CF 2018, there are exposed APIs for the Security Code Analyzer that allow for analyzing outside of CF Builder.  I am not finding documentation that explains how to access these APIs.  Can anyone point me in the right direction?Thanks,Jeff

I have an excel that I read and create a query object using this code<cfspreadsheet action="read" src="#theFile#" query="qData" headerrow="1" excludeHeaderRow ="true"  columns="9,15,51,56,57,58,59"   />So now I have a query object that I output and it outputs in the order that is in the excel.I loop through it like this <cfloop query="qData">and I get thisIDValue1Adams2Jones3Smith4Johnson5WilliamsNow I need to do the order in reverse like thisIDValues5Williams4Johnson3Smith2Jones1Adams  Can I sort by a loop? How ?

Hello.  I'm developing on a CF 2018 Developer version and I'm implementing EncodeForHTML.  However, when I tried to test it I found it to do nothing.  For example, the following test code from the help files gives me back exactly what you don't want:<cfscript>       s1="<script>";       s2="&<>'/" & '"';       WriteOutput(EncodeForHTML(s1) & " | ");       WriteOutput(EncodeForHTML(s2));</cfscript>When I run this it gives me;<script> | &<>'/"When it should give me<script>  | &<>'/" Is anyone else running into this?  It's like the function is turned off.  Is that possible?  What am I missing?I also tried it in cffiddle and it behaves the same way.

I have a query getNamesandRoles that will display the result as such     DISPLAYNAME   JOBROLE     X                          X does someting     Y                          Y does someting     Z                          Z does someting I want to display the result of this query in a table which is shown below, I can get to show the results with a loop or through explicitly calling the query as getNamesandRoles.displayName[1] and so on, but I can figure out how to loop thru the query in a way that would skip the first row where the ID (i.e. all the

We just upgraded our CF 10 Standard to CF 13 Enterprise over the weekend and are trying to hammer out some strange bugs.One example is where we are hitting a .NET web service which returns an object. When we try to execute the .getString() method on this object the value returned is "undefined":<cfset var recInfo = structnew()><cfset var schemaName = ""><cfset var theArray = arraynew(1)>     <cfinvoke webservice="#this.JobTicketWS#" method="GetSchemasNames" returnVariable="result" wsversion="1">     <cfinvokeargument name="inUsername" value="#this.inUserName#">     <cfinvokeargument name="inPassword" value="#this.inPassword#">     <cfinvokeargument name="inTicketID" value="#arguments.jobTicketID#"></cfinvoke><cfif result.getString() neq "">     <cfset theArray = result.getString()>     <cfset schemaName =

Hi, my code running on CF10 does not work as is on CF2018, although the code analyzer in the administrator didn't highlight any problems.Structfind() requires a string as second parameter. My code contains structfind usages where the key argument is numeric. In CF2018 this does not work anymore. What's the cure? A setting somewhere or tostring(param) everywhere??? Also, why doesn't it work anymore?Error: StructFind only supports UDFMethod or String(Key) as second argument as second argument.Regards,Peik

Hi,I have the instances server such as api\com,12368I can create the DSN with server and port # 12368, but with the instances: api/com didn't work.  I guess it didn't take the back splash  from the server.  What can I do?Thanks

I'm looking to get some hands on experience with Azure and AWS.Can anybody tell me if there are any gotchas that I should be aware of when trying to run CF2016 on either of these platforms?At the moment I am running on a cloud based system using VPS servers, the ISP has a great set of dashboard controlled features, for Firewall, load balancing etc, very easy to set up and use.I'm wondering if setting up in Azure or AWS would be as simple? Can I set up a VPS in the same way, install CF and roll with it, or is this going to be a very different and possibly challenging task?

Has anybody successfully published an Alexa Skill in ColdFusion.  In particular, I am looking for someone who knows how to get through the signature verification requirements.  Any help is greatly appreciated.  I have a number of skills in development ready to go, if I can just get this figured out.Thanks!

Unable to duplicate a ColdFusion Component. coldfusion.runtime.UndefinedVariableException: Variable APPLICATION is undefined.This error is flooding my logs and can not figure out what is causing it. Any ideas?

I am new to coldfusion and need some "guiding" on this matter.  I have a workstation with windows 10 and I have installed Coldfusion2016 as a .war file (cfusion.war, a JEE install option) in the webapps folder in apache tomcat 9.x directory.  In the following Coldfusion code, the Auth_User is blank and when I run my application I get error.<cfset ThisUser_Id = TRIM(UCASE(RemoveChars(auth_user,1,find('\',auth_user))))>What do I need to do to get value for "auth_user"?

cfspreadsheet seems to have an issue with .xlsx files generated by SQL Server Reporting Services 2016.If I try to run cfspreadsheet, I get the following error:OPC Compliance error [M4.1]: there is more than one core properties relationship in the package ! The spreadsheeet is nothing fancy generated from SQL Reports, just about 15 columns, no subtotals, etc...straight row by row data.If I create a new spreadsheet, and copy the data from the SQL Reports generated into the new blank spreadsheet, cfspreadsheet will work.Currently on ColdFusion 10,285437Anyone run into this before?  A bug somewhere in Coldfusion Apache POI routines?

Hello, all,About two years ago, we started having serious latency issues with our restricted portal.  Many of us spent weeks trying to track down what the cause was.  The rest of us were scrambling trying to optimize the portal as much as we could, in the hopes that we could speed up the site load times.  Part of this band-aid approach involved a custom-made News slideshow on the landing page.  Instead of grabbing four UUIDs, Headlines, and images on every page load, we set up the application.cfc so that every two minutes the query would run and store the UUIDs, Headlines, and images into application variables, and pull from those.Naturally, I placed an exclusive CFLOCK around the process in the application.cfc.  But we are using a separate include for retrieving the images on page load, and part of that is using CFHEADER/CFCONTENT to serve up the images, passing an ID in the URL scope.  This reduced the page load time by only a few seconds, but it helped.

Hi!​​I'm having an issue with joining/merging two different databases. I'm receiving all of the variables from one Datasource, but one variable is not showing up from the other DataSource.Both of them are related to the "IDInquiry" field, but even after relating the two its not showing up.​​Attached is my code:​<cfquery datasource="Portal" name="GetNoms">  SELECT IDStudent, NameFull, School_Name_Previous, InqContactPhone, P1_full, P1_phone_H, P1_city, IDINQUIRY  FROM Inquiries WHERE Inquiry = 1 AND Adm_Record_Status = 'Active' AND (Application IS NULL OR Application = 0) AND Adm_Enr_Status = 'Inquired' AND P1_phone_H IS NOT NULL AND P1_city IS NOT NULL AND YOE = '#YOE#' ORDER BY P1_city ASC</cfquery><cfquery datasource="Portal" name="GetPercentage">  SELECT IDInquiry, PercentComplete_display FROM inq_PWSINPUT</cfquery><cfquery dbtype="query" name="FinalMix">  SELECT * FROM GetNoms, GetPercentage WHERE GetNoms.IdInquiry = GetPercentage.I

I'm having a "File is missing" error which stops me from accessing loopback server that CF2018 is deployed. However, when I look into the specific directory (where the error message shows me xxx file in xxx is missing), the so-called missing file is existing. I tried to restart WebLogic server, not helping. This is the error log I got in Eclipse console log:<Oct 23, 2018 4:14:23,579 PM SGT> <Error> <HTTP> <BEA-101005> <[ServletContext@2099463259[app:cfusion2018_home module:cfusion2018_home path:null spec-version:3.1]] getRealPath() called with unsafe path: "/Projects/Corporate/eaccounting/:93/cfusion2018_home/Projects/Corporate/eaccounting/common/main/emailVerify.cfm".java.io.IOException: The filename, directory name, or volume label syntax is incorrectat java.io.WinNTFileSystem.canonicalize0(Native Method)at java.io.WinNTFileSystem.canonicalize(WinNTFileSystem.java:428)at java.io.File.getCanonicalPath(File.java:618)at weblogic.servlet.internal.WebAppServletC

We are installing on an offline 2012r2 'standard' installation.Installation of CF2018 went just fine - sites are reachable.After running the Lockdown application none of the ColdFusion services will start.  I did select an AD account to use, validated the password was updated first, but after completing the Lockdown and restarting the server the services fail with 'Access Denied'.I have restored the ColdFusion service to use the Local System account and that now fails as well.Any insight would be greatly appreciated.

I am probably dating myself here, but I have an application running Mach-II and Coldspring (which I use for dependency injection). I recently upgraded to CF 2016 and did not have any issues with this version/upgrade. I was testing the CF 2018 Pre-release build today and was unable to get my application to load.  Looks to be throwing on error on this: <cfset var abstract = false /> -----The web site you are accessing has experienced an unexpected error.Please contact the website administrator. The following information is meant for the website developer for debugging purposes.Error Occurred While Processing RequestInvalid CFML construct found on line 243 at column 28.ColdFusion was looking at the following text:abstractThe CFML compiler was processing:A cfset tag beginning on line 243, column 18.A cfset tag beginning on line 243, column 18. The error occurred in D:/APPLICATIONS/CF-INF/cfFrameworks/coldspring/beans/DefaultXmlBeanFactory.cfc: line 243Called from

I couldn't find any recommended hardware specs for the performance monitoring toolset.When I installed it I saw it uses elasticsearch, and it started with 2.5GB monitoring a single empty server.On the elasticsearch site, they recommend a machine with 64GB, I can assume this is different for this implementation. But I can not find any specs for this.How much memory/cpu usage should I expect per added monitored server? Is there any instruction on this anywhere?

When is ColdFusion 10 going to officially support MSSQL 2012? Specifically the "AlwaysOn" Availability Groups and the connection flag "ApplicationIntent=ReadOnly" or "ApplicationIntent=ReadWrite"? The JDBC driver from Microsoft supports it and I believe DataDirect has a new driver that supports it, but it doesn't seem available yet in CF10 and the latest Update 8. I tried running the Microsoft specific JDBC driver, but ran into differences in resultsets.

This is a problem that was first observed with CF8 using the cfchart tag. We have since upgraded to CF2016 and it still exists. Perhaps this is a programming error on our part but here is the issue:Trying to create a pie chart. In this case I has 4 data items. Two of them have 0 values and the other two each have a value of 50 (representing percentages).This is in response to a title to this posing as a question... How do you feel today?<cfsavecontent variable="chartContent">  <cfchart format="png" pieslicestyle="solid" width="400" height="280">    <cfchartseries type="pie">      <cfchartdata item="Terrific!" value="0">      <cfchartdata item="OK" value="50">      <cfchartdata item="Not so good" value="50">      <cfchartdata item="Terrible!" value="0">      </cfchartseries>  </cfchart></