ColdFusion

Hello, all,I have a form that when submitted to CF will perform validation, then insert all the information into 2 or 3 (depending) sheets in Excel, drop it into an email and send it off.The recipient of the email then puts focus on one of the sheets in Excel and does a "Save As.." into a tab-delimited txt file.  Easy peasy, right?The recipient then takes that txt file and submits it to ACT (I have no idea what ACT is, but I'm guessing it's another application that I don't have access to.)One minor problem, though, is that a few of the columns in the txt file have all associated values inside double quotes, which is screwing up inserting the data into ACT.Here is a txt file example:BOOKING     TYPE     ORIGIN     DESTINATIOND2D     DOD     "Charleston, SC"     "Destin, FL"D2D     NDOD     "St. Louis, MO"   &n

Hi,We planned to upgrade our ColdFusion9 version to ColdFusion2016. During installation, at 76% the process is not at all moving further. I am breaking my head with this silly issue. Tried reinstalling by quieting the current installation but was no luck. And one more point, before reinstalling again i tried to uninstall but it was throwing a fatal application error: "This Application has Unexpectedly Quit.  Invocation of this Java Application has caused an Invocation TargetException".  Please help me. Any suggestions are accepted.OS of the machine is Windows server 2008, 32-bit.RAM 4GB.Previous version of ColdFusion is ColdFusion9.Note that i am following the Adobe ColdFusion (2016 release) Migration guide.

Hi,i want to create a redirect to non latin URLs like<cflocation url="https://ru.wikipedia.org/wiki/Заглавная_страница" statuscode="302" addtoken="no"  />But in this case i will be redirected to https://ru.wikipedia.org/wiki/%20%20%20%20%20%20%20%20%20_ So the result is that i got the wrong URL.What can i do? suggestions?ThanksFelix

I'm tasked with installing Cold Fusion 9 on a box that already has Cold Fusion 7 on it.  They really want to have them running side by side.I have a few questions on this, and I'm hoping community support could help guide me in the best direction.1) From what I have read it is highly suggested to run only instance of CF on a server.  Can anyone further prove or dispel that suggestion?2)  I have the tag changes since version 5 and above as my first resource link below.  If we would move to strict CF 9, should it be relatively easy to upgrade?3) If I was going to have CF 9 and CF 7 run silmuntaneously on the same server it was suggested to install the new version first, and then the old version.  Well this server already has CF 7 running on it.  I don't think it would be wise to uninstall CF 7 just to install CF 9 first.  Do you agree?4)  If the versions were running side by side, what is the indicator that says one site or app runs which version o

I have an application that uses cfimage to load an image which is then resized (using imageresize) and overlaid with a watermark (using imagepaste).   It had been running for some time on a UNIX platform and now fails.  The error message is "could not initialize class javax.media.jai.JAI.  The error occurred with imageresize(imagename,300,"",highestPerformance)  and I can get past that error by using imageresize(imagename,300,"",highPerformance).However the same error then occurs on Imagepaste(image1,image2,0,0) and I have found no way around that problem.One development platform is a Win10 CF version 2016,0,03,300466 with Java version 1.8.0_72  and no such errors occur on the test system.Another development platform is a Win10 CF version 2016,0,0,297996 with Java version 1.8.0_72 and no errors occur on that test system.The production systems is UNIX CF versionj 2016,0,03,30046 with Java version 1.8.0_72 and errors occur there so the application no longer

Wildcard certificates on my ColdFusion 11 are expired, i am having the new certificates with me. How to import and install new certificates on the CF Servers

This is an older CRM application using CF 9 that hasn't been changed in over a year.As of Sunday between the hours of 8 AM and 4 PM cftoken/cfid disappear in the middle of loading the dashboard. 2/3 of the content appears and then the cfid/cftoken disappear. It only occurs at very specific times of the day.Any ideas?

Hi,Can someone tell me if antivirus software is recommend when doing strict validation on file uploads or using the PDF merge feature?Thanks in Advance.

Hi, I'm using Coldfusion 2016 and trying to consume a SAP web service using cfinvokeThe web Service requires authentication, so I'm including a username and password in the cfinvoke tag:<cfinvokewebservice="http://server:port/sap/bc/.../..bld?sap-client=xxx"username="MY-USERNAME"password="mypassword"refreshWSDL="yes"method="MY_METHOD"returnvariable="SAPRet"><cfinvokeargument name="ARG" value="0021002003" /></cfinvoke>I can trace the call to the webservice in Wireshark and see that the WSDL is retrieved just fine, but calling the actual method results in an "authorization failed" error. It seems that username/password specified in the cfinvoke tag are only used for retrieving the WSDL, as can be seen in the Wireshark trace, but they are not used for calling the method.Same error occurs when using cfobject to consume the webservice.When using SoapUI to consume the web service, I have to input username/password twice: Once for downloading the WSDL and once inside the req

I'm fairly new at CF and I have a question about some functionality that I'm struggling with a bit.I have a form with the following options field:<option value="#getPages.Title#" <cfif variables.fieldValue EQ getPages.Title>checked="checked"</cfif>>#Trim(getPages.Title)#</option>The value of #getPages.Title# is being populated from a database query call getPages. #getPages.Title# would output as a page title.  I have another value called #getPages.PageURL#.My question is, is it possible to apply  #getPages.PageURL# to #getPages.Title# so that when #getPages.Title# is output on a page it will be a link.I've tried the below but it obviously didn't work.<option value="<a href="#getPages.PageURL#">#getPages.Title#</a>" <cfif variables.fieldValue EQ getPages.Title>checked="checked"</cfif>>#Trim(getPages.Title)# </option>Any help with this would be greatly appreciated.Thanks,Robert

Our ColdFusion 10 Application Server would not start. It was running fine since server inception back in July until I got back to the office from vacation yesterday. Looking at the Event Viewer 'application' log, it's showing the following message:"The description for Event ID 259 from source ColdFusion 10 Application Server cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.If the event originated on another computer, the display information had to be saved with the event.The following information was included with the event: ColdFusion 10 Application Server."I thought that the issue was caused by Hotfix 14. So I manually removed the hotfix and rebooted the server couple of times. However, ColdFusion still wouldn't start. Has anyone came across this issue before? I look forward to your response. Thanks.Best regards,Chung Lee

This is under Security/CORS. I have an API that I had originally set the Allowed Origin at * while I was testing. This worked fine. Then, I decided I wanted to test limiting this to specific domains. However, for some reason, it wouldn't save the value I had entered. This is the format I entered it in: http://www.example.comAnd now, when I try to change it back to * it won't save, and I'm getting CORS errors when I call it. UPDATE: I also tried restarting the API Manager service and this didn't make any difference.

I am creating zip files using cfzip and it is basically zipping up some high rez images. So after the cfzip code I have the following <cfset TheFileName = "#ReReplace(GetImage.ItemNum, " ", "-", "ALL")#.zip"> <cfheader name="Content-disposition" value="attachment;filename=#TheFileName#"><cfcontent type="application/zip, application/x-zip, application/x-zip-compressed, application/octet-stream, application/x-compress, application/x-compressed, multipart/x-zip" file="#APPLICATION.ProductImageDirectory#\full-brands\#TheFileName#"> The problem I am having is it starts the download of the zip file before it is finished so it downloads a corrupt zip file each time. The zip file on the server is fine. Any idea how I can get the page execution to pause until the zip file is actually finished being created?

I have a resource I have set up in one of my APIs, which the user may call with different arguments to augment the result set. For example, the user may want to pull back all of the objects in the database. In this case, no arguments are sent and all items are returned. But, they may also want a specific category and they may want to limit the results to a certain number. If they provide a query string argument for category and another for limit, the web service responds accordingly. They may also want to retrieve just one record. If they pass an ID for the record, the web service just pulls back that one record.The trouble comes in when I implement caching for the API. After the response is cached for any set of arguments, it doesn't matter if I change the arguments, it still only pulls back the cached result set it originally returned when the cache was set.Is there any way I can get it to behave more like query caching in ColdFusion, where it will cache separate result sets when dif

As it is standard practice to send an ID to RESTful APIs by referring to the object type, followed by the ID...e.g. http://example.com/products/3484909would normally bring me back data for the product with ID 3484909.I can't seem to get API Manager to take this kind of argument, though. It's not a major issue, but it would appear the only thing I can do is call the following:http://example.com/products?id=3484909 to get the desired resultWith many platforms you can specify a variable to accept when identifying a route or resource but it doesn't appear there is any way to do this with API Manager. Has anyone seen anything like this or know a away around it?

How to change the name of an URL in ColdFusion 11 ?. Currently my site name is https://xyz.com i want to change it to https://xyz-new.com. I just want to change the url name.

Hello.Is/Has anyone using/used Coldfusion 8.0 with SQL Server 2014 or 2016?We currently have Coldfusion 8.0 and it works well with SQL Server 2012.Now, we are about to update our SQL Server to 2014 or 2016.Wondering if I need to ask for exception if 2014/2016 is incompatible with CF8.Thank you in advance!

GreetingsI successfully imported 2500+ records (individuals) from the Ancestry.com site in gedcom format to SQL server using "GEDMagic".Unfortunately, the individual/spouse connection is not imported.However, they were imported into SQL Server in PK pairs- John Smith is PK ID 200 & his spouse, Mary is PK ID 201.Each pair is one PK number + or -I am trying to avoid physically entering 2500 corresponding spouse ID's- I only have so much time left on earth.My question is- has anyone had experience dealing with importing GEDCOM db files to SQL, and/or at least advise a strategy to select the individual and his/her spouse easily with a query?I tried <cfquery name="get_ID" datasource="#Request.BaseDSN#">  SELECT ged_ID  FROM ged_main  </cfquery> <CFSET plusone =#get_ID.ged_ID# + 1>  <CFSET minusone =#get_ID.ged_ID# - 1> <cfquery name="find_spouse" datasource="#Request.BaseDSN#">SELECT *FROM ged_mainWHERE ged_ID = #plusone#OR ged_ID = #min

Hello, all,I just experienced an issue using example code in Adobe Support for cfmailparam.  I am using CF10.In the description there is sample code for attaching a file to an email.<cfmailparam name="anyname" contents="#variablename#">I followed this example and got an error message indicating that I was not using proper attributes.  As it turns out, the correct combination is:<cfmailparam file="anyname" contents="#variablename#">Just in case anyone at Adobe has the chance to correct it in the support section.V/r,^ _ ^

I just started using CFB 2016 and for the life of me can't figure out how to enable word wrap in the editor. I thought I'd found the setting, but wrapping still isn't working. TIA

Hello, all,If I have a form that uploads a file, and the action page for that upload just does a CFDUMP of the form scope, one of the things I've noticed is:form.uploadFile | {drive}:\ColdFusion\cfusion\runtime\work\Catalina\localhost\tmp\neotmp698498469158.tmpThis is the tmp directory where the web server uploads to for your CFFILE action="upload" to tell it where to be saved to.  Then, the .tmp file automatically deletes.I am trying to devise a way to use CFFILE action="readbinary" directly from the tmp folder, without using action="upload" to cut down on disk I/O.Is there a way to determine the tmp path and filename (other than CFDUMP) when the web server saves the file?  WITHOUT using action="upload".V/r,^ _ ^

Hello, all,I have worked extensively with the spreadsheet functionality in CF, and have to admit.. I love it.However, I am curious about one thing.  Does CF natively have a way to check a .xls(x) file for macros?Considering the environment that I work in, we do not allow macros in Excel spreadsheets on our network.  No exceptions.But the PTB (powers that be) here are considering setting up a web app that has a section that will allow authenticated users to upload .xlsx files.  So, I am trying to find a way in which to scan the file for macros before processing, and deny the file if it contains any macros.Is anyone aware of a way to do this?V/r,^ _ ^

After applying ColdFusion patch update 13 my client is saying that he is facing issues with REST API services. REST API function that exists on production servers is not reachable by other servers. It was like few servers was able to reach and few were failing. What might be the cause for the issue and how to solve it.These production servers make server to server calls, few were able to call and few were failing Is it really because of patch update 13 in ColdFusion 11.

82 Algorithm negotiation fail.I'm able to connect to the client using WinSCP, however I get this error when using ColdFusion 11.  Anyone else running into this?Simple code, using the credentials that work via WinSCP<cfftp action="open"port="22"username="#username#" connection="test_connection" password="#password#" fingerprint="#fingerprint#" server="#server#" secure="true">

CF Builder 3 will not accept my license key. The "OK" button does not become enabled after I input the key, so I cannot upgrade my installation from the (now expired) trial mode. The license keys I have tried are owned by my company and are legit. Has anyone experienced this, how can it be resolved?