ColdFusion

(Testing on CF2016)I have test CFM file that creates an XML file with the result as:<TransferredValueTxn><TransferredValueTxnReq><ReqCat>TransferredUse</ReqCat><ReqAction>StatInq</ReqAction><Date>20100318</Date><Time>124430</Time><PartnerName>PARTNER</PartnerName><CardActionInfo><PIN>th2i-s4is-4a34-fa9k-e71u</PIN><AcctNum>optional</AcctNum><SrcRefNum>987654</SrcRefNum></CardActionInfo></TransferredValueTxnReq></TransferredValueTxn>I use another CFM page to retrieve this data:<cfhttp url="http://127.0.0.1/dev/api/test.cfm" method="get" result="objGet"><CFDUMP VAR="#objget#">This gives me all of the data in the FILECONTENT, which is<?xml version="1.0" ?> <TransferredValueTxn> <TransferredValueTxnReq> <ReqCat>TransferredUse</ReqCat> <ReqAction>StatInq</ReqAction> <Date>20100318</Date> <Time&

I have two function I am attempting to execute against an Oracle database. One with a single input parameter, one with multiple input parameters. The single input parameter function works just fine, the multiple input function I am stuck on.Single original function from the Oracle documentation:FUNCTION myfunction1(input_var IN NUMBER) RETURN VARCHAR2Calling the single function successfully:SELECT mypackage.myfunction1(#InputVariable#) AS OutputVariableFROM dualThis works just fine, but multiple input variables not so much....Multiple Input function from Oracle documentation: (uses var1 and 2 to compute Boolean response along with two status indicators)FUNCTION myvalidatefunction(input_var1 IN VARCHAR2,  input_var2 IN VARCHAR2,  status1 OUT VARCHAR2,  status2 OUT VARCHAR2) RETURN BOOLEANI have attempted calling this in a number of ways:SELECT mypackage.myvalidatefunction(#InputVar1#,#InputVar2#) AS OutputVariableFROM dualwith a variety of single and double quotes such as

Bonjour,Je suis maintenant à la retraite et j'ai récupéré un ensemble de programmes développés en Coldfusion.J'avoue ne pas être assez compétent pour les améliorer.Aussi, je cherche quelqu'un ayant déjà programmé en Coldfusion pour me donner gracieusement un coup de main pendant ses loisirs.Peut-être en tirons-ns quelque chose !L'idéal serait qu'il soit de la RP.OU qu'il me forme pour un prix modique de façon que je puisse faire évoluer ces programmes.A vous lireMarc

Hello,I'm having an issue using SFTP and FTP with ColdFusion Builder 2018.  I'm able to connect and browse the sites but I'm unable to open any of the files.   When I first connect and expand the directory structure I get several instances of the following error: An error has occurred. See error log for more details.Could not initialize class org.eclipse.rse.files.ui.resources.UniversalFileTransferUtilityThanks in advance

Hi,Is it possible to allow all HTTPS calls from ColdFusion/Java to be accepted and not check against the truststore? Looking to not have to reboot CF each time a new SSL needs applying onto a server.Cheers,

I have been evaluating the 2016 stand alone version of CFBUILDER Version: 3.1.1 Build: 298831 on Win 7 Enterprise 32-bit SP1 Core2 Duo CPU 2.2GHz 4GB Ram.There are CFM files it simply will not open. Double click file, cfbuilder enters into "not responding" mode, then comes back and the file was not loaded. Many of my files it opens fine, others not. This issue seems to be restricted to the larger files (i.e. 1.5K lines).Any help would be GREATLY appreciated.

I have CF installed and configured to worked with MongoDB using a Data Direct JDBC connector.I created a data source and specified a sample database name in the JDBC URL and all works fine.The problem now is, I want to use a different database, the actual one for my CF application, but when I edit the database name in the JDBC URL, I get the following error and when I change it back to the sample database name, it works fine:Connection verification failed for data source: OkDataSource3java.sql.SQLSyntaxErrorException: [DataDirect][MongoDB JDBC Driver][MongoDB]syntax error or access rule violation: invalid schema name: NEWDBThe root cause was that: java.sql.SQLSyntaxErrorException: [DataDirect][MongoDB JDBC Driver][MongoDB]syntax error or access rule violation: invalid schema name: NEWDBThe database name is correct.I have tried creating a new data source with my preferred database, I get the same error too.I am also unable to connect to a different Collection in the sample database othe

One of our vendors seems to have changed something on their end and my webservices call has broken.  I can't seem to convince the vendor the problem is on their end.  Am I wrong?At this point I'm just trying just a single line:<cfinvoke webservice="https://www.h2hdigitalrx.com/services/v4/PartnerIntegrationService?wsdl" method="test">and it throws this error about white spaces being required:Cannot generate stub objects for web service invocation.Name: https://www.h2hdigitalrx.com/services/v4/PartnerIntegrationService?wsdl. WSDL: https://www.h2hdigitalrx.com/services/v4/PartnerIntegrationService?wsdl. javax.wsdl.WSDLException: WSDLException (at /definitions/types/xsd:schema[1]): faultCode=PARSER_ERROR: Problem parsing 'http://www.h2hdigitalrx.com:80/services/v4/PartnerIntegrationService?xsd=1'.: org.xml.sax.SAXParseException: White spaces are required between publicId and systemId. It is recommended that you use a web browser to retrieve and examine the requested WSDL d

I have excel files on a Linux server that I need to copy to a windows server.So I can read the excel file on the windows server and use the data to autofill PDF's.Ideally, I would like to avoid the file transfer and just read from the excel on the Linux server.But the Linux server only hasRailo, but no CF, so I can't use <cfspreadsheet to read the needed info.Assuming all this is true, I need to copy the file from Linux server to Windows server.How do I do that?

I'm running CF9 currently and trying to cache a fragment of a page.  This fragment is dependent on a region code, so I want to cache it with a different cache ID for each region.  The region code is in a variable.  So I am trying to do the following in the page:<CFSET RegionID = 100><CFCACHE action="cache" ID="#RegionID#" timespan="#CreateTimeSpan(1,0,0,0)#">This is the content I want to cache for Region: <CFOUTPUT>#RegionID#</CFOUTPUT></CFCACHE>However it does not look like CF is using the value of the RegionID variable as the ID for the cached entity.  But it is actually using the string "#RegionID#" as the ID.  I can find this to be true by simply changing the RegionID value and I still get the same cached content as I had for the previous cache.  So I can not cache it for each region differently!Am I doing something wrong?  A different approach perhaps?

Hey all,We have a bit of an odd issue on one of our Linux CentOS 7 64bit servers with ColdFusion 11 Enterprise (latest patches installed), when we use features in CFImage we get the following logged errors:ERROR"Error","ajp-bio-8014-exec-5","03/13/17","15:29:25",,"Could not initialize class javax.media.jai.JAI The specific sequence of files included or processed is: /home/test/public_html/test.cfm, line: 8 "java.lang.NoClassDefFoundError: Could not initialize class javax.media.jai.JAI  at coldfusion.image.Image.crop(Image.java:1177)  at coldfusion.runtime.CFPage.ImageCrop(CFPage.java:7683)SYSTEMServer DetailsServer ProductColdFusionVersion11,0,11,301867Tomcat Version7.0.68.0EditionEnterprise  Operating SystemUNIX  OS Version3.10.0-514.2.2.el7.x86_64  Update Levelopt/coldfusion11/cfusion/lib/updates/chf11000011.jar  Adobe Driver Version5.1.3 (Build 000094)  JVM DetailsJava Version1.8.0_121  Java VendorOracle Corporation  Java Vendor URLhttp:/

Dobrý den, mám tiskárnu EPSON WF-3720 a při scan dokumentu do souboru PDF mi to hlásí, že nemá nějaká písma.Děkuji

Hi there,I've just installed CF 2016. Previously, I had an application running in CF 11. When I run my application in CF2016, it doesn't work due to locking issue, specifically with the Transfer ORM. Here's the error that I got:A timeout occurred while attempting to lock transfer.Factory.transfer.com.sql.transaction.TransactionManager.I would like to know if there is a compatibility issue between CF 2016 and Transfer ORM. If it doesn't have compatibility issue, could you please advise how to resolve the lock issue with the Transfer ORM.Any feedback or suggestion is appreciated. Thank you.Kind Regards,Raquel Septiane

Can anyone please provide me some guidance towards applying dynamic reports and a google like search capability for our application. As of now we use verity for search but it seems verity has limitations. For reports what do you guys use to make dynamic reports ? is there a coldfusion plugin we can apply for reports ?Thank you for all the help

Hello,System - Windows 8.1 IIS CF2018 plus running CFML application.Condition - After completing CF2018 Server Auto-Lockdown I can browse to CFadmin on tomcat port but no longer have a working CFML application. Browsing webserver root reports:HTTP Error 500.0 - Internal Server ErrorCalling LoadLibraryEx on ISAPI filter "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" failedAdobe_ColdFusion_2018_Server_Auto-Lockdown_Install.log partly reports:Summary-------Installation: Successful with errors.70 Successes0 Warnings2 NonFatalErrors0 FatalErrorsTail of ServerLockdown_cfusion.log reports:2018-07-25 13:29:11 INFO  - ISAPI Filtering restored for global level!2018-07-25 13:29:11 INFO  - Trying to get all ISAPI Filter names for the website: Default Web Site2018-07-25 13:29:11 INFO  - Root element :appcmd2018-07-25 13:29:11 INFO  - No ISAPI filters found. There's nothing to restore2018-07-25 13:29:11 INFO  - Deleted the backup directory: C:\ColdFusion20

Hi,Is there away in Cold Fusion2016 to encrypt the contents of a create Excel file, either completely or by cell?Then allow the user to de-encrypt the Excel file after it has been created?Using the following to create an excel file. <cfset TabChar = Chr(9)><cfset NewLine = Chr(13) & Chr(10)><cfheader name="Content-Disposition" value="attachment; filename=reports.xls"><CFCONTENT TYPE="application/vnd.ms-excel" RESET="Yes">Thanks in advance,Mike

I have these mappings setup in my cfadmin for a PROD version of a website. They work fineNow I am going to create another site on the same CF2018 server, an almost mirror copy of this PROD site, but it will be a TEST version, named, GenCORP-TESTI understand I am going to need to do mappings like I did for my PROD site.I understand I'll need to use this.mappings for both the PROD and TEST versions of the site.And I will need to remove these existing mappings.I understand that the code goes into the application.cfcHow would I code a few of these mapping rows from above in PROD and TEST?and then would it start like this in the application.cfc<cfcomponent>  <cfscript>    THIS.name = "myName";    {etc.}    THIS.mappings = StructNew();    Then what??  </cfscript>

CF 2016MS SQL 2008Windows 2008 ServerI am trying to move my MS SQL database to a separate VPS which will sit within a private network.The new VPS server has been given the internal IP of 192.168.1.1 and the CF server has the internal IP of 192.168.1.2, these are on secondary adapaters, they also have their public IP's.I mapped a drive from the CF server to this new VPS database server and I was able to remotely browse the hard drive, so I know the connection between the two is functioning.I then went to the CF admin to try and connect to a test database, but I'm getting nowhere, all I get are timeouts trying to connect to the MS SQLI had made sure that SQL Server Browser service is running on the new database VPSRemote connections is also checked within MS SQLI also tried creating a new user within SQL and then using those credentials to connect.I've made sure the ports 1433 and 1433 on TCP and UDP are both open on the firewall for both servers.When adding the SERVER value in the conne

Can someone help me write a simple program?I want to create a program that allows my users to enter the temperature in Fahrenheit and get it returned in Centigrade, be able to enter miles per hour and get kilometers per hour and enter inches and get centimeters or enter yards and get meters.

MacOS Sierra plug-in configuration a qualified success.  However, I have no CFB perspective.Install log says:Installation: Successful with errors.6454 Successes0 Warnings2 NonFatalErrors0 FatalErrorsNon fatal errors being two occurrences ofModify Text File - Single File:   /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Eclipse/Eclipse.app/Contents/Info.plist                          Status: ERROR                          Additional Notes: ERROR - Unable to locate ASCII text file to be manipulated. Deferring...Indeed there is no such file, whereas there is a file /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Info.plist.  At the install log errors referenced path /Users/barrygbrunning/eclip

Hoping someone can help with this issue! I've set up ORM settings as below and my model is set up as listed. However, when utilizing, I keep getting an error that ID already exists and it appears CF is using hibernate_sequence instead of the sequence I'm specifying.  Furthermore, even with savemapping=true, it is not creating any hibernate xml files (supposed to be in same directory as models).I'm using Postgresql as the DB. I've tried restarting / different settings (even different JDBC drivers), etc without success. This code was working fine with CF10 and trying to upgrade (unsuccessfully) to CF2018. this["ormsettings"] = {      datasource = "db_icp",      eventHandling = false,      logsql=false,      savemapping=true,      cfclocation = application.mappings["models"]}; component name="logins" entityName="logins" persistent="true" table="logins"{        prope

So... finally got the lockdown issue all sorted out... but...Now when I try to access the .cfm test page I get:HTTP Error 404.2 - Not FoundThe page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server.Detailed Error Information:Module   IsapiModuleNotification   ExecuteRequestHandlerHandler   ExtensionlessUrlHandler-ISAPI-4.0_64bitError Code   0x800704ecRequested URL   http://127.0.0.1:80/Physical Path   D:\DATA\SITES\DefaultWebsiteLogon Method   AnonymousLogon User   AnonymousAny ideas?The page worked just fine before the lockdown tool was applied.

I am downloading CF2018 30-day free trial from hereDownload Adobe ColdFusion free trial | Adobe Coldfusion (2018 release) Is it still like its been in the past where after the 30-day trial it automatically goes to a single user version?

Hi,Sorry if this is a dumb question, I'm new to this.I have a form where i want the user to be able to upload an image from a form.  for the cffile i'm using<cfif len(trim(form.ImageData))>  <cffile action="upload"     fileField="ImageData"     destination="\uploads"     nameConflict = "MakeUnique"></cfif>it works locally when i input the specific directory on my hard drive but when i use the above online i get an access denied error and it looks like it's trying to save it locally on c:\uploadson my ftp i created an upload folder but I don't know what the 'destination' field typically looks like when you are trying to use cffile on a live site.  What information do i need from my web host to make this work? Like, does it involve an ip address?  I'm thinking some kind of username and password will be required.  does cffile have username password field too?  Basically, what shoudl

Server side, I am using developer edition on a Windows 10 64 bit VM.  I installed CF using the Developer Profile option, with defaults selected. Client side, web browser is Chrome on MacOS XYes, I am an admin on the box.Yes, I ran the installer as admin.Yes, I tried to run the CF service under a local admin account.No, there is no error in the console.Yes, /cf_scripts/scripts/chart/cfchart.js is loading as it should, though with a 304 response code.format="png" is working.Any ideas?Thanks!Alberto