Questions

We've been having issues with our CF2016 setup (prod environment) and I want to try and replicate it on my local. Is there a way I can export the prod settings and then import it to my local instance? perhaps it's as easy as copy 1 file from server to the other? Thanks!

Once a month Quickbooks generates a SQL table of approximately 1000 transactions to process on Stripe. I'm looking for suggestions on how to best process this many transactions instead of cfloop. My concerns with cfloop are what if it crashes where do I restart and timeouts. Once they're processed the record is deleted.  Here are my thoughts: ProcessPayment CFM page:Select Top1 from ToBeProcessed<cfif if ToBeProcessed.recordcount GT 1><!--- Process Stripe Transaction --->Delete from ToBeProcessed transaction x<cflocation processpayment.cfm></cfif> This would loop over the table one transaction at a time, process it, delete it, then start again.Thoughts? Is there a better way? Gary 

I need a simple discussion forum messaging system written exclusively in ColdFusion for our website and for the general public. Just a simple post and reply of messages designed to work with SQL databases, easy to configure and operate. I can build on it. I'd be forever greatful. 

Hi we are trying to start using the CF18 API Manager.  We think we have everything setup correctly and are trying to use one of the examples in the getting started guide [https://helpx.adobe.com/coldfusion/api-manager/getting-started-coldfusion-api-manager.html] Creating a REST API  /GetIncomeHouseValueByAddress.   After I setup the API when testing the API [key in the address and hit Run API] - I receive the response error below. Response Body{"error": "There was some error while invoking the API.Verify and try again"} I have searched and have not found anything yet to help.  Any help or any other examples to try would be appreciated.thanksNicole

One of the Coldfusion applications I manage is currently making simple LDAP Binds to a Domain Controller over port 389. This is bad as it is sending credentials in cleartext, so I am trying to update the cfldap tag to make a secure connection over port 636. This currently looks something like the following: <cfldap action="QUERY" name="ldap_query" attributes="#variables.attributes#" start="#variables.start#" scope="SUBTREE" maxrows="20" filter="(sAMAccountName=#arguments.theUsername#)" server="#variables.ldapServer#" port="636" username="#arguments.theUsername#" password="#arguments.thePassword#" secure="CFSSL_BASIC"> I'm getting the following error: Detail: One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server.Message: An error has occurred while trying to execute query :<servername>:636. I found the following within the cfldap docs: If you u

Hi, I want to upgrade from coldfusion 2016 to 2018, is there a discount for just the upgrade or what is the price?

Hi all, I have use the cfhttp to call the API and upload a document on it. In hte cfhttp, i have insert <cfhttpparam name="Authorization" type="header" value="BASIC #token#">. The #token# is combination of Key:Secret. When i run this, I still get a result "HTTP Status 401 – Unauthorized, Full authentication is required to access this resource, The request has not been applied because it lacks valid authentication credentials for the target resource." The key and secret is worked when i try in POSTMAN. I really have no idea on it, I already stuck with this few weeks. Hope someone can help...

Hello,I have a Coldfusion 2016 instance on Windows 2012R2, started from the AWS Marketplace, and an RDS MySQL instance. Both instances are on the same VPC and subnet. I am unable to connect ColdFusion 2016 to the RDS MySQL instance.  I have created an ODBC in ColdFusion 2016. When ColdFusion tries to connect to the RDS MySQL I get an error. I have tried with the two drivers for MySQL included in Coldfusion 2016.With the ColdFusion driver MySQL (DataDirect)  I get the following error:Connection verification failed for data source: MSQL_Desajava.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.The root cause was that: java.sql.SQLException: [Macromedia][MySQL JDBC Driver]Connections to MySQL Community Server are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.With the ColdFusion driver MySQL 5 I get the following

Hi there, I would like to query the google ads Api. However I cannot find any information online how to set this up for colfusion. Has anyone any experience with this and can point me in the right direction for setting up this api connection.

Hi,Im including a barcode in a email, within a  cfloop:<cfset myImage=ImageNew("",200,70,"grayscale","white")><cfset attr = StructNew()><cfset attr.font="Archon Code 39 Barcode"><cfset attr.size=50><cfset ImageSetDrawingColor(myImage,"black")><cfset ImageAddBorder(myImage,1,"black")><cfset ImageDrawText(myImage,"*#email.unique_id#*",15,50,attr)><cfset ImageWrite(myImage, "ram:///barcode#email.unique_id#.jpg", 1, "true")> within cfmail tag: <img src="cid:Barcode#email.unique_id#" width="200" height="70" alt="#email.unique_id# Barcode" /><cfmailparam file="ram:///barcode#email.unique_id#.jpg"contentid="Barcode#email.unique_id#"disposition="inline" /> The image is re-created each loop, but I had to give it a unique name per loop as the image never changed in the email. Do you have to "dispose" of the image each loop?Do I have to delete the image of out RAM ?Any extra tips you have\best practice?Thanks,&nb

Hello Guys,  how to fix "unable to execute the desired program installanywhere adobe" "Please get another Copy of the installer and try again"         I already run using administrator, off windows firewall, off anti virus and update windowsany solution to fix ? thank you

Hello there. I cannot get my datasource connected to a Windows 2016 SQL Server from my CF 10 Enterprise. I've updated to the latest patches.I think I have to download the MS java db drivers for it to connect, correct?    

Hello Everyone;I'm hoping someone can give me some guidance on the issue that I'm having.  I am working on some code for a photo badge card.  After the photo is taken I click a print preview button that opens the badge in a PDF of the badge and I print it from there.  However, I get the following error:The Base64 data is not in proper format. Data should be in the format understood by the <img> tag in HTML, which is "data:image/jpg;base64,[base64 data]"<cfset myImage = ImageReadBase64("#form.xBase64PhotoString#")> <cfimage source="#myImage#" destination="c:/workgroups/webdata/badgecards/#BadgPhotoName#" action="write" overwrite="Yes">This is my first experience with photos so I would appreciate any help that I can get.  Please let me know if you need anymore information. 

Last week I spent a week trying to get a MySQL DSN setup. I gave up after 12 hours of trying. Last month I spent hours trying to set up a cf DSN in access. That didn't work. This weekend I've tried to set up a CF DSN using MS SQL Server 15.0. Again I can't get it to work. Is there a database that I can easily connect CF to anymore?Should I use windows authentication for the MS SQL or SQL Server authentication, do I need a connection string, what do I need to do?It seems like its harder than ever just to get going using CF.  

  The minute drop down works fine in CF9, but my development server has 2018 on it because we are looking at upgrading.  However, I am getting a runtime error on the minute dropdown in 2018.  My problem is, I can't figure out how to set a number range for the minutes.   <cfset fullStartDate=CreateDateTime(DateFormat(form.STARTDATE,'yyyy'), DateFormat(form.STARTDATE,'mm'), DateFormat(form.STARTDATE,'dd'),Form.STARTHOUR, Form.STARTMINUTE,0)> This is the code that works just fine in CF9.

Is there a way with ColdFusion to configure a website for access without the 'www' domain name prefix?I know you normally would change the DNS settings to do this. But is there a way that if someone goes herehttps://mywebsite.com/That Coldfusion can redirect them to herehttps://www.mywebsite.com/ 

I've tried both 2016.0.14 and 2018.0.8 docker images and both don't seem to recognize any jars that I place in the CustomTags directory. I've also tried adding new CustomTags locations and that doesn't work as well. I don't know what would be breaking this by default. Seems like I can't be the only person that wants to run ColdFusion in a docker container and also needs to run some additional jars.

I've been using CF inside the firewall for years; I've never really had to do API calls.  That said, I have the below problem that I don't know how to solve and I'm hoping someone can help.  I have searched this site and StackOverFlow and while I find suggestions, I can't find an answer. Can someone help?  I have been experimenting with CFHTTP but can't seem to figure it out.  I'd provide a sample of what I'm doing, but I think I am so far off it won't help.Here is the information I received for this need: This API allows external systems to request a report and provides an endpoint to check for the status of the report's completion. Once completed, the contents of the report can be downloaded as a CSV file.  The flow for using the reports API is simple: send an HTTP POST request containing a JSON-formatted payload the metadata on what kind of report to run and what kinds of columns to include and what to filter by. If successful,

Hi, On this page: Getting started with Adobe ColdFusion (2018 release) There is a mention of a migration guide from older versions to CF 2018: If you are migrating from an older version of ColdFusion to ColdFusion (2018 release), refer to the migration guide.However, when I click on the "migration guide" link I get a page not found. Where can I get the CF 2018 migration guide? Specifically I have an old CF 9 server that I need to upgrade to 2018. Is there a way for me to upgrade the same server running CF 9 or am I better off creating a new server?

I'm sorry I'm coming to the forum for help - especially with as much help as I need. I've always used CF in a single environment never having done API's. I now have a need to get data off of a server and I can't figure this out. I've been scouring forums and found nothing. The company I am dealing with doesn't know anyone using CF. Here is their information: This API allows external systems to request a report and provides an endpoint to check for the status of the report's completion. Once completed, the contents of the report can be downloaded as a CSV file. The flow for using the reports API is simple: send an HTTP POST request containing a JSON-formatted payload the metadata on what kind of report to run and what kinds of columns to include and what to filter by. If successful, the response will contain the URL to poll for the status of the report that will be generated. Poll this URL until it shows a completed status and a URL where the final CSV file is located. You can

Is there an easy way to maintain datasources across multiple servers without having to log into each one? We have a collections of servers which are all sat behind a load balancer. Each server runs an instance of CF and requires various datasources added (tenants) on a regular basis. Currently we have to log into the admin of each one and add the datasource. Although not extremely time consuming, it would be handy to do it once from either a cental administrator or set up in a similar way to how they implements clustered scheduled tasks.  

My [CF_HOME]\cfusion\hf-updates\ directory saves all hotfixes. Can I remove the directories with the updates that are already installed to save up disk space, without messing up my production server?   I will keep the latest updates just in case off course but I am talking about the older ones.

I am having all kinds of issues after CF 2018 update 8. At the moment I am dealing with port conflicts after having to recreate several instances. The server.xml file sets ports in the following: <Server port="8031" shutdown="SHUTDOWN"><Connector port="8503" protocol="HTTP/1.1" redirectPort="8447"....../><Connector port="8030" protocol="AJP/1.3" redirectPort="8447" ..... />workers.properties file port: 8030 When I start CF, I can see via netstat that all of these ports get used, but there is also one more port that appears to be started as well, 8579, judging by the netstat before and after starting CF. I can't find where this port is coming from. I am unable to start all of my instances and I think it is this mystery port that is causeing the conflict. Any ideas what that is and where I can set it? 

I have developed and built my environment in coldFusion developer.  I purchased a stndard license and when I try to enter my license for standard edition i get the following.  Can this be done?  

I am using cflayout extensively in an app. But I find the debugging useless.  So I must be doing something wrong. It loads and I get error ... "Error retreiving markup for element cf_layoutareamanage: OK[Enable debugging by adding 'cfdebug' ...Adding that provides me with an AJAX window with error: error:http: Error retrieving markup for element cf_layoutareamanage : OKMore helpful?  I think not. What does one do to see the error?