Questions

My question, using coldfusion 11 enterprise datasource gui,how do you connect to oracle 12c multitenant database,when you need to log into a pluggable database, beneaththe container database?What's the connection string, or is it even possible to connect(?) because earlier versions of oracledidn't use multitenant architecture, you just make a user/password,grant connect privileges, and connect.Using Oracle Linux 6.5 64bit.This is assuming I can connect to the oracle CDB (container database) and PDB (pluggable database) from the shell using sqlplus.<!------------------------ I can tsnping the pluggable database name pdb1 ---------------------------------------------->[oracle@localhost ~]$ tnsping pdb1TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 27-JUN-2014 12:13:12Copyright (c) 1997, 2013, Oracle.  All rights reserved.Used parameter files:/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.oraUsed TNSNAMES adapter to resolve the aliasAttempting to c

For some reason Adobe is no longer supporting ColdFusion in the new Dreamweaver CC 2014. CF comments are no longer are highlighted in the code view. In fact CF is not listed among applications, although PHP is. Is Adobe planning on abandoning CF?

I am creating my first RESTful cfc which will allow a legacy system to interact with a more current system.  There are some "configuration" variables that need to be available to a couple of functions in the cfc.  These variables are mainly for disk paths and an API key.  What is the best practice for setting these variables in my RESTful cfc?  Should I just declare them at the beginning of the component outside the functions in the variables scope?  Do I need an init function?  If I use an init function how does it get called when the other functions are only called via REST?

I installed coldfusion 10 , at the end of insatallation process , it said coldfusion installed with errors and said to check coldfusion log file for error and didn't launch administrator.Here's the content of C:\ColdFusion10\cfusion\logs\coldfusion-error.log :3 Nov, 2014 5:15:46 PM org.apache.catalina.core.AprLifecycleListener initINFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\\ColdFusion10\\cfusion\lib;C:\\ColdFusion10\\cfusion\jintegra\bin;C:\\ColdFusion10\\cfusion\jintegra\bin\international;C:\\ColdFusion10\\cfusion\lib\oosdk\classes\win3 Nov, 2014 5:15:47 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["http-bio-8500"]3 Nov, 2014 5:15:47 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["ajp-bio-8012"]3 Nov, 2014 5:15:47 PM org.apache.catalina.core.StandardService startInternalINFO: Starting service Catalina3 Nov, 2014 5:

We installed a new CF11 server on a win2008 with iis7. the .Net ver is v2.0.50727We have this code :<cfobject  type="dotnet"  class="System.DirectoryServices.DirectoryEntry"  assembly="#dllPath#"  name="site">to allow us to contact to the IIS directory to later create a Virtual Directory on it.On the prev CF9/2008/iis7 /.net v2.0.50727 this worked great.ON the new server I get this error :Ensure that the DotNet agent is running and you have provided the correct host and port information-DotNet Side does not seem to be running.We made several checks to make sure that the .NET integration with CF works - and it seem to be installed and running ANY suggestions will be highly appreciated Thanks

I think the helpx.adobe.com tutorials can potentially be very helpful, but I can't find the accompanying files that the trainer keeps referring to. Where are they??

I have been reading about gateways and want to build a new CF11 application to use it. What I want is that my application can comunicate with operators in the field, two ways, realtime, so that every operator has his own personal postbox. Is this possible? 

Hi,I went through the install of ColdFusion 11 with no issues, but when I try to go to the admin nothing! The problem was there was no CFIDE folder in /Library/WebServer/Documents. I choose the developer version of the install. I tried to use the uninstaller application, but it does not launch and doesn't work. So now I am stuck with ColdFusion being half installed. Also nothing was written to the httpd.conf. I did make the change so index.cfm to work. I tried (even though I didn't think that it would work) copied the CFIDE folder from cfusion/webroot and put it in /Library/WebServer/Documents, but it just downloads the index.fm file.So another problem I have, what do I have to manually write to the httpd.conf file?Also, what I am trying to do is to make a host on my Mac, I have the license for ColdFusion 11. I went with the developer option as I am learning and want RDS. The only reason I am doing this is so my classmates can see my applications.Thanks so much for any help!Johnny

So our credit card processing started generating an error out of the blue on October 28th between 3pm and 10pm ET. Last successful transaction 3:14pm then failure from 10:50pm onward. We deal with Chase Paymentech and apparently 4 other merchants experienced the same problem, same error, same time frame. This is the error:An error occured while Parsing an XML document. Content is not allowed in prolog. The error occurred on line 66For us on line 66 is: <cfset myXMLDocument = XmlParse(#objGet.filecontent#)> We do some filtering beforehand:<cfscript>function stripHTML(str) {return REReplaceNoCase(str,"<[^>]*>","","ALL");}</cfscript>This has been working since 2009 no problem, and we haven't changed a thing. We host on Black Iron/Rogers in Canada. I'm not sure where the other merchants host.Paymentech is saying it's a Coldfusion problem, Rogers is saying it's an XML problem. We're caught in the middle. Reaching out here for some help.Has Coldfusion pushed an upd

Hi folks...I'm being driven crazy by this seemingly simple task.I have 4 selectboxes, each AJAX-driven, grabbing items from a database, and then populating the next box in turn.  Once a submit button is clicked next to the set of dropdowns, the information in the boxes are sent to a processing script where session variables are set and returned.They all preload by default. They all properly load the next dropdown as you'd expect.The problem is, I've found that if none of the boxes are touched and the default values are left, an error occurs when the submit button is clicked, and after dismissing the error popup, the 4th box becomes empty.  This only happens if the 4th (last) dropdown is left to its default value.  Once any other value other  than the default one is selected, everything works as expected.The error:Bind failed for select box Transact, value and/or display attributes must be specified on the cfselect tag when binding to a query.The form:<tr><t

Do you have experience changing your application from CF8 and Flash/Flex to only CF? If so, how do you replace the Flash/Flex part? Any experiences to share?

    So I've been fighting this for days.  I dont have the slightest idea where I can go from here.  I have your standard coldfusion insert queries set up to insert new data into the database.  Something along the lines of:Select * from table where tableuniqueID = Form.UniqueID   Cfif databasecheck.recordcount EQ 0, then insert new row with form.uniqueID as the uniqueID.  Well recently, its been throwing the generic Violation of PRIMARY KEY constraint 'PK__OLMS_Dat__9C04DA075F0A3F61'. Cannot insert duplicate key in object 'dbo.table'.I dont understand that in the slightest, the only way it inserts is if the query right above it is defined and equal to 0 recordcount.I did some tooling around, and found someone suggesting to insert into my SQL "IF NOT EXISTS" to have SQL do the actual check to see if data exists.  Well we put that in place, and just recently, ANOTHER duplicate happened, same error, cannot insert duplicate showing the new S

The local account used as the login account for CF application service doesn't allow access via UNC to other servers in in the same subnet  (behind a firewall with private ip addresses in use) for security reasons. It would be easier if we used a domain account -- but all the installation instructions and hardening pdf - recommend a local account which I am using.I can't seem to find details on how using a domain account is creating a security issue.  Is this a major or minor security issue is another question...TIAJay Bietz

I've been authenticating users of my web app against Active Directory using the cfntauthenticate tag which works pretty well and was simple to implement.  We have one or two European users who cannot log in because they are getting an invalid password error.  There username and password was checked as being valid by using other non-CFapplications that also authenticate against the domain .  The common thread seems to be that they use umlauted or other European accented characters.  These characters can be multi-byte in a unicode environment so I've tried a number of methods to altering the encoding of the page so that the password is recognized as valid but have had no luck so far.  Has anyone encountered this or have any information on the encoding of the form field when passing it through this tag?  Brian

The last 2 days - my [removed link] CF site has suffered from high CPU usage (on and off) that stops functionality.This will last several minutes then suddenly the high usage stops a few minute later the high cpu usage starts again.I don't have any scheduled processes allowed to run.Restarting the coldfusion service  during a high CPS incident - the cpu usage just picks up where it left off when restarted.I have assigned 4 CPUs (normal) or 8CPUs  (as a test) to the VM and I get the same high CPU then low usage. This is a fresh install several months ago on a new VM.I'd like some Adobe support on this issue but can't seem to find the contact phone number.This series of high and low cpu usage first started Monday AM about midnight until 7:00 AM  Tuesday was quiet and Wednesday this AM I'm having the same issues.Ideas?Update:  While waiting for this to post - the high CPU usage started again and this time I stopped and restarted the Jetty service ... and the CPU usage

I am running a JSP application on CF10 and trying to connect to an Oracle 11g data source. I cannot find any information or examples on how this might be done. Any info on how I can do this would be greatly appreciated. I have tried the the following but receive an error.Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","username","password");root causejavax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@localhost:1521:orclThanks

I have images pulling into site but it seems to be pulling them based on most recent added, is there any way to pull by file name alphabetically?I'm not too experienced with CF but I am good with HTML/CSS trying to fix some things on a friends site due to a runaway backend developer.sorry if this doesn't make too much sense.this is what it currently looks like<div><img width="920" height="300" src="data/images/<cfoutput>#ListGetAt(pic, 1)#</cfoutput>" /></div><div><img width="920" height="300" src="data/images/<cfoutput>#ListGetAt(pic, 2)#</cfoutput>" /></div>...

We have an internal page that we use to control things on our website.  It's sort of like a home-brewed CMS, but it doesn't hold actual content.  It just stores details about the pages (page title, contact person, date created, etc) and allows us to show newly added items on a "what's new" page.To get into the thing, I have a list of authorized users in a database.  I compare this list to a function that the server gives us called GetAuthUser()I basically do a query to find that username in the database and pull out the associated rights, then assign them to session variables.  This worked perfectly in CF8, but not in CF10.Here's the code that worked before: <cffunction name="onSessionStart">     <cfquery name="session.userdata" datasource="mydsn">     SELECT usernm, user_email, admin     FROM users     WHERE usernm = '#listlast(GetAuthUser(),"\")#'     </cfquery>  &nbs

I have made an encryption of "auth" using AES as follows:<cfset skey = generateSecretKey("AES")><cfset regkey = encrypt("auth", skey, "AES", "hex")>I attached the result for example to an URLhttp://www.mydomain.com/authorization.htm?auth=34D3795AA3696B7F81AEFE414DCA7392FDCC50AFE9D0312B2B2530A985386B83(auth is assign regkey   i.e. ,,,,,,htm?auth=#regkey#)This works perfectly under perfect condition.  However, if I go ahead and try to "hack" the code and make it shorter and change some characters like this:http://www.mydomain.com/authorization.htm?auth=453424AEFE414DCA7392FDCC50AFE9D0312B2B2530A985386B83The Decrypt function:<cfset theword=decrypt(url.auth, skey, "AES", "hex")>just crash! It throws an exception. Isn't it supposed to just return bad string rather than crashing?  This is pretty bad. Is there way to check for the URL.auth before passing to Decrypt?  Thanks in advance.

HII'm doing   returnAsBinary = "objectGUID"in a <cfldap> query.I was thinking of storing this value returned by objectGUID in a ms sql databse in a varchar(100) column as a primary key. Can you see any pitfalls with this method?

Hello, I am looking at having to work on a project that the customer is currently on CF 6 MX.  They obviously need to upgrade and so I am looking to experiences, thoughts, advice, anything at all about doing an upgrade over this many versions.  The major question I have is should we go major version to major version and not skip, like 6-7, etc. or is it do-able to go from 6 direct to 11?  Thanks in advance for any info.

CFB3 Question: How can I add an existing cfm page to a project? I created a project and copied a file into the project folder but I can't seem to find a way to add the cfm file into the project.

Hi Folks,I'm running ColdFusion 9 Trial Version (no hotfixes), SQL Express 2005, Windows XP SP3, IIS.Using ColdFusion Administrator, when I try to create a datasource to SQLExpress 2005 (SQL Server Express), using the SQL Server driver, I get the following error:Connection verification failed for data source: AMTjava.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.The "instance", which I take to mean the database instance, is "machinename\SQLExpress"  (This is a so-called "named instance".)  This is what I enter into the "Server" field of the form (Data & Services -> Datasources -> Microsoft SQL Server).On the other hand, I am able to create an ODBC datasource name in Windows using the Microsoft SQL Server Native Client Version 09.00.3042 driver and using the same insta

Hello,We have just installed the APSB14-23 hotfix for ColdFusion 10. After the installation, we get the following error when we try to reach ColdFusion administrator. Has anybody experienced this error before? How did you resolve it? Thanks.Best regards,Chung Leetype Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Runtime service is not available. coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:

I have a simple table with an NVARCHAR column and some random Korean and Chinese characters.  I can successfully query the database and output this column to the my browser in addition to passing an UTF-8 NVARCHAR variable out from the Stored Procedure regardless of whether the option that is suppose to enable it is checked.-- Enable High ASCII characters and Unicode for data sources configured for non-Latin charactersI verified multiple times that it's unchecked yet the output is as expected in UTF-8 characters (not gibberish or question marks).