ColdFusion

I have a flex application that is calling multiple ColdFusion services, this has been working for a long time but now all of a sudden it stopped working and I have no idea what is causing it. Basically, I am sending 15 function calls to different services through the flex gateway. The first one executes and all the other ones send this error message "java.sql.SQLException: This connection either has timed out or has been closed and has returned to its pool. You must re-acquire the connection. "  See attached Charles screenshotThe coldfusion application is a very simple ORM application running some simple single parameter hibernate queries like belowremote Wayeo_Service.cfc.city_clerks[] function searchByID39(string q ) {  var hqlString = "";  var whereClause = "";  var params = {};  hqlString = hqlString & "FROM city_clerks";  if (len(arguments.q) gt 0){  whereClause  = ListAppend(whereClause, " ID39_City LIKE '%#arguments.q#%'");  }&nbs

Hello, when I try using this code<cfpresentation title="MyPreso" autoPlay="true">  <cfpresentationslide src="c:\preso.ppt" /></cfpresentation>I'm getting this:Could not initialize class com.sun.star.lib.loader.WinRegKey... What's going on?

Hi, I've been trying to use powerpoint as a source for the cfpresentationslide tag, but it would always give me this error: Could not initialize class com.sun.star.lib.loader.WinRegKey. How do I fix this? I am using CF 9 and I'm pretty sure that it supports powerpoint.  Thanks!

People who installed coldFusion 11 on our server didn't select the option "ODBC Service".Is there a way to install the ODBC service without re-installing coldFusion ?

Hi have a pdf with some formfields:http://www.direct-jobs.ch/abm.pdf(official form from swiss authorities)and i want to automatically fill it out with cfpdfform.However when I try to read it using <cfpdfform source="/tmp/abm.pdf" result="resultStruct" action="read"/><cfdump var="#resultStruct#">I get an CF-Error message Either datafile XML or data XML contained in the PDF document is invalid. however reading the form with acrobat reader works perfectly fine.Any ideas how I can get this to works?I suppose it has something to do with the version of acrobat the form was generated with, but thats just a guess.

Please download the attached file to view this post

Anyone created a function to get the current year? Here's what I've got so far and it appears to work: function getCurrentYear() { var datetime = now(); var month = year(datetime); return Year(datetime); } Is there a better way to code such a function in cfml?

Hi ,From Solr, we are getting default Json formatted output on http query request.is there any way to get customized Json output from Solr? Like some indexed parameters in one object or some parameters in another object or array object of some parameters or nested objects.Any pointers on this would be helpful. Thanks!

(CF8.01 server with Windows 2008 Server R2 - Java installed in C:\Program Files\Java\jre6)I have no problems connecting with CFHTTP from a local dev box to one of our domains on a server with SSL. I also have a domain that uses a PayPal API over SSL which appears to be working still. However I've recently tried to integrate with another 3rd party and I can't get it to connectI receive a peer not authenticating error, as detailed in the link belowDiagnosing a CFHTTP issue - peer not authenticated · Raymond Camden I tried the fix at the top of Raymonds page but it would not work, it just throw errors. I've been through the thread which at one point led me to an instructional page here Naveen Chhabra's Blog | Just another WordPress.com site  which suggested that you take the certificate from the third party server and install it on the CF server. However I struggled with that because it was asking for a keystore password, which I don't know and can't seem to figure out how to set.The

HelloWhat is the easiest way to transform a cfhttp get result to xml?I refer to a string like this:{"ticker":{"base":"BTC","target":"NEO","price":"233.95972149","volume":"","change":"-0.55305476"},"timestamp":1514451062,"success":true,"error":""}Would be happy to solve this issue Thanks a lotThomas

I'm using <cfpdfform> command to simply read fields from my Livecycle 9 pdf.  The problem is that not all of the fields appear in the CFDUMP.  I'm simply using:<cfpdfform source="test.pdf" action="read" result="fields"/><cfdump var="#fields#">I have one subform where I have 15 text fields in the PDF. When I do the CFDUMP, it only shows 2 of the 15 fields.  Has anyone else encountered this?

Hi there,I try to create a DSN using ODBC Socket on Coldfusion Standard 2016 (OS Windows Server 2016) and i receive this error :java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][SequeLink Server]The specified data source is not defined.When i try the same on Coldfusion Standard 2016 (OS Windows Server 2012) everything works fine.It seems that Windows 2016 no longer support SequelLink Connectors.Any idea to bypass This or do i need to downgrade to Windows 2012 ?Thanks and sorry for my English.

Running ColdFusion 9,0,1,274733 on JRun (J2EE install), Windows Server 2008 R2, Java 1.6.0_22Has anyone else had a problem getting the default document, index.cfm, to work with ColdFusion? I'm assuming that this is only an issue because of our setup; different web server (IIS) and application server (ColdFusion). I can't imagine we are the only ones running this configuration. Are we?So here is the issue.If we request http://mysite.com/test/index.cfm it works.If we request http://mysite.com/test/ it does not work and we get a 404.I checked the web connector's log file on our IIS server and can see that it is sending the request to our ColdFusion server. The ColdFusion server is sending back the 404 error code but I can't figure out why. We have the default document set on our IIS server for index.cfm. We also have the <welcome-file-list> set to include index.cfm on our application server (web.xml).From our web connector's log when we do NOT include index.cfm:2012-11-01 13:37:22 j

Getting this error, not sure where to begin troubleshooting. I'm trying to fix a website for a friend but I am a bit lost on where to start. Hoping one of you could shed some light on what exactly this error means.

Is there a way to make writeDump() easily output to a new line when using this within a <cfscript> block?

Hello everyone,We have upgraded our development server from CF10 to ColdFusion 2016 today. While I was testing our system I notice that every report couldn't be accessed. I have checked the folder on the server and files are in there. I tried to use this code to test and access the files:<cffile action="read" file="\\testsite\testsite_d\test.xlsx" variable = "fileContent">After I run code above error message showed on the screen:Message\\testsite\testsite_d\test.xlsx (Access is denied)      DetailThe cause of this exception was: java.io.FileNotFoundException: \\testsite\testsite_d\test.xlsx (Access is denied).      I'm not sure why files can't be accessed. Everything worked fine before we did the upgrade. If anyone knows how to fix this problem please let me know.Thank you.

Hello, all,I understand that ColdFusion spreadsheet functions are based upon Ben Nadel's POIutility.cfc.  I was just asked a question that I don't know how to answer and thought I'd bring it here for scrutiny."Do CF spreadsheet functions rely, at all, on .Net?"I know that CF is a wrapper for Java (Tomcat).  But that's the deepest my knowledge goes.  Does .Net come into play for spreadsheet functions in CF?V/r,^ _ ^

I have a cfsearch working very good but when my user click on a result and hit the browser back button the search result is empty and my user have to do another search.I would like the user who go back to see the result they had.<cfif isdefined("form.recherche")>                  <cfsearch name="searchResultsproduit" collection=" sextantProduitFR" criteria="#form.recherche#">                  <cfsearch name="searchResults" collection=" sextantFR" criteria="#form.recherche#">                  <!---<cfdump var="#searchResults#">--->                  <cfoutput query="searchResultsproduit">     &

My current attempt at extending m application.cfc results in this message:The folderA.subfolderB.///Application component or interface cannot extend itself.  I have a folder named "folderA" and within this folder is an application.cfc and a subfolder named "subfolderB'  Within subfolderB I also have an application.cfcThe code within folderA/application.cfc is as follows:<cfcomponent>    <cfset this.name               = "test1">    <cfset this.sessionManagement  = "true">    <cfset this.clientManagement   = "false">    <cfset this.setClientCookies   = "true">    <cfset this.applicationTimeout = CreateTimeSpan(2,0,0,0)>    <cfset this.sessionTimeout     = CreateTimeSpan(0,0,20,0)></cfcomponent>The code within folderA/subfold

HiI am building a website and the client would like a form on the site were people can send him a CV / resume.I have built a basic form in Coldfusion, but this asks for name, email message etc. and sends this information as an email.How do I create a extra bit that adds a pdf file to the email? How does this work?Any simple/clear answers would be greatMany thanksMark

I am working on bringing an organization up-to-date on their Coldfusion deployment.  They are currently running Coldfusion 9 on a VM with lots of troubles with the underlying OS or VM.  The first step is to migrate to a new machine, then we'll focus on updating ColdFusion.  We'll need a few days of running the old and new VMs side-by-side to be sure everything is stable while we move customer sites over.  So I'm licensed for one server, but will need to use two servers for a few days.  Can I do this without purchasing additional licensing?

Hi all,We're developing a webapp where managers are able to assign learning to their team members - ideally, this learning needs to be completed within a set timeframe and so we've been playing with assigning a task in outlook 365 with the required date/time etc.  Whilst we can do this for the actual user, there doesn't seem to be an option to assign the task to someone else using cfexchangetask.Has anyone been able to achieve this and if so how?  Thanks

Hi I have found a form online which work great! Now I want to add a new box to the form which allows for a message, so i want the box to be bigger, multiple lines rather than the 1 line I have at the moment.Currently I have the followingat the top of the page:    <cfparam        name="FORM.email"        type="string"        default=""        />In the form:<div class="control-group form-group">     <div class="field-text">       <label for="email">       Email:<br><br>       <input            type="text"            name="email"         

I've built a functional REST service that is successfully returning a query result:<cffunction name="getAllOrders" access="remote" returntype="any" httpmethod="GET" returnFormat="json">   <cfquery name="getAllOrders" datasource="test">      select * from concreteOrder   </cfquery>   <cfset results = #serializeJSON(getAllOrders)#>   <cfreturn results></cffunction>I've been trying different formats but I'm not understanding the docs (my apologies, the holidays has made my brain fuzzy). Does anyone know the correct format I should use in the serializeJSON() method to successfully bring back name:value pairs from the query results in my JSON object? All I've been able to do is bring back each row as a blob and then my Angular app can't do anything with that.... Ideally I'd like to bring back each row with something like "id": "1", "col2":"value", "col3":"value".... and so on

Hello, we have a large repository of PDF technical documents (mostly papers presented at meetings) that we've been trying to get indexed on Google Scholar, with no luck. The PDFs are stored outside the webroot, behind a sign-in wall, and served up to visitors via cfpdf, cfcontent and more.We've gone over the Google Scholar guidelines for inclusion as carefully as we can. Our content is being indexed by Microsoft Academic, which appears to follow the same guidelines, but no luck with Google. Google themselves do not provide a way to talk to them directly about it. We've tried submitting requests to have our content manually indexed, to no avail.Does anybody have experience with getting content indexed by Google Scholar? I am happy to share my ColdFusion code, although it's pretty simple. It may have something to do with the PDFs being outside the webroot and thus unable to be indexed by Google bots, but I can't think of any way to test this or verify it. We are definitely not blocking G