ColdFusion

The below shown code works well on CF8. password can get from DB successfully. But it doesn't work on CF11. It can't retrive password from DB. Password is always empty. username and datasource can get from DB. The password stored in DB is displayed as:0-8VB>D;.<MQ95X$(5M2$>P   I guess maybe CF11 variable can't store complex/special string? How to save it? I need get password from DB and then decrypt it.<cfquery datasource="#XXXX#" name="GetConfig">SELECT S.A,IsNull(ds.column_a, '') AS DataSource,IsNull(un.column_a, '') AS Username,IsNull(pw.column_a, '') AS Password FROM (SELECT column_a AS A FROM table_a WHERE column_b='xxxx1') s LEFT JOIN table_a ds ON ds.column_b='xxxx2' LEFT JOIN table_a un ON un.column_b='xxxx3' LEFT JOIN table_a pw ON pw.column_b='xxxx4'</cfquery><cfset qDataSource = GetConfig.DataSource /><cfset qUsername = GetConfig.Username /><cfset qPassword = GetConfig.Password /><cfoutput><p>datasource:#qDataSourc

I have a project which can be considered as a heavy load application. I have bought 3 primary server and 3 back up server from Amazon , primary is of 32 cup with 244 gb ram and Secondary  server with 16 cpu with 122 gb ram . Can someone suggest to do the Coldfusion tuning because now the Coldfusion server is not listening when load is increasing, please advise

Working with CF2016 has been quite the adventure...One major annoyance (bug) I have come across is being unable to manage multiple Administrator sites for separate instances running on the same server.To reproduce this, open Chrome and browse in 1 tab to the Default Tomcat administrator area https://wt-cf2016-1:8443/CFIDE/administrator​ and login.Next, open a second tab and browse to another instance running on the same box https://wt-cf2016-1:8601/CFIDE/administrator and don't loginSelect your original tab from the first step and click on any menu link to the left.  You will be instantly logged out.What is ironic about this, is that I can be logged in to the same instance multiple times in the same Chrome browser with the Allow concurrent login sessions for Administrator Console enabled...Anyone have a work around for this?

I am upgrading an old CF 8 application to CF 10.  The first error I have encountered after upgrading is in my application.cfm and the site won't load at all."The client scope settings combination is invalid.  The clientscopestorage is set to use cookies, but setclientcookies is not set to yes."What is clientscopestorage?  It's not a valid attribute of the cfapplication tag.  I can't turn up that attribute in any searches on the forums, in the documentation, nor via Google.  I tried setting loginStorage and clientStorage to settings other than cookies, just in case that's what it meant.  But that didn't work.  I suppose I could set setclientcookies to Yes, but that's not how the application used to operate so I'd rather figure out how to fix clientscopestorage, whatever that is.Thanks,Tom

I inherited an application a few years ago and up until today, a particular part of the code has worked flawlessly.   It was supposed to upload a pdf file and attach it to a record in the database.  Now, I receive a generic message and I have no clue what is wrong.  I mostly am an Oracle DBA and can do enough CF to get by, until now.   What can I add to this to help give me an idea of what is wrong?  Thanx.  In the below code piece, the cflocation line just goes on, but I can't do that here.<cftry>   <cffile action = "upload"                fileField = "requiredFILENAME"                destination = #newDest#                   accept = "application/pdf"><cfcatch>   <CFLOCATION url="upl

Series of events (re-occurring events) are not displaying properly. Only the 1st instance is showing when I do a GET.It works fine previously on Exchange 2007 before we upgraded to Exchange  2013.I noticed that the recurrenceid is empty but it had value when the mailbox/calendar was still on Exchange 2007EnvironmentColdfusion 11Exchange 2013Has anyone come across this issue?  Not sure if it is CF or our new exchange server that is causing this issue.Thanks,Chris

I have the following cfquery wich fails in CF and the sql in the error code is exactly the same as listed here and will work fine when placed back in sqlserver.. code will work when this section is removed: and t.EmployeeNumber in       (select std_user_id         from HED.dbo.EDD_CPR_EMP        where TERMINATION_DATE is null)    why it is not working with above code and how to make it work??my code:<html> <head> <title>Retrieving data from Data Base</title> </head> <body> <!--- Set Datasource(s) ---><cfset intellex_datasource = "Intelex"><CFQUERY NAME="get_data" datasource="#intellex_datasource#">   select   distinct            c.CourseTypeName                  

I just updated to ColdFusion Builder 2016.  The 3 tabs,Source view and the two Default Browser view tabshave disappeared.  I have searched Adobe.com, Help, and only found one reference on this page:ColdFusion Help | ColdFusion Builder Workbench BasicsIt says,The Source view displays the source code for files. The Default Browser View displays the output in an HTML or CFML page.but doesn't explain how to make the views appear.Can anyone help with this?

Hello, all,I think I may have posted regarding this issue, before, but didn't get any response; I (unfortunately) have to try, again.I am using a Regular Expression to map the full physical location on the HD of where the website is located.  I need this for a CFFILE tag.The reason I'm using a RegEx instead of hard coding the location is because the location varies depending upon whether it is being used in development, staging, or production.  (Yeah, I know.. all three should be mirrors of each other - I'm working on that.  )For example, our DEV environment needs the CFFILE tag to point to E:\ColdFusion10\cfusion\wwwroot\www\ folder.Our staging environment needs the CFFILE tag to point to C:\ColdFusion10\cfusion\www\ folder.Our production environment needs the CFFILE to point to F:\webdocs\cf\www\docs\ folder.I really do NOT want to be hackish about this and use a CFIF or CFSWITCH to set the "this.webrootmapping" variable.  Besides, if anything gets changed, I'd h

Hello,We've an existing CF9 application with IIS 6, JRUN (web.config file) in Windows Server 2008 using Oracle database connection, as the licence of CF9 going to expire by this year we've already bought CF2016 and we're planning to upgrade as CF2016 and IIs 8 on Windows Server 2012, It's for a small application and we're not CF experts please let me know for below questions.1. Whether the tomcat software required for the above setup and why?.2. please let me know the installation details for the above setup, what all the software's need to install for it.Thanks a lot in advance.

Das erscheint wenn ich auf Seite bearbeiten klicke:Zugriff verweigert. Diese Datei ist möglicherweise nicht vorhanden oder es ist ein Problem mit der Berechtigung aufgetreten.

I am getting Oracle error ‘ORA-01461: can bind a LONG value only  for insert into a LONG column' when trying to insert into an ORACLE BLOB field. The error occurs when trying to insert a large BLOB (JPG), but does not occur when inserting a small (<1K) picture BLOB.(JPG). Any ideas?BTW, when using a SQL Server datasource using the same code.... everything works with no problems.ORACLE version is 11.2.0.1The ORACLE datasource is JDBC using Oracle's JDBC driver ojdbc6.jar v11.2.0.1 (I also have tried ojdbc5.jar v11.2.0.1; ojdbc5.jar v11.2.0.4; and ojdbc6.jar v11.2.0.4 with the same error result.)Here is my code:<cfset file_mime = Lcase(Right(postedXMLRoot.objname.XmlText, 3))><cfif file_mime EQ 'jpg'><cfset file_mime = 'jpeg'></cfif><cfset file_mime = 'data:image/' & file_mime & ';base64,'><cfset image64 = ImageReadBase64("#file_mime##postedXMLRoot.objbase64.XmlText#")><cfset ramfile = "ram://" & postedXMLRoot.objname.XmlText>

We have a custom built website with a lot of database integration (http://www.lake-link.com). We would like to have part of it run/managed using a CMS system for some content such as articles, press releases ect. I have briefly looked in to MURA. Can some kind of CMS system be plugged into an existing custom framework to handle content like this? The rest of the site is so data driven and customized I'm not sure a CMS system can do everything we need it to do for the site as a whole. Just looking for options for some content editors to manage some content without doing coding. Any advice is appreciated!

Hello everyone. I am in need to some help. I am migrating servers, and I am getting this error. I can't even get to the CF Admin. What do I do? My google-fu has not been very good on this error.HTTP Status 500 - java.lang.NullPointerExceptiontype Exception reportmessage java.lang.NullPointerExceptiondescription The server encountered an internal error that prevented it from fulfilling this request.exception javax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:198) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.proces

Hello everyone. In the cfmailparam file   the file to be attached must be on the web server coldfusion or may even be on another server?Thank's

Hello, all,We've been seeing a lot of the following, recently, in our logs:http://www.domain.com/getfile.cfm?uuid{a CF uuid}'A=0When I entered this in my browser, I was presented with a dialogue to open or save "getfile.cfm".  My boss was in a bit of a panic, thinking that someone found a way to download our .cfm templates, thusly exposing all of our code.As it turns out, all it is really getting is the HTML generated on the fly by our CF server.  Okay.. no more sweating bullets.. but, still a concern.What is the best way to thwart attempts like this (harmless as they are)?  I've got form and URL scopes going through both Portcullis and canonicalize().  What else can I do?Much appreciated.V/r,^_^

Hi all, I am new to coldfusion. I have a page which has multi select dropdown .After selecting click on ok button calls javascript and selected values of dropdown are populated in other multipick dropdown. My question all the selected dropdown options I am storing in javascript array. How can display those in coldfusion page. Please resolve this . Thanks in advance

HI,I am getting the following message when I try to access the Cold Fusion 11 site:Service Temporarily Unavailable!The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.   Jakarta/ISAPI/isapi_redirector/1.2.40 The site has update 3 installed. the server is 32 bit.The site was running just fine yesterday and then Cold Fusion Application Server was not running.When I try to restart the service the following message appears:Windows could not start ColdFusion 11 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2.The Event Viewer shows the following:The description for Event ID 259 from source ColdFusion 11 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

I use the same cfdocument call on two development and one production server:<cfsetting showdebugoutput="false" /><cfcontent TYPE="application/pdf" reset="yes"/> <cfheader name="content-disposition" value="attachment;filename=Details.pdf"/><cfdocument format="PDF" mimetype="application/pdf" backgroundvisible="yes" overwrite="yes" fontembed="no" bookmark="true" localurl="no" ><style type="text/css" media="screen">@1552174 "style1.css";</style>     -- content ---</cfdocument>Now this code runs perfectly on my local computer, it does not run in my development environment on remote computer, it DOES run on my multi-homed, remote production server in the inetpub/wwwroot directory but it produces a 30 second timeout error on the same production server in the inetpub/mysite directory (all other cf code runs fine.)The the content is the same, directory structures are the same, the template names are all the same (except for the serve

I have multipe dropdown list in a html form, now i have to store selected values to database using coldfusion[Moved from the general Adobe forum lounge to a product-specific support forum - Mod]

Hello Community!Working on application isolation paired with multi instance load balancing and came across what I would consider a bug.The uriworkermap.properties file included in the mod_jk.conf for Apache on RHEL 7 is seemingly completely ignored by my virtualhost.In all the documentation I came across, the uriworkermap.properties is where to specify the mount points for each of the workers.What clued me into it not working as I had anticipated, was that every time I ran ab to test the load balancing between different application paths, the first worker listed in workers.properties->worker.list would always handle the requests.The solutions I have come across so far :1. Include the uriworkermap.properties inside of the <virtualhost> configJkMountFile "/opt/coldfusion2016/config/wsconfig/1/uriworkermap.properties"2. Or Add JkMount entries in the <virtualhost> config#Load balanced application isolationJkMount /mysecureapp1 secureappsJKMount /mysecureapp1/* secureappsJKMo

The code is no longer worked on some Chrome/IE browsers. It will open Excel but nothing loads. <cfheader name="Content-Disposition" value="inline; filename=Report.xls"> <cfcontent type="application/vnd.msexcel">

Hi, I would like to know if Oracle stored procedure are supported in Coldfusion 2016 Standard (exept for reference cursors).I try to call a simply stored procedure like this:CREATE OR REPLACE PROCEDURE MYDATABASE.TEST_PROC( FIRSTNAME IN VARCHAR2,LASTNAME IN VARCHAR2,FULLNAME OUT VARCHAR2)ASBEGIN  FULLNAME := FIRSTNAME || '  ' || LASTNAME;END;/With this coldfusion code:<cfstoredproc procedure="TEST_PROC" datasource="mydatasource" returncode="No">   <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FIRSTNAME" value="John">  <cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" dbvarname=":LASTNAME" value="Doe">  <cfprocparam type="Out" cfsqltype="CF_SQL_VARCHAR" dbvarname=":FULLNAME" variable="fullname"> </cfstoredproc>But I receive this error:ErrorCode 17041Message Missing IN or OUT parameter at index:: 4Anyone can help me?

Hello Community!If you are running Coldfusion 2016 Enterprise Instance Manager and have a Tomcat connector for the primary cfusion instance running TLS, you won't be able to start new instances.As it turns out, this happens because the instance manager creating the new instance doesn't know how to handle a TLS connector port of 8443 and mostly clones it verbatim.When trying to manually start the new instance, you will see something like this :sudo ./cfstart.sh Starting ColdFusion 2016 server ...The ColdFusion 2016 server is starting up and will be available shortly.Some other server/application is using the port 8443Change the server connector port in the file /opt/coldfusion2016/cfusion1/runtime/conf/server.xml and start the server.Exiting .....Ex: <Connector port="8502"The solution is to modify the Instance's TLS port to an available one :<Connector scheme="https" keyAlias="test" useServerCipherSuiteOrder="true" secure="true" protocol="org.apache.coyote.http11.Http11Nio2Protoco

Hi guys, going nuts trying to figure this out....I'm using a function within a CFC to dynamically populate 3 select boxes with data, which works fine.........The problem is, anytime one of the dropdowns pulling from the database contains a comma (such as in the phrase DRIVER'S), the page either produces a bind error, or the effected box populates as blank...This only happens on any data containing a comma.....I've tried using CFQUERYPARAM in the query, but that's not making any difference in this respect.The CFC:<!--- GET APPLICATIONS BASED ON LOCATION --->    <cffunction name="getApplications" access="remote" returnType="query">        <cfargument name="Location" type="string" required="no">        <!--- Get data --->        <cfquery name="data_applications" datasource="#application.dsn#">