ColdFusion

Hello,I have recently updated coldfusion from 2016 to 2021, before update I used following code to write an excel file with cells containig dropdown list <!--- Create an instance of a new spreadsheet ---> <cfset spreadsheet = spreadsheetNew("My Spreadsheet", true)> <!--- we need all this so we can have dropdowns ---> <cfset workbook = spreadsheet.getWorkBook()> <cfset worksheet = workbook.getSheet("My Spreadsheet")> <cfset dataValidationConstraint = createObject("java","org.apache.poi.xssf.usermodel.XSSFDataValidationConstraint")> <cfset cellRangeList = createObject("java","org.apache.poi.ss.util.CellRangeAddressList")> <cfset dataValidationHelper = createObject("java","org.apache.poi.xssf.usermodel.XSSFDataValidationHelper").init(worksheet)> <!--- Define cell list rowstart, rowend, column start, column end ---> <cfset list = cellRangeList.init(0, 0, 0, 0)> <cfset dvconstraint = dataValidationHelper.createExplicitLis

Hi all,Can anybody help me in resolving this issue. The details are mentioned below.I am generating PDF using <cfdocument> tag of Cold Fusion.I have a header and footer to be displayed on each page. I am rendering data in a table. If rows in the table exceed a page , and continue on the next page , I want the table headers to be repeated on each of the page.Example :Currently this is happening:Page Header Sr NoNameOccupation1AA2BB3CCPage Footer : Page No 1Page Header 4AA5BB6CCPage Footer : Page No 2--------------------------------------------------------------------------------------------------------------------------------------------------------What I want is : Page Header Sr NoNameOccupation1AA2BB3CC Page Footer : Page No 1 Page header Sr NoNameOccupation4AA5BB6CC Page Footer : Page No 2

I have Azure Container Instance running Coldfusion 2021 on Linux Server.I am getting Connection verification failed for PDF Service Manager: localhost.Connect to 127.0.0.1:8993 [/127.0.0.1] failed: Connection refused (Connection refused) http://127.0.0.1:8993/PDFgServlet/verify How to resolve this issue?  

I have a form that has a file input with the multiple attribute set. This form might also have other file uploads.If I use the FileUpload function specifying the multi-file input it will only upload the first file. If I use the FileUploadAll I cannot specify an input name, and it will upload all documents from all upload fields. It doesn't retain any information about which field the files came from, so I now have a jumble of files that I cannot usefully assign anywhere.In the FORM variables we get temp file names e.g. "neotmp11170355642215183856.tmp", but there is no information that I can find that would allow me to cross reference this to the results of FileUploadAll.I did see a post about using binary read operating on the temp filenames in the FORM variable, but this won't help as there is no information available telling me what the uploaded file was supposed to be (pdf/doc/etc) and the original filename.Is there any way around this where I can upload multiple files from "fi

Hi! I have not used CF for a long time and I'm coming back to CF 2021. I kind of recall that the older CF generations abandon CFFORM and CFINPUT or if it wasn't abandon I did not use them in my codes because I remember many CF programmers suggested me not to use them as they cause or may cause many issues (couldn't remember what exactly after all these years). With the newer CF version since 2016 does CF fixed or revised CFFORM and CFINPUT tags and they are now safe to use? I prefer to use these tags if they are not causing issues as I build a lot of forms (simple mostly) and required form authentication for required fields and so on. Using CFFORM, CFINPUTs actually help me speed up my work instead of building javascript everytime. Thank you for validating my knowledge as I've been absent from CF for so long.

Register now!   Adobe Connect is a powerful, flexible application that lets you run webinars, conferences, open office hours, team meetings and more. One of the more useful capabilities is the option of building your own custom pods to handle workloads, provide interactivity and expand the capabilities of Connect. In this session, Mark Takata, Technical Evangelist for Adobe ColdFusion, will take you from 0 – 100 in building a custom Connect pod which leverages Adobe ColdFusion, JavaScript & MySQL to build a custom conference scheduling application. Special guest Alistair Lee will join us briefly to explain Connect’s incredible features & answer questions regarding the Connect SDK.   Register now!

It's the time of the year when your favorite ColdFusion event is back with a bang! The last two years were a challenge for each one of us. The pandemic hit us hard and impacted us all. We had to resort to online meetups and organize the summit virtually.   This year, we are organizing the summit in person in Las Vegas. Grab your seats today. Meet with ace developers, ColdFusion experts, and hear from our own about what's ColdFusion is coming up in its next major release.    ColdFusion is a community-driven platform and we'll love to listen to your feedback and thoughts. Be there in Las Vegas and experience the next wave of innovation.   Key dates: When: Oct 3-4, Las Vegas How to register: Conference website

I design my first front end site using bootstrap.  I then export the bootstrap file into a regular HTML extension. I open the HTML file in dream Weaver and save that file as a.CFM extension. When I go to preview the page, all of the behaviors, the scroll, the modal all no longer works.  When I sAve the file extension back to an HTML file, everything works. Is there a method to allow the same behaviors to work under a cold fusion extensions as it does with the regular HTML extension? Does cold fusion work with bootstrap and JavaScript behaviors?

I installed ColdFusion 2021 and now I catch some error:class coldfusion.runtime.TemplateProxy cannot be cast to class coldfusion.runtime.Struct (coldfusion.runtime.TemplateProxy and coldfusion.runtime.Struct are in unnamed module of loader coldfusion.bootstrap.BootstrapClassLoader @3b2553d9)I investigated the issue and found that we can't use Structure this.EnvStruct.Items directly in the query. I fixed the query:But It's not a good idea, because we have a lot of functions when we use the structure, this code is working in Coldfusion11 and Coldfusion2018.  Could you help me?

Hi folks. I am trying to get data from an array in a JSON file. I create the variable webhook from the JSON. I need to get the product_ID from the two arrays.  When I dump webhook to a file, it looks like this:...line_items:[array]1) [struct]id: 14image:[struct]id: 57src: https://i0.wp.com/www.blah.com/wp-content/uploads/2022/07/block_logo_round.png?fit=1200%2C1200&ssl=1meta_data:[array]1) [struct]display_key: _reduced_stockdisplay_value: 1id: 155key: _reduced_stockvalue: 1name: Block & Tackle Smokehouse and Tavernparent_name: undefinedprice: 19product_id: 56quantity: 1sku: [empty string]subtotal: 19.00subtotal_tax: 0.002) [struct]id: 15image:[struct]id: [empty string]src: [empty string]meta_data:[array]1) [struct]display_key: _reduced_stockdisplay_value: 1id: 156key: _reduced_stockvalue: 1name: Paddle parent_name: undefinedprice: 54product_id: 82quantity: 1sku: [empty string]subtotal: 54.00subtotal_tax: 0.00First, I'm setting count to the Array Length.<cfset count

Hi, I am using Coldfusion 8. In CFIDE I saw "Connection String" parameter under Advanced setting for MSSQL Data connection. I was wondering if we can use it for failover using a connection string like: "Data Source=server1;FailoverPartner=server2;Initial Catalog=db_name;Uid=db_user;Pwd=db_pass;" Where server2 is mirrored database. thanks in advance :)

I am using the following:— ColdFusion 2021— SQL Server Express 2019— SQL Server Management Studio 18.12.1— Dreamweaver I'm trying to set up a data source in the database tab, but when I click on RDS Login, I get the following error message:1. The URL specified for this site's testing server may be incorrect: http://localhost:8500/estimates/2. The testing server may be incorrectly configured (for example, ColdFusion may not be running). I have created a data source in CF Aadmin, and I'm able to connect to the database, if I hard code the query into Dreamweaver, the query and code runs just fine.  I just can't do it through the database panel.  To clarify, the testing server is correct because I can view the files when I type in the URL. The ColdFusion server is running - I checked it in Windows >> Services.  I just can't connect to the database in Dreamweaver's Databases panel. Thank you.    

After upgrading my site from ColdFusion 11 to ColdFusion 2021, I'm receiving error messages that I can't decipher.  Can anyone tell me what is actually failing here?  For example, what does EXCEPTIONS <small><i>not set</i></small> mean? Funny that.  I've been doing this for two decades now and this is the first time I've been stumped by a ColdFusion error message.  I guess there's a first time for everything.  😄 Any assistance is appreciated.

Running into a cfimage problem trying to convert a tiff image to a PNG or JPG. PNG conversion results in a 0 byte file.  JPG conversion produces am image, but it is a negative of the original.<cfimage source="test.tif" action="convert" destination="test.jpg" overwrite="true">

When I first started writing ColdFusion code (in the Allaire days) a CFChart line graph would allow one to mouseover a datapoint and it would pop up the values of both axes in a sort of tooltip. When I upgraded to CF11 I lost the X axis information and would just get the Y axis datapoint. That sucked out loud, but I dealt with it. But now I've upgraded to CF2021 and have lost all the tooltip popups. I tried JPG, PNG, and HTML (which failed completely). What's going on? I have not changed the code since the earliest incarnation. I've attached one of the sections of code.

We have been developing ColdFusion applications for over 20 years and I cannot believe what I am seeing with the Adobe ColdFusion 2021 pricing. We have a client that we have been developing and maintaining an application for since the year 2000, one of oldest clients. Recently they sold the one divisions that uses the application to another company. So, they are going through the process of separating the parts of the business and moving the applications and network to the new entity. The new company have decided to move all the infrastructure from inhouse hosted systems to a Microsoft Azure hosted system. It is 2022, so they may as well host everything in the Cloud, makes senses and what better time to do it then we you have to set up all the systems. The current application is used by approximately 100 employees and is used inhouse only. The current system runs on Adobe ColdFusion Server 2016 Standard Edition with a Microsoft SQL Server back end. It isn’t a very complex sys

We are facing issues randomly while getting response from Slooce API to validate mobile numbers.Error message says connection failure while establishing connection.Here's the example of one of the API call:- "09/07/22","02:40:44","","Starting HTTP request {URL='https://americalearns.cloud.sloocetech.net/slooce_apps/spi/americalrn80/13232523652/AMERICALEARNS/messages/supported', method='POST'}" Here's the screenshot of the response received , this error is not very frequent it comes sometimes. 

I am running CF10 fully updated (10,0,11,285437) and I cannot get the <cfschedule> tag pause/resume to work properly.  This is what I noticed at first, then I realized later the delete does not work either.  I always get:The following task could not be found: myTask.I am running CF10 64bit and Apache 2.2 (32bit) on Windows Server 2008 R2 and I am running virtual hosts under a single IP.  The <cfschedule> 'update' and 'list' tags work just fine as well do the 'pauseAll' and 'resumeAll' for groups.  I unfortunately do not have another 64bit server to attempt setting this up on again and verify the issue.  I'm hoping someone else can give me some ideas on where to go next here, because I really need to use this functionality and I've already had 1 other person tell me it works for them under CF10.Please, any help or suggestions on what to try would be really appreciated.Here's a paste of my sample code that breaks.<cfschedule action="update" task="m

I am taking over a website of approx. 100 pages with no loading panels. I would like to add a generic loading panel to the entire site without modifying all the pages.Is ther a simple way to add a loading panel to the entire site without modifying every page? 

Bonjour,J'ai bien compris le fonctionnement quand on connait le nombre déléments :<CFINPUT type="text" name="Iban1" mask="??00" size="4" maxlength="4">Par contre, je n'ai pas compris quand on connait pas la longeur à l'avance :Exemple : 0.50 ou 2.25 ou 65.85 ou 357 ou 1 253.35.D'autre existe-t-il un moyen pour empécher de saisir dans un champ suite à une condition non remplie.Merci d'avance pour votre aide. Hello,I understand how it works when you know the number of elements:<CFINPUT type="text" name="Iban1" mask="??00" size="4" maxlength="4">On the other hand, I did not understand when we do not know the length in advance:Example: 0.50 or 2.25 or 65.85 or 357 or 1,253.35.Else is there a way to prevent typing in a field following an unfulfilled condition.thank you in advance for your help.  

Hi,I'd like to experiment with Coldfusion and Adobe Sign. It uses OAuth.Some info: https://secure.au1.adobesign.com/public/static/oauthDoc.jspExample:<cfhttp result="result" method="GET" charset="utf-8" url="https://secure.na1.adobesign.com/public/oauth/v2"><cfhttpparamtype="FORMFIELD"name="response_type"value='code'/><cfhttpparamtype="FORMFIELD"name="client_id"value='my client id is omitted.'/><cfhttpparamtype="FORMFIELD"name="redirect_uri"value="https://localhost/testsign/redirect.cfm"/><cfhttpparamtype="FORMFIELD"name="scope"value='user_read:account+user_write:account+user_login:account+agreement_read:account+agreement_write:account+agreement_send:account+widget_read:account+widget_write:account+library_read:account+library_write:account+workflow_read:account+workflow_write:account'/><cfhttpparamtype="FORMFIELD"name="state"value='1234'/></cfhttp> If I cfdump the result the Status code is 200 OK It has has a Filecontent var con

I don't know what else to try.  I have created a fully functional ORM CRUD application that is working perfectly when I have the mapping cfc located in the root folder with the index.cfm file that is using it.  However, as soon as I move the mapping cfc into the "ORM" folder that is in the root folder and add the cfclocation attribute all I ever get is that it can't find the component or interface.  To make sure that it works and I don't have any strange errors I have (in the index.cfm file) instanciated it using createObject with a path of "orm.HistoricalEvents" and then dump it to the screen and that works just fine as well.  Below is my setup and directory structure.  If anyone has any suggestions i would love to hear them.  I love the ORM capabilities and want to use them but I don't want to have a pile of mapping cfcs just sitting in the root folder.Setup:Windows 7 Enterprise, 64 bitIIS 7.5File Directory/IIS Physical Path: C:\WebDev\DevGammaVirtual Di

 Hi everybody, I look for a gateway that watches changes in a database (e.g., insertions of records into a table, etc.), just like DirectoryWatcher monitors in a directory for files when they are created, modified, or deleted. Which of the existing CF gateways is most suited for this purpose? or might it work with a few changes???Is there a bespoke CF gateway that does this? Thank you in advance.

Just installed CF 2021, new server, migrated cfm code over. Setup external site in IIS. Removed the Default Site. Anytime the server is rebooted, we get a 500 error and a message cannot find component xxx.xxx.cfc. Once we restart the CF service, it all works until the next reboot. I tried both combinations of delayed start on CF and IIS but no change.  Re-reran ws-config (update and also remove/add).  No change.  Anyone seen this strange behavior? 

Does anyone have experience working with Adobe Sign and ColdFusion?  We are very new to Adobe Sign and are trying to integrate ColdFusion with it.  Our first question is; is there a way to seamlessly login to Adobe Sign using Single Sign On (Shibboleth, in our case), so that our Users do not have to have an Adobe Sign account?  Right now through Adobe Sign, we have to create an application to get an Application ID and a Client Secret Key that we then process through the application.cfc, that requires us to login to Adobe Sign upon entry to the website.  Our second question is; is there a way to send form values to a PDF to auto populate the form before it is sent for signing and/or approving?  Thank you in advance.