ColdFusion

Been a few years since I worked with tag based cf.Was trying to create a search form to search db records that matched the user inputs. I basically copied old tutorials code from cfwack 9 and the OWS examples files. These files use a derby database and of course work fine.I copied the search,cfm and results.cfm templates and just replaced all the values with my database vals. Im using an access database and i get an error when I run the query.As you can see, it says Im missing an operator in the WHERE clause. Again, this same code seemed to work fine in the ows tutorial db. Im wondering if its because its an access db and the operators may be different?Here is my query: <cfquery name="plm" datasource="dawnFoods"> SELECT ProductDataSpec.ID, ProductDataSpec.projectName. ProductDataSpec.desc, ProductDataSpec.skuDetails FROM ProductDataSpec WHERE 0=0 <cfif FORM.projectName IS NOT ""> AND projectName = #FORM.projectName# </cfif> ORDER BY ID </cfquery> Not sure why t

My error template is throwing an error itself and its coming from the Java object. See below error message, can some one please tell me what is going on here. Does the application have to have permission to access? Here is the error messageValue must be initialized before useIts possible that a method called on a Java object created by CreateObject returned null.The error occurred in errorHandler.cfm:                line 1513 :                }14 :                //produce the event list15 :                events = factory.DebuggingService.getDebugger().getData();16 :                //restore debugging status17 :&nbsp

CF10 reverted to the Developer Edition seemingly overnight.  I checked other posts about the license.properties file and making sure the serial number is in there.  We have uninstalled / reinstalled as well as restarted the service and server.  Need some help on new next steps.

Could someone read this and maybe suggest some different approaches to resolving this??ERROR MSG:•Connection verification failed for data source: mysqldbv2com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.The root cause was that: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. I've entered the following lines in CF11 administrator: CF Datasource name: mysqldbv2JDBC url: jdbc:mysql://localhost:3306/mysqldbv2Driver class: com.mysql.jdbc.DriverDriver Name: mysql 5.0User name: rootPassword: 123 (this is development computer offline)I'm using MySQL Workbench 6.1Windows 7 machine. Using CF11.I've tried everything I can think of.  Firewall is off. Log files in CF admin offer no help.  Same with MySQL.  

Hello,Can anyone give tips re the following: I need to create a load balanced ColdFusion environment consisting of 2 servers each with a webserver that is connected to it's own CF10 server.The traffic to the ip adress is encrypted via https.The load balancer should be able to assign a client session to a specific server and keep it there during the duration of the session - so effectively making it sticky.What would be the best setup here?Do I need to create a cluster of 2 CF10 instances and assign the cluster to webserver 1 and webserver 2 so it is stcky? Or else, if I use 2 standalone ColdFusion instances, how can I make sure the sessions are replicated or sticky?Thanks,Marc

I have two related questions:1.  CF10 and integration with Java Web applicationsWe have a couple of Java applications running on JRun and interfacing with CF9 applications.  The JRun clusters were created through the JRun Admin and, apart from lack of Axis 2.0 support, have served us well for years now.  And, as would be the case, the ColdFusion9/Java/Flash application is a critical public-facing application that the business uses for bidding on projects.It appears that with ColdFusion 10 on Tomcat, we will not be able to run those Java applications on a Tomcat-CF10 JVM cluster.  Is this correct?  IF so, what are our options?  2.  J2EE Application Servers supported by Adobe for CF10Which of these is correct?A.  This URL (http://www.adobe.com/products/coldfusion-enterprise/faq.html) states "ColdFusion 10 supports IBM® WebSphere, Oracle® WebLogic, Adobe JRun, Apache Tomcat, and JBoss."B.  This URL (http://wwwimages.adobe.com/www.adobe.com/cont

I am trying to consume webservices on my CF 10 environment.  I keep getting a CompilationFailedException error looking for java/utils.  I have uninstalled CF, uninstalled the jdk, used the bundled jdk, reinstalled jdk 17.0_25 but to no avail.  I tried replacing C:\coldfusion10\cfusion\lib\tools.jar with the same file in the latest JDK as recommended on this forum on earlier releases encountering this error.I have pasted the text from coldfusion-out.log but changed the name of the server with the wsdl.Any direction is very appreciated.ThanksJun 21, 2013 11:29:09 AM Information [ajp-bio-8012-exec-1] - Starting Web service request.Jun 21, 2013 11:29:09 AM Information [ajp-bio-8012-exec-1] - Creating Web service proxy {url='https://serverdomain/rpc/soap-axis/confluenceservice-v2?wsdl'}Jun 21, 2013 11:29:15 AM Information [ajp-bio-8012-exec-1] - Using Axis 1 for consuming the service https://serverdomain/rpc/soap-axis/confluenceservice-v2?wsdl.Jun 21, 2013 11:29:16 AM Informa

Am making progress with:Windows 2012Apache Tomcat 7.0.42ColdFusion10 EnterpriseSince we need /CF to be our Context for ColdFusion web applications, I deployed ColdFusion as CF.war; everything has functioned nominally... until now:  Session-replication is not functioning correctly.  Question:  are the errors below a consequence of deploying ColdFusion as cf.war (and a Context of /CF) instead of cfusion.war (and a Context of /Cfusion)?INFO: Starting clustering manager at /cfOct 30, 2013 2:31:44 PM org.apache.catalina.ha.session.DeltaManager getAllClusterSessionsINFO: Manager [/cf], requesting session state from org.apache.catalina.tribes.membership.MemberImpl[tcp://{167, 131, 75, 31}:4000,{167, 131, 75, 31},4000, alive=844838, securePort=-1, UDP Port=-1, id={-45 53 -56 -7 80 21 76 28 -110 113 71 -46 -62 -41 -88 52 }, payload={}, command={}, domain={}, ]. This operation will timeout if no session state has been received within 60 seconds.Oct 30, 2013 2:31:49 PM org.apache.c

GreetingsI have 3 distinct user types for my app- admins, appraisers and clients.All have their own directories and each directory has it's own Application.cfm:1) <cfapplication name="appraiseri" applicationtimeout="#CreateTimeSpan(0,2,0,0)#"clientmanagement="Yes" sessionmanagement="Yes" sessiontimeout="#CreateTimeSpan(0,2,0,0)#"SetClientCookies="Yes">2) <cfapplication name="appraiserview" ......3) <cfapplication name="clientview" .......Each have their own login which simply uses their ID in the DB as the session variable.login_do.cfm:1) Appraisers: <CFIF auth_direct_appraiser.RecordCount NEQ 0 ><cfset Session.appraiser_user_id =auth_direct_appraiser.appraiser_ID><cfset Session.appraiser_fname =auth_direct_appraiser.appraiser_fname><cfset Session.appraiser_lname =auth_direct_appraiser.appraiser_lname>2) Admins: <cfset Session.user_id =auth_direct.staff_ID> ......3) Clients: <cfset Session.processor_user_id =auth_direct_processor.processor_I

HiI recently upgraded from CF8 to CF11 and now CF11 does not seem to be able to send emails.In CFAdmin, I entered the mail server and settings to the point where, when I Verify Mail Server Connection I get a success message, "Connection Verification Successful", but no email gets sent.When i view the Log files for Mail in CF I see this error repeatedly:avax.mail.MessagingException: Could not convert socket to TLS; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetHas anyone else encountered this error? I can post plenty of additional detail if needed, both from the CF server and the Exchange server, if needed.Thanks in advance,Rich

I don't have the exact text of the error message right now, but for the last couple of weeks, on a nearly daily basis, when I launch CF Builder (v2) I get an error that says I don't have the adobe application manager installed, and my builder has been crippled to a 'lite' version or something.  I then re-re-re-re-re-install the application manager, re-launch builder, re-input my serial number, and things are fine, just as they previously were for several years.  The next day, however, I am likely to be told once again that I don't have the application manager installed, and have to repeat this process.Obviously, this is extremely frustrating.  Any suggestions?  Anyone?  Please?Thanks,Dave

I have a database full of options for additions to houses. Porches, driveways, carports etc. Each of these options has a possibility of having different sizes depending on the house size. What I have right now is an admin page with a checkbox that is next to each option. If checked that option gets listed on the web page. My issue is that I need to include random sizes for each option if needed. For example, the web page would look something like this:Porch: 10' x 10'Now the checkbox would be for including the word porch, but how do I include the dimensions? I never know the exact size, and there is no set sizes. My thought was to put a form field next to each option that inputs the size manually. But how would that get transferred to the web page?\\This is what I am thinking of howNow the checkbox will add the words but the dimension form field is where I'm confused. How do I get the dimension field into the web page? Any help would be appreciated.

By dynamic, I mean the ability to change markers once the map has been drawn. As examples, Find Us | Tesla MotorsWhere you have, at screen bottom toggles to change what so show and render them without having to redraw CFMAP. Thanks.

Hi all,This is on Windows server 2008 R2, IIS 7.5 and Coldfusion 10 or 11.  I have Coldfusion running under a local user on the machine and that works fine.  I am trying to encrypt some folders using Microsoft EFS.  I create the certificate for the user that runs Coldfusion and encrypt a folder.  When I upload a file through Coldfusion to that folder, the file is not encrypted.  If I login as the Coldfusion user on that machine and copy a file to the encrypted folder it does encrypt.  For some reason when the file is placed there by Coldfusion, Windows is not recognizing that the file should be encrypted.First, has anyone else encountered this kind of behavior?  Second, if not, could someone please try to confirm this behavior.  If someone else encounters it I will log it as a bug.Thanks!Jim

OK,So apparently ColdFusion 11 has some new cluster functionality that uses a database. The supported databases include Oracle. However, as we have Oracle ExaData which uses service_name in connect strings rather than a SID we can't use the "normal" Oracle driver but rather have to use "other" and define the connection using the standard Oracle jdbc driver and connection string. This then means we can't use the Oracle database for the cluster schedule stuff. This is presumably wrong, as any SQL used to create tables or "use" them must be Oracle compatible.So, does anyone know either:How to connect to ExaData (or RAC using service_name as apparently that's basically the same) with the "standard" Adobe Oracle driverHow to persuade / tell ColdFusion that the "other" driver is in fact an oracle back end so I can use itI'd obviously rather not install a single point of failure in the form of either a simple MySQL database or a basic Oracle database just to make scheduling's cluster function

No matter what I try, I can't get this to work:<cfexchangeconnection action="OPEN" connection="conn1" server="[server]" username="[domain]\[username]" mailboxname="[mailbox]" password="[password]" protocol="https" formbasedauthentication="True" formBasedAuthenticationURL="https://[server]/owa/auth/owaauth.dll" serverVersion="2010">I've followed the instructions to the letter.  The Exchange server has HTTPS enabled.  It is running Exchange 2010.  I've installed the HTTPS certificate on my server.  Still, I get this:Could not login to the Exchange server.Verify the server name, username, and password. Ensure that proper client certificates are installed.What the heck am I doing wrong?

Just installed CF11 but I cannot open up any cfm pages

I have CF Builder 3 Trial installed as standalone application. Every time I restart CF Builder, the RDS mapping settings for the remote server I have are gone and also the remote ColdFusion server I set up is gone and I need to recreate it. Is there anything I can do to prevent that from happening? Thank you for any help on this issue, so far I spent few hours searching for a fix but can't find anything.

I've downloaded the ColdFusion Builder 3 trial and am experiencing some odd and very annoying behavior.I've customized some code editor text font and color settings. I've added an entry to the CF Servers panel for an instance of ColdFusion 10 running inside a VMWare virtual server on my laptop.When I restart Eclipse, all the code customizations I've made are reverted back to the default install settings and the entry in my CF Servers panel is gone.I've been an IntelliJ user for well over a year, but in doing much more cfscript-based development the CF Plugin for IntelliJ is proving to be a hindrance so I thought I'd give CFB 3 a try and see if there were any improvements over CFB 2. However, I can't take this kind of behavior. Hopefully someone can give me a setting or someone else has seen this before and can give me an idea of where to start looking.I have CF Builder installed as a plugin into Eclipse Kepler 64-bit for Mac. I added the CF Builder update site and have updated to CF Bu

I am running CF10 on IIS 7.5 with URL Rewrite module installed.All the rewrite rules work perfectly and ColdFusion is returning the correct pages. In order to get the page displayed in the browser I have to manually set the 'content-length' value in Application.cfc like this:<cfcomponent><cffunction name="onRequestEnd"><cfheader name="Content-Length" value="#getPageContext().getCFOutput().getBuffer().size()#" /></cffunction></cfcomponent>Without this code the browser does not display the page. However, even though it is now displaying the page, it is not doing it correctly. The page never finishes loading fully and not all of the HTML content seems to be on the page.I have tried to add a <cfflush> tag after setting the 'content-length' but it makes no difference. I don't understand why this is happening but I know that it has happened to someone else who was using htaccess: http://forums.devshed.com/coldfusion-development-84/page-not-finishing-loadin

Hello.I am trying to apply for a 30 days free trial on adobe connect, however when I submit my application this error occurs. What should I do? I have Windows 8/ google chrome.Please keep the answers short since I have a bit hard to to understnd difficult meanings.

It there a maximum amount of Ram that can be allocated the the virtual file system?  When I specify more than 1 GB size, the system returns a negative number for the remaining free space, and any attempt to store a file resuts in storage limit exceeded errors.I've been unable to locate much detail about the VFS configuration via web searches.  Any details are appreciated.Ronnie

Addition information.   ColdFusion Application Server is not running and will not start error logAug 13, 2014 2:58:49 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:\ColdFusion11\cfusion\lib;C:\ColdFusion11\cfusion\jintegra\bin;C:\ColdFusion11\cfusion\jintegra\bin\international;C:\ColdFusion11\cfusion\lib\oosdk\classes\winAug 13, 2014 2:58:50 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["http-bio-8500"]Aug 13, 2014 2:58:50 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["ajp-bio-8014"]Aug 13, 2014 2:58:50 PM org.apache.catalina.core.StandardService startInternalINFO: Starting service CatalinaAug 13, 2014 2:58:50 PM org.apache.catalina.core.StandardEngine startInternalINFO: Starting Servlet Engine: Apache Tomcat/7.0.52Aug 13, 2014 2:58:57 PM org.apache.catalina

We installed CF 11 Standard 32 bit on a Win 2012 R2 server with IIS 8.5.   We tried installing both with 32 bit "Enabled = False" and "Enabled = True".  Both resulted in Error 500 or 500.19.Below are more details, with images following for the errors and the Handler Mappings.The CF11 HKLM software key is under the WOW6432Node key.  We get the 500.0 error when the DefaultAppPool 32.bit setting is "false" and a Test.htm program works just fine. If we enable 32-bit, the result is a 500.19 error for both the CF admin and the Test.htm.

We have custom JAVA code that we are trying to interface with. The JAVA code works as expected within Eclipse JUnit. But when we try to reference the code in ColdFusion we get a "Cannot instantiate class: com.sun.jndi.fscontext.RefFSContextFactory" error. We have tried to put the fscontent and providerutil jars everywhere we could think of to get this resolved. We even tried to run JHades as a servlet listener to see what was happening with the class loading (the server would not even start with the listener in place.)We are using the context factory to access a .binding file that access IBM MQ message queues.We have tried to get this to work with CF9, 10, and 11. We have run 10 and 11 as standalone servers, then we even tried running 11 as a JEE application in JBOSS. Same error.