ColdFusion

I am seeing this error when i  have table with different UDF functions that needs to be evaluated. With multiple rows i get this error below.Invalid method Code length 274259 in class file Statement98 The specific sequence of files included or processed is (file name).Can anyone suggest what can be changed within server that can help me evaluate a larger string of data.Thanks in advance

We are updating from Coldfusion11 to Coldfusion2018 and are trying to configure the PMT.  We have installed the PMT on a separate server, but are unable to configure it to auto-discover our CF server nor can we manually add it.  Both the CF server and the PMT server are Redhat Linux.  We assumed that the datastore was created as part of the CF installation, but have also explicitly installed a datastore on the CF server.  Neither seem to work.  When we try to manually add the CF server within PMT, we get a 'Failed to Respond' error message.  We're not sure on which server the datastore should be installed or if we are using the correct port.  We've been using the port that was defined during installation of the PMT.  Within the CF administrator, the monitoring settings indicate that we are not connected to a datastore nor is monitoring enabled.  Are these settings controlled via the web server or the PMT server?I apologize if this informatio

Environment:Unix SolarisApache 2.4.39CF2016 HF10I have been having this really weird intermittent issue with uploading files and the only thing I have been able to track it down to is the Application the web transaction is running as displayed in FusionReactor.I'm monitoring for a post transaction and the only time it seems to fail is when it is being run as "Adobe Coldfusion 2016" application, when it normally is run as "XYZ Application" coded in the application.cfc.When the app runs as Adobe Coldfusion 2016 it times out after 20s no JDBC transactions are started and it shows Tomcat WebSocket (JSR356) Filter. A little bit of research and the default timeout for Tomcat connector is 20sCFADMIN settings for timeout on this instance is set to 60s and have verified in server.xml the connector port settings are there.When the application succeeds it usually completes in 4-7 seconds.Since upgrading to HF10 I have run the wsconfig upgrade to bring the connectors up to mod_jk/1.2.46We have pus

We have recently purchased and in the process of migrating our Cold Fusion8 Enterprise to Cold Fusion Enterprise 2018 on new machine. followed below steps Installed CF18 on new machine as Production + Secure ProfileCreated CAR file from old CF8 server and deployed on new machineGot the IIS server configuration using MSWebDeploymentTool.Ran WebServer ConfigTool to configure IIS with ColdfusionNow when I am trying to load website through local host I am getting error “HTTP Error 404.2 - Not Found”. Please suggest if I am missing something here.

I have receive a cfBuilder license at the last CFSummit, but never been able to sucessfully install the thing ....Now that I check back this, when downloading CFBuilder 2018  the trial install the cfbuilder 2016 ....Could it be that my license is 2018 but I can't enter it because builder is 2016 ??How can I download builder 2018?  I don't want a buy it I already have my key.  So I want to download the trial and after that insert my key ....I kind of confuse with the whole 2018 or 2016 thing .....

Hello I'm not the greatest at Coldfusion I'm trying to get it to look at a field in our sql table and if it's not black to print "f:" with the stockas info. I also need it to look at another field crossfile and when it's true (1) to change the upc label to say "xf:" instead of "f:". My issue so far is I can get it to print the cross file fine, but when file as is filled out and crossfile is false (0) it won't print out "f:" it's just blank like it is when nothing is under stockas. Here's part of my coding that it effects:<cfquery name="qPrt" Datasource="#Data.Datasource#" >    SELECT    p.ItemID, p.UPC, p.vendorID, p.SKU,   p.StockAs, p.Artist, p.Title, p.RetailPrice, p.releaseDate, p.Attribute2            , g.generalCategory, p.Crossfile    FROM    Item p      LEFT JOIN GeneralCategory g ON p.GeneralCategory = g.generalCategoryID&n

We are upgrading several mature sites to CF 2018.  One thing that is biting us quite a bit is the way CF 2018 handles cfsqltype compared to earlier versions.  Typos or incorrect cfsqltypes used to be skipped and treated as varchars.  On CF 2018, they error out.  This is fine however, being mature sites, there is a lot of code and cfqueryparams to be tested for typos.  I know it's probably a long shot but would anyone know of an existing piece of code that parses cf code for cfsqltypes in a cfqueryparam?Thanks,Jeff

Has anyone else seen this? groupcasesensitive is optional, and the default is "yes", so I was surprised when a user reported the tally by country indicated 40 items found but the country breakdown only summed to 36. Turns out we had 13 for Nigeria and 4 for NIGERIA. The report was displaying NIGERIA 13, first label, last value, which I find baffling.After explicitly adding groupcasesensitive="yes" to that query, everything is as expected- both rows display and the running sub-count now totals to 40.We are standard license on windows. I'll see if I can replicate in a simple demo and share.

I created some code that takes a CSV and BULK INSERTS it into an MS SQL database.This is on Windows Server 2017. MS SQL 2017. CF 2016. SQL Server is separate from the CF server and connected with an internal 192.x.x.x. IPThe code works perfectly on my local development box, but when I run it on the server the CFQUERY BULK INSERT fails, 'the system can not find the path specified'The file is there, I've also tried multiple locations. I can only presume this is a permissions issue. (CF is running on it's own user account with admin rights).I'm somewhat stuck. I presume all of the permissions are made by CF?Update:Resolved. I was using the wrong password for the CF accountSolution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

Hi,I have to calculate the number of hours between two dates and exclude Saturday and Sunday. The first 24 hours (Monday, Tuesday, Wednesday, Thursday or Friday) of the calculation is a grace period. After the first 24 hours, is the calculation for over of compliance.For example:Notified: 2019-02-03 08:58:00.0000000  (is a Sunday)Entered: 2019-02-05 08:38:00.0000000  (is a Tuesday)Since 2/3/2019 is a Sunday, the time shouldn’t start counting until 2/4 at 00:01. There’s then the 24 hour grace period, so it becomes out of compliance on 2/5/2019 at 00:02. It should only be 9 hours out of compliance.The query in The SQL runs fine for Monday - Friday. It's not excluding Saturday and Sunday.Below is the SQL code for the number of hours:DATEDIFF(hour,CAST(tbla.NOTIFYDATE AS DATETIME) +  CAST(Coalesce(tbla.NOTIFYTIME,'23:59:00') AS DATETIME),  CAST(tbla.ENTRYDATE AS DATETIME) +   CAST(Coalesce(tbla.ENTRYTIME,'23:59:00') AS DATETIME)) - ( (DATEDIFF(wk, tbla.NOTIFYDATE,

Trying to get the actual ip address of a user with coldfusion sitting behind an F5 appliance.  Researching I found the RemoteIpValve which can be placed in server.xml, but it does not seem to work on CF 11.  Does anyone know of any tricks to getting this to work or does it not work at all in CF 11?Thanks

I have a cloud share drive recently assigned to my project, and I was able to copy a number of PDF files into it.   I can use Windows Explorer to navigate to that drive and bring up any PDF file with ease -- double click, view in Acrobat, no problem.I can use CFDIRECTORY to list the contents of the directory, and I can use FileExists and CFFILE to test and grab a copy of the file, no sweat.I put a text file in the directory, and I can pull that up with:<cfheader name="Content-disposition" value="attachment;filename=filenamehere.txt"><cfcontent reset="true" type="text/plain" file="file:///\\sharedDirectoryHere\filenamehere.txt">I put a GIF in place and <image> displayed it easily.I can use the following code pair to view PDF's on another project's share with no issue, PDF pops right up...<cfheader name="Content-disposition" value="attachment;filename=filenamehere.pdf"><cfcontent reset="true" type="application/pdf" file="file:///\\otherSharedDirectory

I am familiar with several list functions in CF but I can't seem to figure out how to do this thing:I have a long list (from a query in coldfusion) of names, e.g. "john" or "silverfox" or "7" (all "user aliases").  say, query.aliasI have to put this out on a page and it's way too many for sanity.I want to break it up by the first letter of the name. Like:*: (list from the point before names begin with letters, like numbers and special chars)A: (list from the point where names begin with A)B: (list from the point where names begin with B)C: (list from the point where names begin with C)But listfind just finds the first "a" (and none of are just 'a' as a name), and listcontains just finds the first name that contains an A anywhere.How can I find the location in the list of where a value BEGINS WITH a certain string ("a"), so I can make a var of that value, and then loop the query out with a rowcount and 'start/stop' it at the appropriate places? (I guess that's how it would be done,

Hi Community,To start with I'm very new to the ColudFusion applications and development.We have an old coldFusion Mx application hosted on IIS server. It is production application. Now, we are in planing to change the application url, however we are not sure where to change the configurations so that application functionalities work seamlessly with the new url.any help is highly appreciated.Thank you,Regards,Venky

Good Morning,I spent all of last friday trying to figure out why the ColdFusion 2018 Auto-Lockdown will not complete.We successfully migrated from CF10 to CF2018 on our test site as well as our production system. No errors on install or in the code analyst.But when I tried to run auto-lockdown, I received the error "windows error 2 java vm". I installed an older version of Java and created the specified path in "Path" in the Environment Variables. It will NOW start and I am able to input all of the information it asks for.But now auto-lockdown gets to one point every time and just stalls. In the CF2018 auto-lock down window it stalls on " Installing... Coldfusion Lockdown".In the ColdFusion log file it shows that it tried to delete a file, the file exists, and then Deletion of file successful.Then nothing.Any help would be greatly appriciated.Thanks,Rob

I am attempting to upload a file using the Dropbox API.  Dropbox requires Contact-Type = "application/octet-stream", which I am tried to set in the cfhttpparam type = "header".  However when I post the data to the API.  I get an error stating: Bad HTTP "Content-Type" header: "application/octet-stream,multipart/form-data; boundary=-----------------------------7d0d117230764".  I am guessing that when a cfhttpparam type = "file" is included, the content-type is modified to also include multipart/form-data.  The api will not accept this content-type.  Is there a way to avoid this behavior?  This is the code I am using to attempt the upload.  Thank you.<cfhttp method="post" url="https://content.dropboxapi.com/2/files/upload" result="uploadFile">  <cfhttpparam type="header" name="Authorization" value="Bearer #DropboxAccessToken#">  <cfhttpparam type="header" name="Dropbox-API-Arg" value="#serializeJSON(stFields)#">  &lt

Hi. We are experiencing some binding issues in several forms after upgrading to CF 2016 from CF 10. All work fine in 10 but not in 2016. Are their new setting I should be looking at?Thanks in advance. Any help is appreciated.

I've been forced by my ISP to moved from an MS Access database to MySQL. The ISP ported my Access db to MySQL on their server. I've been trying to set it up for my use on localhost. I have the database created and working in MySQL Workbench. I created a MySQL ODBC dsn that tests good in Microsoft ODBC Administrator.Initially, I renamed my Access dsn and applied the original name to the MySQL dsn. When I hit a script with a query, I got: "Specified driver could not be loaded due to system error 182"Then I thought to open CF Administrator to check the datasource there. I deleted the record for the (working) MS Access dsn and created one for MySQL. CF Admin indicates that my "data source updated successfully." I'm using the MySQL (4/5) driver. However, when I open a script with a query, I get the error in my debugger: "Could not create connection to database server. Attempted reconnect 3 times. Giving up."Any thoughts on how I make this DSN work for my application on localhost?Many thanks

Hello, all,We have been alerted to a minor finding.  JSESSIONID session cookies are not secure.  The CFID and CFTOKEN are secure and httpOnly.We followed instructions from a 2014 thread to make JSESSIONID session cookies secure and httpOnly.Viewing in FireFox with DevTools, initially the JSESSIONID cookies are secure and httpOnly, but if you click on to another cookie, then come back to JSESSIONID, the cookie is NOT secure.Viewing in IE11 with DevTools, the JSESSIONID cookie shows twice; once as secure and httpOnly, once as not secure but httpOnly.What is happening??  I'm at a loss, on this one.V/r,^ _ ^

I am continuing to troublshoot some 503 issues with my new server.  I recently enabled the Dump Snapshot feature inside Server Monitor and whenever I have an Unresponsive Server alert and I am seeing tons of these in the snapshot.  Anyone know what this means exactly??"ajp-bio-8012-exec-384" prio=5 tid=1261 BLOCKED     at coldfusion.server.j2ee.sql.pool.JDBCPool.checkOut(JDBCPool.java:371)     at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:825)     at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)     at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:135)     at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:42)     at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156)     at coldfusion.sql.DataSrcImpl.getConnectio

we are using 1250 charset in our reports. Since update 10 for CF 2016 only ????? are instead of čćžšđ.Any idea?

I have a problem calling WS on CF. I created a simple WS, which accepts PDF file (as a BASE64 string parameter).I user SOAP UI to test it. If I call it normally it works. But if I use chunked mode, I don't get parameters.I also try CF on Apache instead of IIS, but it also doesn't work.Also Lucee + IIS doesn't work. Only Lucee + Apache works fine.I can't use only normal mode for calling, because the WS will be for external user, which allways uses chunked mode!thx for ideas, how to solve this.

Hi there, We have purchased ColdFusion Standard 2018 13.0 ALP AOO License UE (65293634)Can someone please send me the URL for downloading this version  ?ThanksIQ

Following,  ColdFusion (2016 release) Update 10, the encryption / decryption  of url parameters we have used for the past 3 years is no longer workingWe tried rolling back the update on one of our servers and this worked. As update 10 is a Critical update, we cannot roll back our production server farm.Current encryption process which was deployed 2 or 3 years before:Created AES secret key using Coldfusion inbuilt function (generateSecretKey("AES"))Encrypted the entire URL parameters with the AES secret key. (AES encryption)Concatenated secret key and AES encrypted URL.Encrypted the concatenated data again with “CFMX_COMPAT” algorithm using a defined password. (Second level of encryption).Sent this data as URL string to the requested page.On the requested page, we decrypt the data again in the reverse order.Created URL parameters needed for that page from the decrypted data.When we got the issue on Update 10, we investigated whether it was because of “CFMX_COMPAT” algorithm.

Hello folks.We have a number of Windows 2008 R2 servers and a few are running CF 10 Enterprise.We are planning to upgrade all 2008 R2 servers to at least Windows 2016 Core or Data version. Which version of CF would you recommend knowing what you know now.I am leaning just towards CF 2018 standard as we don't need nor use any of the enterprise features from version 10 anyway. It is expensive so that is why we are thinking about which versions to use now. The only must is that it must be able to connect to our Oracle 11g+ enterprise database connected to our SIS (Ellucian Banner) and MySQL 5.7 or 8.0 and with some PostGres.How much ram would you need? I am thinking of at least 32 GB because it is Windows 🙂Would you use windows 2012 or 2016 even?Thanks