ColdFusion

Ok, migrating from CF11 to CF18 ... and with database with unsynched tables ... so I expect errors. With CF1 to CF11 I used application.log to find any errors in AJAX areas (CFCOMPONENT) Hitting bugs and no where does it show errors.  Where are they?Wow, several hours into CF18 and I loathe it.  Change for the sake of change.  Feels like WIndows 8.  UI is suddenly off the charts different. Might well downgrade.

I am a bit lost on how to get the data out of a structure created from deserializeJSON. I am trying for example to set Results = data / array1 / doc / m.So along the lines of <cfset results = #data.doc.m[1]#> but that's not right... What's the proper way to do this?When I dump the results the look like:

We have a ColdFusion application that is currently authenticating external users using an ADLDS database.  This app does both authentication of external users and authorization of requested rights with internal users.  We would like to switch this to Azure B2C or B2B.  Our internal users are already in Azure AD since we are Office365 customers.  Can this be made to work directly from ColdFusion?

I have recently submitted a ticket regarding this issue, but not sure of the response time so I would like to query other developers.The extends attribute path of the CFComponent seems to be caching on the server level the first request being made. Instead of just creating an error for the requested application, every application that uses dot notation extending the same path fails.The error message returned is:"The .test.componentC ColdFusion component or interface name, used to extend or implement the test.componentA component is invalid. Ensure that the file exists, that the name does not start or end with a period (.), and the name is not an empty string."The issues occurs after installing CF2018 Update 4, seems to be related to the fix https://tracker.adobe.com/#/view/CF-4204108The details are in Tracker , but basically if you have two components with one extending using dot notation and the other using "/", it seems the path of the first component loaded is being cached. In this

Is there a practical limit to file sizes?Specifically .cfc.  My entire application is using ajax saving, URL free screen rendering and I have 3 or 4 cfc's ... but each one is growing to over 5,000 lines of code. Is there a limit to file sizes?  To what CFBuilder can handle.  I see CFBuilder slowing down. I realize, of course, that CFC's never leave the server but still ...

I can't get Code Assist to work for ColdFusion tags only.  When you type "<" the code assist box pops up with html tags.  Type "c" and the list reduces to tags beginning with "c."  But as soon as you type the "f," the box closes.Hitting ctrl-space or space in any tag, including ColdFusion tags, causes code assist to open with "Global Attributes" but not with ColdFusion parameters.  Hitting ctrl-space while the box is open closes the Code Assist Box.In the Window/Preferences/Code Assist Panel the Code Assist Dictionary Version lists only 11, 2016 and 2018 versions.  Clicking on Reload Dictionaries button doesn't do much, the button grays for about a second.  Selecting a different dictionary and clicking Reload Dictionaries has no effect on behavior. I have Auto-Activation selected both boxes.  Auto-Insertion, all 3 turned off though it continues to insert Closing Tag on a New Line.Append Space, Automatically Insert = sign and Insert Required Tag Att

Why is the ext-all.js file (cf_scripts/scripts/ajax/ext/ext-all.js) over 10MB in size? We went from CF10 to CF2018 and have 40+ legacy apps that use the cfwindow and some other CF UI built-in functions from CF10 and the app calls the ext-all.js file wihen the site loads (needed for cfwindow) and takes almost 2 minutes. Yes, I know they need replaced but with two developers and 40+ medium to larger applications it's not possible to replace these cfwindows with jquery or bootstrap modal windows quickly, especially when you still have other projects going on. Does anyone have any ideas or options to reduce the file size or any other workarounds (besides removing cfwindows) to speed the load time. Thanks.

I am trying to implement a custom event handler to monitor our scheduled tasks.  Ideally i will log the data into a db and make it searchable, but in the mean time I am just trying to fire an email to make sure it gets called.  Unfortuntately the emails are not comming through, however I know the SMTP is set up correctly.  Here is a copy of the logs and handler cfc I tested. Any ideas on why the emails arent sending or why I am getting the error that the Response Cannot Be Null?I set the handle up in the Sceduled Task set up under more settings to point to my custom handler.  When I fire the jobs, I do not see th email but instead see this in the logs,In the scheduler log I seeJul 10, 2019  12:25:00 PM  Error  DefaultQuartzScheduler_Worker-8  Response cannot be nullJul 10, 2019  12:25:00 PM  Information  DefaultQuartzScheduler_Worker-8  Task GROUP_NAME.Brendan Test triggered.Jul 10, 2019  12:25:00 PM  Error  D

After these steps to upgrade Java, CF services won't restart.Current version of CF is 2016,0,11,314546   Downloaded JDK 11.0.3 from Adobe download site, resides at C:\Program Files\Java\jdk-11.0.3  (without source code)Stopped CFUpdated jvm.config     #java.home=C:\\Program Files\\Java\\jre1.8.0_211     java.home=C:\\Program Files\\Java\\jdk-11.0.3Restart of CF fails.Revert to JRE 1.8 and restart CF successfully.No logs. Event log points to third party error and Service Specific Error Code 2.What am I missing?

Hi docs anybody knows, how I can connect to an external database over ssh ?Kindly regards.Thorsten

How does the CF 2018 performance monitoring toolset actually monitor a server when installed on a different box? Is it reading log files or actively reading operations in real time? Also why is it recommended to install it on a another box, what kind of resources would it consume if on the same box as the web server?

This is might be earlier question for everyone here in this forum, I wanted to know few information that I'm missing.To get server information I'm dumping "server.coldfusion.productversion" and it outputs 2018,0,04,214335. can someone help me out what are these list shows? Thanks in advance.2018-- CF version0--?04-- update level214335--?

Hi,does exist a way in AWS Cloud to achieve scalability without buying Amazon Marketplace ColdFusion AMI? Is there a special Adobe ColdFusion license for those purpose (a sort of "on demand" license)?Thanks for your help!

Hi,I develop an application for management of meetings in CF with an Oracle DB. Each meeting is linked to a unit (UNIT_ID)I'm trying to execute queries on fields and I obtain an Orable error:So I have 2 tables with DATA fields (DD/MM/YYYY)Table UNITS: UNIT_ID (PK) - UNIT_TITLE - DT_DEB - DT_FINTable MEETING: meeting_ID (PK) - TITLE - DATECREA - UNIT_IDThe request for getting the creation date of the meeting:SELECT TO_DATE(DATECREA,'DD/MM/YYYY') AS DATECREA FROM MEETING M WHERE M.meeting_ID = 45533The result: 30/05/2010The request for getting the start and the end dates of all unit versions of the meeting unitSELECT UNIT_TITLE, TO_DATE(DT_DEB,'DD/MM/YYYY') as DT_DEB, TO_DATE(DT_FIN,'DD/MM/YYYY') AS DT_FINFROM UNITS WHERE UNIT_ID = 231057The results:DT_DEBDT_FIN16/09/200529/04/200930/04/200930/06/201001/07/201031/12/2011I need to execute this query now for getting the good version of the unit used for the meeting<cfquery name="qry_existInAppref" datasource="#application.datasource#"&g

Have installed multiple instance of ColdFusion on 3 servers to setup and test configurations,Looking for help on deploying application to a cluster documentation does not seem to discuss anything beyond single instance deployment

Hi,Is it possible to check if an Array is defined and in the same CFIF statement check to make sure it's numeric?Something like:<cfif ArrayIsDefined(F,2) AND IsNumeric>Taking it one step further I need to make sure the value is between 1 and 99.ArrayIsDefined and IsNumeric and GT 0 and LT 100....Suggestions?Thanks in advance.Gary

I need to use a java library from Coldfusion 2018.  Everything's great except one method in the library is named ".is()", and Coldfusion throws an error on it thinking it's an operator.  I cannot modify the java library to rename this method.  Is there any other solution to calling it from Coldfusion?Thanks,

We have an application that makes heavy use of binds, in particular between related cfselects. When we moved our application from CF2010  to CF2016  the binds and binds on load fail on one of the large forms with over 100  (320 to be exact) form variables. This post parameter has been appropriately set in the CF Administrator settings page.  It works perfectly on a form with much fewer form fields (69) with 9 binds. There are perhaps about 20 binds on the larger form (320 fields)  and only one of them works.What is the problem here and how can I fix this? We are being tasked to upgrade to CF2016 becuase of the enhanced security issues, but the application is heavily dependent on the binds.I cannot seem to find answers to this anywhere.Any help will be most appreciated.Bill

This is my table for messagesI'm trying to pull data from only mid no 1 and mid no 4, basically my goal is to get the last message from every senderFirst i created a query to pull all the message for a user, in this case receiver id is 1<cfquery name="messages_tb" datasource="appdb">    SELECT * FROM messages    WHERE receiver = <cfqueryparam value="1" cfsqltype="cf_sql_integer"></cfquery>then i created a list of every sender id<cfset list.messages_tb_sender_uid = ValueList(messages_tb.sender)>after that i did this<cfquery name="messages_tb" datasource="appdb">    SELECT MAX(mid) as last_id from messages    WHERE sender IN ( <cfqueryparam value="#list.messages_tb_sender_uid#" cfsqltype="cf_sql_varchar" list="yes">)    and receiver = <cfqueryparam value="1" cfsqltype="cf_sql_integer"></cfquery><cfset list.messages_tb_last = ValueList(messages_tb.last_id)><c

Trying to get hold of Adobe support on this but wondering if I can get help here faster.Just purchase the CF2018 Enterprise edition.  Enter the serial number into CFAdmin and it logs me out with this message:"There was an error accessing this page. Check logs for more details."Application log has this entry:"Warning","http-nio-8500-exec-8","07/02/19","10:00:32",CFADMIN,"There was an error while verifying the token. Either the session timed out or un-authenticated access is suspected."Ideas?

Hello community, first of all, for all of you in US, happy 4th of July!I am having an issue I need some help with: I need to connect to an sFTP server, retrieve the list of XML files (files will be placed there for CF to do something with them) and then loop through the contents of these XML files and insert the values into a database.This is what I do: I open the connection and ask for the list of files using CFFTP. That works perfectly. Now, when I use xmlParse() to retrieve the XML content, when the file is in this sFTP server, I get the error "Content Is Not Allowed In Prolog". If the same file I place it on my own website for testing, then contents are shown without any issue.From the image, is line 30 where I tell CF where the file is located.I have tried BenNadel​'s post about this issue (Content Is Not Allowed In Prolog - ColdFusion XML And The Byte-Order-Mark (BOM) ) but didn't work. Using this suggestion the error says "Premature End of File".The XML file I am testing with is

Hello all,I am a newbie to ColdFusion and got stuck in an exercise.I am having a form where the user picks a file.<cfform  action="">   <cfinput type='file' accept='.json' name="choosefile"><br>   <cfinput type="submit" name="loadData" value="Load JSON data"></cfform>Now i want to read the data from file upon submit.<cfif isdefined("form.loadData")>     <cffile action="read" file="#form.choosefile# variable="jsondataFromFile">     <cfdump var="#jsondataFromFile#"><cfif>Now when i run the code i get FileNotFoundException because ColdFusion is searching for file chosen in temp directory.How do i read the file?Please help. Thanks in advance!

Each time the operating system is patched the RESTful services must be recompile or they throw errors when accessed. Version is CF 2018 on Windows 2016 server.

Hello, all,We recently applied the most recent patch for CF11, and now we are being flooded with alert emails that a variable named "qRead" is undefined.This is happening in a CFC function that gets distinct years from a database for news articles.     <cffunction name=icleYears" output="false" access="public" returntype="Query" >     <cfset qRead = "" />          <cfquery name="qRead" datasource="news_2016" cachedwithin="#CreateTimeSpan(0,0,10,0)#">               SELECT                    DISTINCT TO_CHAR(TDATE,'YYYY') articleYears               FROM            &nb

Hi Everyone,I have installed CF 2018 on Centos 7 and when I started the web connector creation I got weird results:mod_jk.so and workers.properties files were created in /etc/httpd/conf folder.My previous experience with CF 2016 is that those files should be in cf_root/config/wsconfig/{magical number} folder. Is it something new with CF 2018 that moved those files to /etc/httpd/conf or I am doing something wrong?The command I have used for connector creation is:/opt/coldfusion2018/cfusion/runtime/bin/wsconfig -ws Apache -bin /usr/sbin/httpd -script /usr/sbin/apachectl -dir /etc/httpd/conf/ -vor even this one does the same:java -jar /opt/coldfusion2018/cfusion/runtime/lib/wsconfig.jar -ws Apache -bin /usr/sbin/httpd -script /usr/sbin/apachectl -dir /etc/httpd/conf -vBack in CF 2016 file structure was:/etc/httpd/conf contained httpd.conf, magic and mod_jk.conf/opt/coldfusion2016/config/wsconfig/1 contained mod_jk.so, uriworkermap.properties and workers.propertiesPlease advise,Thanks!