ColdFusion

We recently migrated to a new server and installed ColdFusion 11 Standard upon it.  We went with CF11 so that a higher number of concurrent requests could be made upon our database.  To our dismay we are seeing no improvement migrating from CF 10 (on the old server) to the newer CF11 on the newly created server.  In fact the latency and web site hangs seem to be even more prevalent despite the fact that only 4 users are typically accessing the site at any one time.  Adobe tech support is researching possible solutions at this time.  In the meantime, we would appreciate any tips that this forum users might lend to shed some light on what the underlying issue might be.  Interestingly, when 3 requests or less are made (we have been monitoring this with FusionReactor) the pages work efficiently.

Wondering how to return a PDF file from the server using the restful api.A document id is provided, which retrieves a record that has the file path and file name information.From there the file is retrieved into a variable.I have tried returning as Binary Base64 with a returntype = binary in the api<cfcomponent restpath="document" rest="true" output="false" extends="cfc.document">     <cffunction name="getDocument" access="remote" output="false" httpmethod="get" returntype="binary" restpath="view/{documentId: \d+}" >          <cfargument name="documentId" required="true" type="numeric" restargsource="path">          <cfset REQUEST.sessionObj = REQUEST.securityObj.checkSession(REQUEST.sessionKey)>          <cfset LOCAL.documentData = getDocumentData(REQUEST.sessionObj.userId, arguments.documentId, REQUEST.se

Is it possible to have the table of an ORM entity to be linked to a table on another database, like this:component persistent="true" table="anotherdb..tableonanotherdb" output="false" {}If not, what are my options if the app needs to be able to update the anotherdb..tableonanotherdb, instead of just viewing it (which I can simply set up a view for)?

I am using The Report Builder in CF10.I need to select data from multiple tables. One of the conditions is that the term_int (value of 201508  is converted to school year) = to sch_years (201516) in another table.Here is my query:/* Get new student loan information */SELECT name.first_name, name.last_name, name.mi, name.soc_sec, name.name_le1, finaideurekaawddesc.finaideurekaawddesc AS AwardDesc, MMTemp.st_addr, MMTemp.add_addr, MMTemp.city, MMTemp.state, MMTemp.zip, MMTemp.Operator, finaideurekaawd.finaideurekaawdtot AS AwdAmt, nmact.act_memo, /* nmbudget.nmbudget_tuition AS Tuition, nmbudget_RM_BRD AS RoomBoard,*/ position.val AS PositionCASE    WHEN SUBSTRING(MMTemp.term_int, 5,2) = '08' then 'Fall of '    ELSE 'Spring of ' END AS EntryPeriod,CASE    WHEN SUBSTRING(MMTemp.term_int, 5,2) = '08' then LEFT(finaideurekaawd.sch_years,4)    ELSE (LEFT(finaideurekaawd.sch_years,2) + RIGHT(finaideurekaawd.sch_years,2)) END AS

I am using The Report Builder in CF10.I need to select data from multiple tables. One of the conditions is that the term_int (value of 201508  is converted to school year) = to sch_years (201516) in another table.Here is my query:/* Get new student loan information */SELECT name.first_name, name.last_name, name.mi, name.soc_sec, name.name_le1, finaideurekaawddesc.finaideurekaawddesc AS AwardDesc, MMTemp.st_addr, MMTemp.add_addr, MMTemp.city, MMTemp.state, MMTemp.zip, MMTemp.Operator, finaideurekaawd.finaideurekaawdtot AS AwdAmt, nmact.act_memo, /* nmbudget.nmbudget_tuition AS Tuition, nmbudget_RM_BRD AS RoomBoard,*/ position.val AS PositionCASE     WHEN SUBSTRING(MMTemp.term_int, 5,2) = '08' then 'Fall of '    ELSE 'Spring of ' END AS EntryPeriod,CASE     WHEN SUBSTRING(MMTemp.term_int, 5,2) = '08' then LEFT(finaideurekaawd.sch_years,4)    ELSE (LEFT(finaideurekaawd.sch_years,2) + RIGHT(finaideurekaawd.sch_years,2)) END A

We get these slowdowns just about evert hour:Jun 14, 2015 11:51:43 AM Warning [ajp-bio-8014-exec-1140] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015 13:12:04 PM Warning [ajp-bio-8014-exec-1410] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015 14:50:49 PM Warning [ajp-bio-8014-exec-1872] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015 15:44:03 PM Warning [ajp-bio-8014-exec-1921] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015 15:44:04 PM Warning [ajp-bio-8014-exec-1948] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015 16:41:11 PM Warning [ajp-bio-8014-exec-2320] - Could not obtain the lock for client scope. The lock obtained on it might not have been released.Jun 14, 2015

Does anyone know of a way to convert a datetime (like 2015-06-10 07:30:00) to a decimal, similar to:42165.450 where 42165 is days and 450 is minutes?  If I try the following:------------------------------------------------------------------<cfset dtNow = "2015-06-10" /><cfset dtOne = CreateDateTime(     Year( dtNow ),     Month( dtNow ),     Day( dtNow ),    07, <!--- 6 PM. --->    30, <!--- 30 Minutes. --->    00 <!--- 0 Seconds. --->    ) /><!--- Dump out result. ---><cfdump var="#NumberFormat(dtone,'99999.99999')#" /><br>------------------------------------------------------------------I end up with 42165.31250Thanks

There's a directory in the CF 10 Windows installation -- ColdFusion10\cfusion\runtime\work\Catalina\localhost\tmp -- that looks like it is used as a temporary storage for files being uploaded using cffile. Usually the file gets created there and then deleted once the processing is complete. But I have an issue where sometimes the files don't get deleted. This is an issue for me because CF is installed on the C drive which has somewhat limited free space. Does anyone know what causes the files to not get deleted and what can be done about it?Thanks.

The database queries I had at the top of the page were moved into a CFC and now it is taking noticeable amount of time in displaying the data. how to make data entry validation that does not happen inconsistency.Ex :1. AddItem.cfm<cfinvoke component="#Application.ComponentPath#.inventory.Stock"             method="qtymin"             datasource ="#iif(isDefined('DSN'),'DSN','Attributes.DSN')#"             itemcode="#varItemCode#"             trans_date="#createodbcdate(qhead.whtreqdate)#"            trans_type="STF"             qty="#QTY#"            qtyrr="#QTY#"       &nbsp

I have a clean installation of ColdFusion 11 on a Windows 2012 R2 VM. CF has been up and running w/o issue for about 2 weeks. Used basic default directories.Today I d/l'ed and installed the add-on services, using default directories again.When I try starting the add on services in the Windows service applet, however, they start up...but immediately stop. I.e., the service supposedly starts up--quite quickly...suspiciously quickly, actually--but as soon as I refresh the display of service, I can see they're not running again.I've looked through the install log for the add-on services and all looks good, i.e., "successful."Any suggestions on where to look next for this problem? Some particular log files or something like that?

I have a new, functional install of ColdFusion 11 (11,0,04,293328) installed on a Windows 2012 R2 VM. The CF server is up and running w/o issue. It was installed using default directories.I just d/l'ed and installed the add-on services using defaults as well.I cannot get the add on services to run. Using the Windows Services applet, When I start the add-on services, that start right up in just a second or two and then if I hit F5 to refresh, I can see that they're actually not running,I looked through the add-on services installation log and everything indicates "successful". There appear to be no issues.Any suggestions on what to look at next? Something particular to look for in some log file perhaps?

I am trying to execute a stored procedure through ColdFusion.  The stored procedure being executed attempts to insert local data into a remote server table through a linked server.Attempting the stored procedure call from ColdFusion results in an error:[Macromedia][SQLServer JDBC Driver]The DBMS returned an unspecified error.  The command code was 253.However, if the stored procedure is exected within SQL Server Management Studio, the call works correctly, no error.I am using the same credentials within Management Studio as within ColdFusion (via Datasources).

How do I prevent my loop from trying to insert an empty value into mySQL database? The form I am using has four rows automatically created. If they only fill in three rows than I get problems with the fourth row being empty.  Below is my code that works fine as long as they don't leave a field empty.<cfloop from="1" to="#form.numba#" index="idx">    <cfset getqty = form["qty" & idx]>    <cfset getitem = form["item" & idx]>    <cfset getunit = form["unit" & idx]>    <cfset gettotal = form["total" & idx]><cfquery name="insertItems" datasource="#application.dsn#">INSERT into items                (orderID,                qty,                item, &n

We are using Cold Fusion 8.  I created a text box on a form using cftextarea, which uses FCKeditor that came with CF8.  When I try to populate a PDF form using cfpdfform/cfpdfformparam the embedded HTML shows as plain text.For example:  If I input "This is bold", the pdf form output shows "<b>This is bold</b>".  How do I massage the input to display properly in the PDF form?

My hosting server is CF9. Want to upgrade to Builder 3, but it defaults to CF11. Can I change to CF 9? How?

I'm moving an old app from CF8 to CF10 (Standard, 10,0,16,293499).  Pretty smooth transition except for one specific page that calls a webservice on our .NET webserver.  The CF8 app runs fine, here is the code snippet:<cfscript>WSoptions = {};WSoptions["username"] = "xxx";WSoptions["password"] = "xxx";ws = CreateObject("webservice", "http://hqimpetl01/searchAPI/toExcel.asmx?WSDL", WSoptions);blah blah blah blah</cfscript>The reason for setting the timeout is that some calls to the webservice can result in manipulating a lot of data.When I run it on CF10, I get this error:Web service operation _setProperty with parameters {axis.connection.timeout,30000} cannot be found. If I comment out that line, things work for the small files I test with, but sooner or later a user is going to give it something that needs time to run.I did some Googling, but ended up over my head in Java solutions.  Has anyone encountered this, and come up with a solution that can be implem

How do you indent multiple lines of code in CFBuilder 3?  In CFB 2 I used Ctrl + Alt + Arrow Key.  That does not seem to be working in CFB 3.TIA

Hi all,i have a problem if i want to connect with cfhttp and https to a payment provider it says:connection failed.i think it happens, because sindce 6 month the provider shut down the sslv3 protocoll.how can i change in cf9 to use this protocol..i think i have to use tls 1thanks all for helpkindly regards thorsten

I kept getting this the following error. I installed ColdFusion 11 and repoint everything to the new ColdFusion 11 and for some reason, I kept getting this error. Any suggestion is much appreciated.Config Source:  474: <staticContent>   475: <mimeMap fileExtension=".air" mimeType="application/vnd.adobe.air-application-installer-package+zip" /> 476: <clientCache cacheControlMode="UseExpires" httpExpires="Sun, 19 Jul 2020 00:00:00 GMT" />

I would like to design an audit system for our department's intranet, please keep in mind, that I am not a programmer.How I invision it is audit templates would be created, there would be questions that are asked and will always have a response of yes / no / NA, plus a small window to type note.  If there is a no, it will likely also need a corrective action.  There may be 1 question or 25, each audit will be different.Then when the audit is created I would select one of the templates and create an audit for a user to perform.  The responses need to be stored electronically.  Again ir there is a "no" response, it will need an entry in another table for a corrective action.Each template will be used many times.Using a crude method I could create a table for each audit template, but that doesn't make it a very flexible system.How do I create the tables for something like this?  I'm using MS SQL.Thank you for any tips on getting this started.

CF11 ColdFusion.Window.Create has no scrollbars. I have even tried overflow: scroll in the tag attributes and can't get it to work.I'm on a Windows 2012 R2 Server.<cfajaximport tags="cfwindow"><TABLE> <TR>     <TD><img  border="1" src="/Utilities/Images/Icons/folders.ico" onclick="ColdFusion.Window.create('Window123','Sample Window','http://www.blueprintcss.org/tests/parts/sample.html',        {x:100,y:100,height:500,width:500,modal:false,closable:true,        draggable:true,resizable:true,center:true,initshow:true,refreshOnShow:false,        minheight:200,minwidth:50,overflow: scroll})"/></TD>    </TR></TABLE>

It has now been about 5 years since this bug has been in cold fusion. It won't populate cold fusion flash forms in chrome. Bug#3556744 - Flash forms created with CFFORM format="flash" do not render properly in Google ChromeCan I request that this is sorted out asap, it is pathetic that is hasn't been fixed yet!

I'm having problems getting cfpdfform to render the text-field font as it exists in the source pdf form.The source pdf form was created in Acrobat 9 Standard.When I download the pdf from the server using cfcontent, the text-fields look as expected, retaining their designated font (and the pdf has the desired fonts embedded).However, when I do a cfpdfform action="populate", the text-field font is switched with Courier (even though the desired fonts remain embedded).This happens regardless of what font I pick.I have verified that the font exists on the server and in cf admin.Here's my code:<!--- populate ---><cfpdfform action="populate"            source="#pdfPathFile#"            destination = "#pdfPathFile#"            overwrite = "yes">    <cfpdfformparam name="student_name" value="first name and last name"

Google Maps has a restriction on how many map markers can be requested per second.  The limit is ten per second.  I am looking for the "best Practice" on how coldfusion developers address this limitation.  I am looking to display a map of the US with 125 location markers.  Ideally I would like to cache the map for retrieval for both efficiency purposes and to avoid depletion of the total requests that Google allows per day.  Thanks in advance for any insight that you can lend.

My question is essentially this:How do I transform data from SQL Server and map it in Leaflet?HINT: We are running Coldfusion 11, SQL Server 2000, Leaflet and JQuery if that helps in any way. If I need to download a javascript library I can easily do so.I have ambulance and fire events in a database with xy coordinates. My goal is to query out the current events and place them on a Leaflet map. All of our ambulances and fire trucks have gps in them and they are constantly broadcasting their location and status. Here is my query for getting the latest gps data for each truck;/*SQL Server 2000David Kulpanowski4 June 2015Lee County EMS*/SELECTDateTimeStamp, RTRIM(CallSign) AS [CallSign], RTRIM(UnitStatus) AS [UnitStatus], Latitude, Longitude, CONVERT(VARCHAR(15), DateTimeStamp, 106) AS [CurrentDate], CONVERT(VARCHAR(10), DateTimeStamp, 108) AS [CurrentTime]FROM FireEMSGPSDatabaseRIGHT OUTER JOIN(SELECT  RTRIM(CallSign) AS [Ambulance], MAX(DateTimeStamp) AS [MostRecentTime]FROM HISTOR