Questions

I have a CF app which needs to process totals for property and items like that, then I need to send that to .cfr fileSo how does regular CF communicate in an interactive mode with the report builder?Kevin

So here's a Query I need to build a subreport around...<cfquery name = "ac" datasource= #ODBC_DataSource#>  SELECT tblArea.OIDEMSMaster, tblAreaStructure.OIDStructureTypeRef, Count(tblAreaStructure.OID) AS CountOfOID,  SUM(tblAreaStructure.SF) AS TotalSF, SUM(tblAreaStructure.ReplacementCost) AS TotalRC, SUM(tblAreaStructure.LSI) AS TotalLSI  FROM (tblArea INNER JOIN tblAreaLocation ON tblArea.OID = tblAreaLocation.OIDArea)   INNER JOIN tblAreaStructure ON tblAreaLocation.OID = tblAreaStructure.OIDAreaLocation  GROUP BY tblArea.OIDEMSMaster, tblAreaStructure.OIDStructureTypeRef  HAVING (((tblArea.OIDEMSMaster)=#URL.OIDEMS#));</cfquery>And this is what I did in the 'builder':So I did the join from tblArea (primary key) to tblAreaLocation (foreign key), and then tblAreaLocation (primary key) tblAreaStructure (foreign key).I think I got this on right (options/suggestions...)!So I'm trying to build this: SUM(tblAreaStructure.SF) AS TotalSF, SUM(tbl

I am having weird issue - my CF application restart every 15 minutes - even though it is set to 2 hours in cfc and 2 days in cfadmin,...anybody experienced this issue?

Hi CF forum,I am VERY new to CF and I am working with a script which exports a database to an .xls file. It all works fine, but what I noticed is that in SOME cells (not all), it seems to skip over some of the data so I get this effect:DIETSPECIAL_NEEDTICKETCOSTIDnoneRegular502A19B7EFnoneRegular50392DDDDFnoneRegular508C6F0EA1noneRegular5094A9CF7DnoneRegular5094AB5198noneRegular5094B987B8noneRegulardontemail5094C439D1noneRegular5094C99CA9As you can see, my "dontemail" field seems to have skewed my table. This is data which doesn'tappear in all fields, but has a table name of "dontemail"which doesn't come through. It looks fine in the database, so all the data is where it's supposed to be, but it doesn't show up right on the export.Here's the code which generates this:<cfoutput>DATE/TIME ENTERED<cfloop list="#rsdata.fieldList#" index="c">#DelimChar##c#</cfloop>#NewLine#</cfoutput><cfoutput query="rsData"><cfsilent><cfwddx action="wddx2cfml" input="#

We are converting from SharePoint to DocuShare and have a ColdFusion development platform and we are looking for any ColdFusion code which helps to access the DocuShare API.Thanks,Chuck Fennimore

I can upgrade Tomcat myself, but that approach isn't documented and isn't likely to be supported by Adobe.Tomcat is bundled as part of ColdFusion 11, so I would hope Adobe would either provide a hotfix or suggest a supported method to upgrade Tomcat.Tomcat 7.0.59 fixes the following issues:Security Manager bypass CVE-2014-7810Request Smuggling issue CVE-2014-0227Denial of Service issue CVE-2014-0230

Hi all,we have some problems with CF11. I'll try to explain:our server configurations:- coldfusion 11 linux- oracle 10g- apache 2.4.6we have coldfusion enterprice (1 cluster, 1 instance) with 8gb ram dedicated.we have this problem:It works very well but sometimes we notice a sudden increase of incoming requests (about 1000/2000) and we saw the server unresponsive.this situation lasts about 10 minutes.we receives many CF timeout error like this:The request has exceeded the allowable time limit Tag: CFQUERY The specific sequence of files included or processed is: /webdat/vol1/htdocs/IGP_WEB/channels/condor14/404.cfm, line: 28and CF sends to Oracle a connection exactly every 5 seconds.ex:(HOST=192.168.100.71)(PORT=41521))  establish  IGP * 010-JUN-2015 14:45:01  (CONNECT_DATA=(SID=IGP)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=cfusion)))  (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.71)(PORT=41677))  establish  IGP * 010-JUN-2015 14:45:06  (CONNECT_DATA=(SID=IGP)(C

Adobe Cold Fusion9.0はAWS上で稼働しますか？

i'm trying to get cfbuilder to work on my el capitan mac book air. the installer runs through and doesn't report anything major. but when i go to load it i get a popup telling me i have to go download the legacy java 6 for it to run.anyone else worked around this? seems odd to force me to install a version of java which has known security issues and is not supported by anyone.

My code:<cfajaximport tags="cfform,cfwindow,cfdiv">     <html>  <head>  <title></title>  </head>     <body>  <cfwindow width="500" height="310" center="true"    name="test" title="Test"    initshow="true" draggable="true" resizable="false" modal="true"    closable="true"    headerstyle="color:red;font-size:18px;"/>  </body>     </html> Header of the window does not change. I s this a bug?

I'm in a catch 22 situationI've got Coldfusion 11 (64 bit) running on Win2K12 server with IIS 64 bit.I have a 32bit COM object I'm trying to use. I've setup a classic ASP page to test it because Coldfusion breaks when I set "Enable 32 Bit Applications" to TRUE within IIS for the DefaultAppPool.Enabling 32 Bit applications allows the object to be created however doing this breaks Coldfusion with an HTTP Error 500.0 - Internal Server ErrorDetailed Error Information:Module   IsapiModuleNotification   ExecuteRequestHandlerHandler   cfmHandlerError Code   0x800700c1When I set "Enable 32 Bit Applications" to FALSE, Coldfusion starts working but then I cannot create by object.error '800a01ad' Automation server can't create object /boltz/FaxList.asp, line 6 Does anyone have any suggestions?Thank you!

We were using the GetHttpRequestData().headers["X-REWRITE-URL"] variable for our SEO optimized websites. Now we have upgraded the website to Coldfusion 11 and now we have no possibility to read our SEO URI from coldfusion request headers.Is there any other way to read this variable?

How do people restrict requests to CF files when using IIS 7 or 8 ? We can use URL Authorization, which works for all files except CF files. CF file requests bypass the IIS restrictions.We've worked with Adobe technical support and tried using Windows file/folder permissions to restrict CF access. But IIS needs anonymous access to check read web.config.Seems like I must be missing something basic here ...Any ideas?thank you,Chris

When running this code:<cfset sessionTracker = createObject("java","coldfusion.runtime.SessionTracker")><cfset sessionCount = sessionTracker.getSessionCount()>My total session count it 500, yet in the metric log for the same instance I see session count is 1500.   Why such a difference in numbers?  Which one is correct?- Alex

Hello everyone, I have two queries qryCustomer and qryStore. I have to loop through both at the same time. I tried to do this but that gave me duplicates.<cfloop query="qryCustomer">    <cfloop query="qryStore">          Insert Into tblResults          Values(#Name#,#Id#);     </cfloop></cfloop>If anyone knows how I can loop through both of them at the same time that way i can avoid inserting all ID's for the same Customer please let me know.Thanks in advance.

Hello, all,Can anyone suggest reasons as to why, after 8 months of working fine, a variable set specifically in the VARIABLES scope would suddenly stop working?In my Application.cfc file, within the "onRequestStart" function, I have the following line: <cfset variables.praglink = "//" & cgi.server_name /> It's been working since March of this year.  This morning, I open a page in the browser (my DEV environment uses one physical machine for CF, one physical machine for DB, and my development system), and get the following error message: Element PRAGLINK is undefined in VARIABLES The error occurred in {dev path}/wwwroot/public/header.cfm: line 20 header.cfm line 20 is: <link rel="stylesheet" type="text/css" href="<cfoutput>#variables.praglink#</cfoutput>/style/public.css" /> It was working fine, Friday; today, not at all.All the other variables set in the variable scope are present.  CFDUMP shows the rest are working.  Just not PRAGLINK.I

I am trying to create multiple instances to access a website we are moving from version 9 to version 11, when creating the instance, I check the box to create the windows service, in case we need to restart that one instance, but it does not create the service for that instance. I can see how I can shut down, edit, and restart that instance in the administrator, but I would like to be able to restart it in windows services. Is this a new behavior or is it because I've already gone through the lockdown guide and it can't create the service? I tried changing the account that coldfusion runs under back to the local system account and that doesn't help either. Is this the preferred behavior, should I run these instances without services, or should I have created the instances before I locked it down.Thanks.

In CF Report Builder 10...lets say I make my first page in the 'builder' and it's a cover page. Contains a Report Header, a Page Footer, a bunch of labels and a .gif image.Now I'd like to test that, so would I use code snippet, and use a cfoutput to display the page? Or can I use cf code to output the cover page to my http://127.0.0.1/CFIDE/mes/test1.cfm‌ from within the 'builder'?

lets say I use the first report to create a cover page, and now I want to in to the Query Builder a sub-report.This section will handle the next report...is that not correct?

Hello, we have following situation and can't seem to find a fix or workaround for it. Could you help?On all 4 of our Windows Server 2012 R2 servers running on vitrual machines with 8 vcpu cores each, we have 10 instances running ColdFusion 11 update 6, the instances are the same on all 4 servers, 2 servers are used for test/qa and 2 for production. On all of those servers, after servers are restarted some instances don't start properly and need to be manually restarted to start working; it seems that on average at any time 2 to 4 instances won't start and those are not the same instances every time. We were looking at the log files and we think we found what the issue is, but not sure how to go around it or fix it. When instances are starting, the following error shows up in the logs files of the instances that don't start properly (see down this post for actual log entries):Oct 13, 2015 7:52:25 AM org.eclipse.jetty.util.log.JavaUtilLog warnWARNING: FAILED ServerConnector@69f41e78{HTTP

FIRSTSo I have a cover page occupying the Report Builder 10, Report Header and the size is 11 x 8.5.The Page Footer contains labels for the display of the company name, all rights...,copy right..., name of the report and date.I'd like to display this so I know it's going to work. The cfoutput tag works only on queries...so is there a CF method to display the 'report header & page footer'?This experiment contains a .cfm file with the query and the .cfr files, using Crimson I see the file (test1.cfm)test1.cfm:SELECTtblStateProvince.State, tblStateProvince.Name, tblFacility.Name as FName, tblFacility.City, tblFacility.PostalCode, tblFacility.Address, tblFacility.OID,ContractNumber,ContractEffectiveDateFROM  tblFacility INNER JOIN tblStateProvince ON tblFacility.OIDStateProvince = tblStateProvince.OIDWHERE (((tblFacility.OID)=37667)); Here is where I tried to assign the string to the 'Label' on the Report Header.tblFacility.Name = "Yosemite Valley, LLC"TReportStaticText104 = "#tbl

          Hi everyone. I have this one page on our site that we would like for customers to order some parts from. It is separate from our current database on our site and there really are no part numbers because the calculations for the parts are on the fly (depending what the user chooses). Here's the link: https://www.ironwoodelectronics.com/elastomer.cfm We do not have our certificate updated yet, so you might get the unsecured page, but it's safe to use. We're not going to ask for credit card info. on here. I think we're going to go through stripe.com for that.           But what I don't know how to do is to create a shopping cart for this page. If the user goes through and chooses the correct dimensions of what he needs, I have the info. with pricing output to a table at the bottom. The problem is if they choose a different part with different dimensions, I lose the info. from the first opti

Hello, all,I'm helping one of my developers with a project, and I've got one requirement that I'm not entirely sure how to proceed with it.The page in question runs a SELECT query from the database and displays the tabular information in a table.  As the table is being generated, I'm using spreadsheetnew() and associated commands to create an Excel object from said data.Now, it would be real easy to introduce code that would automatically offer the Excel object as a spreadsheet upon page load.  What is being requested is for there to be a link to start that stream/download upon click; in case the user doesn't want to save or open the spreadsheet.I don't want to run the query a second time to generate the Excel object.  Is there a way for me to pass the Excel object to another page to start the stream/download?V/r,^_^

hey in the query builder of report builder 10 I got an error on:FROM  tblFacility INNER JOIN tblStateProvince ON tblFacility.OIDStateProvince = tblStateProvincewhat is java.swl.SQLException: [Macromedia][SequeLinkJDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Join expression not supported.Why?

Hi,Is there a way to integrate ColdFusion with Adobe AEM?Thanks a lot