ColdFusion

Hoy folks, Long time lurker first time caller.  I've hit an issue with ColdFusion ORM that I just can't figure out. Here's the situation. 1) I have a database procedure that I use to create tables with a number of columns that are common to all the tables. These columns are mapped to the persistent component. 2) The code to generate the keys looks like this (wod= word of the day):CREATE TABLE [dbo].[tblName]([idx] [int] IDENTITY(1,1) NOT NULL,[id] [varchar](36) PRIMARY KEY NOT NULL, ALTER TABLE [dbo].[tblName] ADD CONSTRAINT [DF_tblName_id] DEFAULT (newid()) FOR [id] 3) The rest of the columns mapped to given entity are generated by ORM. 4) The code for mapping these fields is...property name="idx" fieldtype="column" ormtype="int" generated="insert" setter="false";property name="id" fieldType="id" length=36 generated="insert" setter="false"; 5) My goal is to get the id property to be populated on save() from the database. 6) I get this

entityLoad('Account') throws this error,Error while loading entityjava.sql.SQLException: [Macromedia][Oracle JDBC Driver]Numeric overflow.However  entityLoad('Account',1) returns the proper record.I am using oracle 10g as a datebase.Is this a bug with oracle? entityLoad('Account') should return all my accounts.

Hi,Recently, i ran the update process from Update10 to Update11 for our CF 2018 Enterprise.However, we found that some (almost all) calls to REST services failed and throw the "java.lang.IllegalArgumentException: argument type mismatch" exception. To isolate the error from our entire implementation I made a simple implementation to reproduce the error: REST Service component (api.cfc)component rest = true { /** * * @httpmethod POST * @consumes application/json * @produces application/json * */ remote Input function echo(required Input payload) { return payload; } }Component (Input.cfc)component { property type = string name = content required = true; } I ran an HTTP POST through Postman and got the following exception (exception.logs):"Error","http-nio-8500-exec-8","05/26/21","09:12:36","","HTTP 500 Internal Server Error" coldfusion.rest.method.dispatch.CFRestException: HTTP 500 Internal Server Error at

First, I apologize if this is answered elsewhere. I tried searching here and Google, but didn't really find much.   I'm a former programmer who still has a legacy app used by my company very often.  For better or worse, I'm still the maintainer whenever IT can't handle it, and we are running into an issue where I made tabbed forms using Flash format with CFFORM many years ago. Does anyone have a suggestion on how to replace with something else?  I was hoping for something as simple as format="HTML5" but that's not an option...  Not a complex form, it's got about 4 tabs to better organize data that can be edited to maintain records in a DB.   Help & thanks!

My overall objective here is simply to be able to use a Java logging library, specifically log4j2 here, so that I can log user accesses to the application to a folder of my choice. And also make use of log rolling facility to copy log files to an archive directory at the end ofe very day. I have been using log4j2 with ColdFusion 2016.  I just placed the two jar files, log4j-api-2.6.2,jar and log4j-core-2.6.2.jar into the folder WEB-INF\lib and my config file, log4j2.xml into WEB-INF\classes.  That worked fine because ColdFusion 2016 was using log4j version 1 and there was no conflict of package names.  In ColdFusion 2021 it is using log4j version 2 and has the files log4j-api-2.13.3,jar and log4j-core-2.13.3.jar  installed in cfusion/lib and now I get an error on the first call to log4j2 when it should be reading the configuration file.It reports:ERROR StatusLogger Unrecognized format specifierERROR StatusLogger Unrecognized conversion This is simular to w

Recently we started upgrading ColdFusion from 2016 to 2021.So tried to install ColdFusion 2021 and using 30 days free trial for testing purposeApplication can’t make Database Calls so can’t able to login into application and can’t perform CURD operations.Below are orm settings in application.ormenabled = true;ormsettings = {};ormsettings.cfclocation = [… ];ormSettings.dbcreate = "update";ormSettings.flushAtRequestEnd = false;ormsettings.eventhandling = true;ormSettings.automanageSession = false;ormSettings.savemapping = false;ormSettings.skipCFCwitherror = false;ormSettings.useDBforMapping = true;ormSettings.autogenmap = true;ormSettings.logsql = true; And below are some errors on Hibernate level.Error executing DDL via JDBC StatementGetting this error when adding new properties on entities like case, group. Because those are reserved words in database Tried below options to resolve this issue but none helpful.Adding hibernate properites as  jvm arguments, orm properties

We cannot get a valid Serial number for CF10 to work when upgrading from CF10 to CF2021.The CF10 says the number is invalid however the serial number has been checked and is valid.How do we get around this to make the install work?

After a lot of blood sweat and tears I got the pdfg servlet running on my Redhat 8 Linux server.  A could of bugs that I found are:1. The <installdirectory>cfjetty file is not reflective of the java path that the user chooses during install.  I had to update the SOLR_JVM to my java path and delete the jre folder that was put there during install.2. If you stop the pdf service it "unregisters" it from your CF instance.  When you start the service it doesn't "register" the service so you have to bounce the entire CF instance to pick it up again. Also, since you cannot rely on the fonts like a Windows install it looks only at <installdirectory>/webapps/PDFgServlet/Resources/fonts where you are given very limited font options.  I do not feel I should have to pay for Adobe .otf fonts.  Please provide some.

We are using ColdFusion 2018 on a Windows Server 2016 machine.  We upgraded to CF2018 in March and all code has been working fine.  Last night, some Windows patches were applied, and today, any <cffile> or <cfdirectory> access causes it to fail with the following error.  Other tags seem to work fine.  As you can see, we can't even open the administrator tool right now to check other settings. at java.base/java.lang.Thread.run(Thread.java:834) "Error","http-nio-8500-exec-3","05/21/21","09:35:27","cfadmin","Could not initialize class coldfusion.tagext.io.FileUtils The specific sequence of files included or processed is: E:\ColdFusion2018\cfusion\wwwroot\CFIDE\administrator\index.cfm, line: 442 " java.lang.NoClassDefFoundError: Could not initialize class coldfusion.tagext.io.FileUtils at coldfusion.tagext.io.FileTag.read(FileTag.java:576) at coldfusion.tagext.io.FileTag.doStartTag(FileTag.java:393) Memory was initially at 95% so we added more and

 I work for a non-profit school and use ColdFusion for some of our custom web app stuff needs.  I am defintiely no expert in coldfusion coding. I would like to create a form we can send applicants to so they can select the position they want to apply for, provide some basic contact information, and upload their resume and optionally a separate cover letter if it is not already part of the resume. I have been asked to make the resume a requirement to submit the form and I cannot figure out how to make a file upload on a form a requirement - is this possible? Can you point me in the right direction for accomplishing this?

I'm suddenly receiving the error message "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values." This is a development site on my local machine. Everything was working until I changed the database associated with the datasource. When I refreshed the page, I got the message above. Now none of the pages work. It's an old application using Fusebox 5.5 and I'm migrating it from ColdFusion 11 to ColdFusion 2018. I'm not skilled at reading stack trace, but here it is in case someone sees something useful. Thank you!Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:86.0) Gecko/20100101 Firefox/86.0Remote Address 127.0.0.1ReferrerDate/Time 23-Mar-21 03:35 PMStack Tracejava.lang.NullPoin

Hi! I need some experts here.. I really need to know if it's possible to select traced text without using the pen tool. I had uploaded a sketch of boxing gloves with signatures on them - I vectorized the image and traced it so it looks good, but I need to change the color of the traced text. However, it's very hard to get a detailed selection because they are signatures.  I know I can take the pen tool and create strokes around the text to change the color that way, but there are about 100 signatures so I'm wondering if there's an easier way. Thank you!!!

Hi, Have a query with total just 40 records in it. It is giving a timeout connection error to databasewhen running as scheduler.But,its working fine when we execute separately this query in a test page.Also,the scheduler ran at 2 times one at 6am and another 9.30 am. Its working without error on 6amwhile its giving db connection timeout error at 9.30. Checked the coldfusion out log file,but could not find any trace of the error.Any guidance is appreciated.

I have an application that runs on CF 2018. This issue happens with Chrome but I don't know if it would or wouldn't happen with other browsers.  The app uses ORM and ajax to load records that are browsed with arrows. So, let's say an order has 10 items, so users click on arrows to go to item 1, 2, etc. The item page has a fillable form that's loaded without page refresh using ajax for existing items. The issue that seems to be random that I haven't been able to replicate myself but I've seen it happen with users: Sometimes the data from the form on item 4 is saved to item 3.  Form submit is triggered anytime any input is changed. The save is done by the primary key in the table being updated. This happens very rarely but it does somehow. I also have an audit trail going of every change and I can see that user didn't duplicate those records from one item to another.  Please advise on what to test or look for. Maybe it's some setting in cf admin? I

Hi there,When creating a line chart of type JPG or PNG, incorrect $ITEMLABEL$ are passed to the javascript code specified in the url attribute if there are more than 10 data points in the x axis. Just submited a bug report along with sample code to reproduce the problem. https://tracker.adobe.com/#/view/CF-4209142 Thought I may post here to in case someone has a better work around.  Cheers

Salivations!I'm working with a service provider that stores .wav audio files that my application needs to retrieve. I make a service call which returns a URL to the audio file I need. I then attempt to use cfhttp to retrieve the file, and run into problems. The URL looks something like:https://site.com/retriever/replay?audio:format=portable&encryption=None&primaryinum=xxx&transactionid=xxx&token=xxxxx  <cfhttp url="#thisFileUrl#" getAsBinary = "no" method="GET" throwOnError="no" useragent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36 Edg/90.0.818.62" timeout="15" file="myFile.wav" path="C:\inetpub\wwwroot\ccAudio4_client\" > <cfhttpparam type="header" name="Connection" value="keep-alive" /> <!---<cfhttpparam type="Header" name="Accept" value="audio/wav;audio/x-wav;image/svg+xml">---> </cfhttp> When I do not include the

Hello we use Coldfusion 10 and I'm having issues with a form and having it be grayed out until a check box is selected. Here's a small part of the field I'm trying to do. What an I missing? <form action="TransactD.cfm" Target="body" method="post"><input type="hidden" name="Receiveall" value="1"><input type="submit" value="Receive all" disabled class="rabutton" onClick="this.form.submit();"> <input type="checkbox" name="checkbox-0" class="rabutton"></form><script id="jsbin-javascript">$(".rabutton").on("change", function(e){if($(".rabutton").attr("checked")){$(".submit").button("enable");} else {$(".submit").button("disable");}});</script> Any help would be great thanks.

Language learning web site needs some repairs and changes. Cold Fusion and PHP. I need a long time worker and quotes for work done. Thanks Brian

Hello,We are working with an application in which CF REST services are being developed, however, we have noticed that ColdFusion 2018 Enterprise is generating documentation using the Swagger Specification version 1.2. Is there a ColdFusion Server update that allows the swagger documentation to be generated according to the Swagger Specification version 2.0 or 3.0? Or some other solution to solve the situation.

I've been trying to access a list in SharePoint Online using the few examples of sample code found in this forum and elsewhere online.  I'm attempting to use Basic authentication with an account I created in our O365 tenant that does not require MFA or other device trust requirements.  I've changed the password after first logon and have successfully opened and viewed the list in a browser on my computer.When I try to connect using CFSharepoint from the ColdFusion Server, I always get a 403 Forbidden error.  I don't see any failed logon attempts in the Azure Active Directory logs.Cannot perform web service invocation getlistitems. The fault returned when invoking the web service operation is: AxisFault faultCode: {http://xml.apache.org/axis/}HTTP faultSubcode: faultString: (403)Forbidden faultActor: faultNode: faultDetail: {}:return code: 403 403 FORBIDDEN {http://xml.apache.org/axis/}HttpErrorCode:403 the code I'm trying is as follows:<cfset SPUsern

Hi, The iif() is returning boolean when json serialized it's returning string instead of boolean. Thanks. Tested on Adobe Coldfusion 2021. Here is the code:<cfscript>local.test = true;local.return = {"hasFeed" = iif(local.test,true,false)};writeoutput(serializejson(local.return));</cfscript> 

Where can I find Coldfusion2021 linux systemd system file or do we have to write at our end?

Suddenly getting java.lang.NullPointerException coldfusion.CfmServlet.init(http://CfmServlet.java:99) errors for ColdFusion 2021 server instances that are started using a Windows Service config using an Active Directory account rather than the Local System account.I have the sames setup on both CF2018 and 2021 servers and haven't seen this issue before. Seems to have started happening after a Windows Update and subsequent reboot. KB5001347. I did uninstall it, but that' didnt' resolve the issue. If I change the Windows Service login back to Local System, site performs as expected.Here's what is being returned by the server.HTTP Status 500 – Internal Server ErrorType Exception ReportMessage java.lang.NullPointerExceptionDescription The server encountered an unexpected condition that prevented it from fulfilling the request.Exceptionjavax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java

I have an ID (primary key) set as a BIGINT in SQL SERVER. I have a query with the following: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.id#"> I then got an invalid data type for it. I then tried: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#URL.id#"> I still got an invalid data type for it. i then tried: WHERE whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#URL.id#"> and it worked. The weird thing is cf_sql_int is not even listed as being accepted: http://www.adobe.com/livedocs/coldfusion/5.0/CFML_Reference/Tags79.htm Can some explain this to me.

I'm getting the following error trying to install CF 2021 on virtual Windows 10 (VirtualBox)."Invalid directory path for Coldfusion Home." The error happened when I clicked "Next" on the "ColdFusion Installation Directory". The directory I entered was "C:\ColdFusion2021". The directory definitely exists.