ColdFusion

I've been working on migrating code from CF10 to CF2018.  I just noticed that in CF2018, my queries are unintentionally using a CF-like query cache.  This is noticable everytime I alter the table structure, my CF2018 session is still referencing a cached version of the query.  This happens even when I try to clear the query cache in CFADMIN, it doesnt affect the results.  Different behavior is produced with CF10 (see below).  If I add a comment to the query, it returns the correct results.  Is there a default query cache option enabled with CF2018? My Code:<cfquery name=”qTest”>select * from users</cfquery><cfdump var=”#qTest#”> CF2018 Results:Displays table columns names correctlyCache is false CF10 Results:Displays table columns names correctlyCache is false Then I rename a column in oracle, and run the same page<cfquery name=”qTest”>select * from users</cfquery><cfdump var=”#qTest”> CF2018&nbs

I have a report with a group header, detail band, and a group footer. How can I keep them from splitting up if they fall between pages? I want to keep all together on one page, even if it means that the page breaks before the group header. I don't want to specify starting a new page break at each group, because that would be a total waste of paper (some groups are only a few lines long). I've looked at the "split allowed" property in the group header band and have set it to false, but that doesn't seem to make any difference. Right now, if I remove all of the grouping, I will have a group header at the bottom of the page with the detail and footer on the next page and it looks dumb and is hard to read. Does anyone have a workaround or an answer to this question?

What would I be looking at to run a Perl script at d:/path/to/my/perl/loader.pl %year% with a <cfexecute...> tag? I've tried to do it directly: <cfexecute name="d:\path\to\my\perl\loader.pl" arguments="#year#" variable="goodbar" errorvariable="foobar"/> I've tried to do it through cmd.exe: <cfexecute name="c:\windows\system32\cmd.exe" arguments="d:\path\to\my\perl\loader.pl #year#" variable="goodbar" errorvariable="foobar"/> I've tried calling perl.exe: <cfexecute name="e:\Perl\bin\perl.exe" arguments="d:\path\to\my\perl\loader.pl" variable="goodbar" errorvariable="foobar"/> I am not having much luck with this. The weird thing is that I am not getting any results OR errors. Just nothing. This is a Windows 2003/CF 8.0.1 server.

I've connected to a remote server and can run a project in debug, but when it gets to a breakpoint in a .cfm file, it always has the error 'Source not found.'  I have a feeling my 'Server Mappings' are incorrect, but I'm not sure how to fix them.  Does anyone have an example of a correctly setup mapping? Our development and remote paths are on different drive letters, I'm wondering if that confuses it.  I don't have anything for 'Virtual Host Settings', do I need to? I've tried several variations for mappings, including:Local Path: F:\workspace\appname Remote Path: G:\dir1\appname URL: host/dir1/appnameLocal Path: \\hostname\G\dir1\appname Remote Path: G:\dir1\appname URL: http://host/dir1/appname Here's the Eclipse error from the workspace .log file in .metadata:!MESSAGE Error logged from Debug Core: !STACK 0 java.lang.NullPointerException at com.adobe.rds.client.eclipse.debugger.core.launching.CFMLSourceLookupParticipant.getSourceName(CFMLSourceLookupPartic

Cannot make ODBC Socket connection, getting this error: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined I used Developer installation before I purchased the ColdFuison 2018 Standard License and I was using Oracle as a Driver and was able to connect to the database. Once I applied the license (serial number), the Oracle connection was not working anymore and I tried to use ODBC Socket and still cannot connect, the error from above occurred. Additional Information: Cold Fusion is installed on Windows Server 2016. I have set up the ODBC connection and it's connecting to the database without errors.

Hello, all. I'm trying to check the status of a collection to see if it's already in the process of being updated.  <cfindex action="status" status="sinfo" collection="myCollection" /><cfdump var="#sinfo#" />  This results in an error: "Variable SINFO is undefined." What am I doing incorrectly? V/r, ^ _ ^ UPDATE:  This has been added to Tracker.  Please vote for it.  Thank you.

I'm looking for instruction for setting up CF2018 as a systemd service.  I found a script called cf-init-run.sh and it created the service file but the file that the service file references "sysinit" does not exist.   Any idea as to how this file gets created or if it's other file renamed ?  Or perhaps another script that is supposed to create it.Any help would be greatly apperciated.  Thank you

I'm guessing it is the way our IT department has Chrome and IE locked down but neither will work downloading the CF 2018 Trial. Chrome just doesn't download, IE seems to think it's a text file!I need to get a copy to start testing /documenting upgrades from CF 11 for our groups applications. Can somebody message me a direct link please?Thanks!

Was unaware that I was allowed to post this kind of "advert" here, but Adobe gave me the "green light".  Looking to hire one or two full-stack freelancers in either the USA or Europe to help with a huge project.  Requirements include:- Solid English speaking - At least 5 years ColdFusion experience. (Even though we're stuck, for now, on CF11)- Solid CSS needed- Bootstrap a must- JS a mustYou'll be working on a sub-project of the main core.  Create a data driven web site where the data provides you with all the photos and marketing drivel for a given "property".  Flick a switch and load the same data into a totally different "template".  Project deadline is 1 March 2020 with the core and 2 or 3 templates. Hire date - immediateRate $50 hour minimum.  Retention expectancy 1 month.  Can be done as either full time or moonlighting. You'll be liaising with the team lead in Europe. Excellent communications skills (email / W

I have a situation where I am creating variables using scopes:- arguments- normal named integersWhen I run this code ... day in=[#day_in#]<cflog text="in calendar function [#arguments.x#][#day_in#] [#day_out#]">din[#day_in#]I get the values of 0 for all vars on my screen and the "correct" value (48000) in the cfadmin application.log fileI am beginning to suspect that CFBuilder is corrupting my source file?Never seen this before.  

Good day!Our organization has acquired a license for Adobe ColdFusion 2016 with vendor support. I had a need for consultation, but I can’t find places on the Adobe website where it would be possible to create tickets / service requests.I am an expert on Oracle products and am used to simple and clear means of communication, but in the case of Adobe, everything is far from simple.Can someone explain to me how the application is made here?

Does anyone know if we can apply this to Fargate or Fargate EKS deployments where the Docker host is serverless?  Meaning can I run up to 8 containers on AWS Fargate with one Enterprise license? How do I license ColdFusion on containerized deployments?ColdFusion Enterprise Edition allows a maximum of eight containers to be used for every Enterprise license, provided the underlying instance is licensed as per the ColdFusion End User Licensing Agreement (EULA).

Hello,   We using Cold fusion 2018 on Windows Server 2016.When I am trying to submit a Form to call another page within the application I get an error which states "Error Occurred While Processing Request. Please try again. Invalid attribute value CF_SQL_STRING for attribute CFSQLTypeTheerror occurred on line 223"I am not sure why the string value is throwing up an error. Please adviseThe code snippet used is shown below,     <cfoutput>                      <CFSTOREDPROC PROCEDURE="dbo.PKG_CFSTOREDPROC.proc_print_calc" datasource="#datasource#" username=#Session.UserName# password=#Session.password#>                                         &nbsp

Problem getting focus on cftextarea in an iframe.  Page greys out when any toolbar item is selected.Please help!<cfTEXTAREA richtext=true skin="moono" toolbar="Basic" WRAP=PHYSICAL ID="FormsMultiLine1" style="font-family : Tahoma, times new roman; font-size : 9pt" NAME="copy" height="200" width="550">#copy#</cfTEXTAREA></TD>

I want to confirm that this is accurate.The FAQ for both Standard and Enterprise editions both say this:How do I license ColdFusion on containerized deployments?Every containerized deployment needs to be licensed as per the ColdFusion End User Licensing Agreement (EULA). For instance, if ColdFusion is being deployed on two containers on a single VM instance, then both containers running ColdFusion will have to be licensed separately as per the ColdFusion EULA based on that VM instance being used.My initial reaction is to assume that they copied and pasted the FAQs and that at least the Enterprise edition isn't so limited. It would seem the height of folly to do all this great work on the 2018 release only to stifle the ability to use

Hi. We have set up a SQL 2017 failover cluster (active/passive).We have created the datasource in ColdFusion to the IP of the AG database and it's all OK.If i switch the SQL servers all old request from coldfusion remain suspended (new request go to the active server).I found in MS documentation how to set JDBC driver in HA:https://docs.microsoft.com/en-us/sql/connect/jdbc/jdbc-driver-support-for-high-availability-disaster-recovery?view=sql-server-ver15But it seems that it cannot be done with the native coldfusion JDBS driver for MSSQL. I've to use the MS JDBC Driver (acctual version 7.4.1.0)?It's supported?Or there's a way to use the multiSubnetFailover in the coldfusion native driver?

Hi, we're in the process of porting our application to ColdFusion 2018. The staging server was on CF 2018 updater 4 and the site worked well. We eventully updated to updater 7 and the site stopped working with exception: Branch Target Offset Too Large for ShortThe code was not modified, the JAVA version stayed the same - 11.0.4. Only the latest ColdFusion updater was installed.We returned to updater 4 as this was working.We got this exception with a different code in CF 11 in the past, which worked in CF 2016. We can maybe shorten the code (break it down, whatever). It's a surprise to see this exception out of a sudden, as it used to disappear using a newer updater. Has anyone of you experienced the same exception, recently? Which updater (5, 6, 7) introduced this behaviour?

Just realized my calendar code is not always displaying the day 1 of the month on the correct day. So I went back to the date handle docs and cannot determine HOW to grab the value. I would assume I would supply CF the month and year integers and it would provide a dayofweek?Or not?The method I am using now is clearly wrong. 😞<cfset month_then=createdate("#year_then#","#monthis#", 01)><cfset month_starts_on_day=dayofweek(month_then)><cfset month_starts_on_day=month_starts_on_day-1>  forget why I added this?<cfif month_starts_on_day is 0>             <cfset month_starts_on_day=7></cfif><cfset dim=daysinmonth("#month_then#")><cfset dim_total=dim><cfset dim=dim+month_starts_on_day>

We seem to be easily be able to reproduce an issue with CFFile in CF 2018. Doing a simply copy action on a file in 2018 seems to be 3-4 times slower then CF 11. When doing this on a local file it can take around 1-2ms to copy but on CF2018 this can take up to 15ms. The issue is worse where we use it as we copy using S3:/ - this can be the difference of 300ms on CF11 to 900ms on CF 2018 When dealing with a lot of images, these increases can make things take a lot longer.  So the question is, has something changed in the recent version of CF to cause a CFFile to work differently? We are testing on Windows Server 2012 with CF 11 HF 18 and CF 2018 HF 6 We have done the same test on Windows Server 2016 with the same results. All have the same JVM settings and specs. Two fresh installs on different servers and one upgrade, all produce the same results.  Any ideas before I submit a bug. Just incase I am missing anything obvious.

I am working on an install of CF 2018, and have migrated a website that was working in CF 8 (yes, I know, it's ancient) and is not working now.In trying to match the settings between the two installs, I apparently moved or changed something that has now caused the CF administrator to stop working. I can't get IN to the CF administrator, so I can't find the setting to fix it.On the Administrator index page, instead of getting the login page, the page is black with a search window on it. There is a popup that says "Message from webpage Error invoking CFC /CFIDE/administrator/updates/download.cfc : WDDX packed parst error at line 1, column 1. Content is not allowe in prolog.. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]Adding cfdebug isn't giving me any other information.How do I fix this without uninstalling and reinstalling the whole program? Thank you

We're having a strange problem since the code was migrated from CF10 to CF2016. I'd appreciate your opinions. There is something strange with the way data are retrieved from an AS400 database. The customer used an ODBC driver but installed an AS400 Java driver and the problem persists.The screenshot shows a query on an AS400 table and a subsequent QoQ. The left version is CF10, the right version is CF2016.It appears that alphanumeric values on the AS400 come with a trailing blank (LVSROM="QW" but it is in fact "QW "). LVSROM is just an example, the same happens with other alphanumeric fields. The old version of the subsequent QoQ finds something, surprisingly, even though the where clause says "='QW'" and even though there is a trailing blank in the data - CF seems to ignore this trailing blank - in fact the query doesn't even work if the trailing blank is attached in the where clause (see example). I don't understand this but it worked.The QoQ in the 2016 CF version (right side) won't

I am migrating my website from Windows server 2008 to Windows server 2019. I've got CF 2018. I cannot get it to connect with my MS Access database. Did all the ODCB entries. Registry has the correct information. When trying to make and verify the connection in CF admin, I get "java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined". I found a website that said Windows 2016+ does not support SequeLink. I don't know if that is the problem. I just need to get CF2018 and my database connected. Any solutions? 

I'm moving a non-profit's site from CF10 to ColdFusion 2016. Did something change regarding how form data was added to arguments?We have a simple donation form using the well publicized authorize.net CFC (from John C. Bland II . Form data was pushed to authorizenet.cfc component which processes, and returns the authorization information. On CF10, they had co-mingled #arguments.variable1# with #form.variableZ# to insert the data, along with the merchant response, to a mysql database (and properly not storing the credit card data) , and sending a couple confirmation emails.However, with CF16 it seems to be that once I call the authorizenet component, the form data is no longer present when the insert function runs and emails are generated.

I was able to call the services on the development box - windows server without any problem at all, everything was working fine but the moment i uploaded to a linux box production server I get this error. "Could not generate stub objects for web service invocation in ColdFusion"What could be the cause of this problem, i have googled a lot but no solution yet any ideas.

I'm doing a QoQ for last names and sometimes I run into O'Briens or O'Tooles and these won't search. I'm using:<cfset Variables.SearchName="%"&LCase(Trim(Form.Name))&"%">(LOWER(LastName) LIKE <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Variables.SearchName#"> Any idea what I'm doing wrong?