Questions

We're looking to deploy a server on AWS / Coldfusion 11 Enterprise ( LINUX ) and I'd really appreciate some advice from someone who knows this area.About the server:Only handles coldfusion CFCs  NO DATABASE ( this will be on another Amazon RDS server )Mainly handles Flash-remoting requests from AIR Apps - typically it receives request, hits database, returns datalow bandwidth - the site only hosts one swf and some cfcsThere are 3 options in our budget:M3 LARGE  C3 LARGER3 LARGE

When I try to download CF11DE on the Adobe site, that Akamai download manager thing stalls and says Access denied (Windows, on Chrome and Firefox), so despite trying over the last couple days and I still can't download it.  Is there any way to get a direct link rather than having to use the silly, unnecessarily complicated way?

Hello all,I'm new to VB .Net as well as coldfusion flatforms.I've got an issue while running vb .net dlls from coldfusion ui side.I'm trying to call vb .net dlls from coldfusion ui. i'm able to create cfobject. but functions having reference type parameters are unable to dump or unable to call from coldfusion.  Public Function InitDB(ByRef ConnectionType As String, ByRef In_Ansrefid As Integer, ByRef TestFlag As Boolean) As Short functions having ByRef are not identifing by coldfusionCould please suggest me why reference type parameter functions are not identifying by coldfusion?if possible could please suggest me any documentation which describes how to call vb .net dlls from coldfusion ui part.

HiWe are trying to work with a 3rd party server product that has a REST API so we are using cfhttp to interact with it.  We want to implement two-way SSL for the calls so that it is only our app that is able to make calls to the REST API.  So we put a password protected .p12 cert into C:\ColdFusion9\runtime\jre\lib\security and from the same location import the p12 into the keystore via the command:..\..\bin\keytool -importkeystore -srckeystore CAAT_Client.p12 -destkeystore cacerts.jks -srcstoretype pkcs12 -deststoretype JKS -alias contentanlystclient -destalias CAAT_ClientP12 -deststorepass changeit -destkeypass changeitThe process asks for the password for the cert and then seems to import it.  I say seems because it is not in the list when I do:..\..\bin\keytool -storepass changeit -list -keystore cacertsHowever, if I try to reimport the cert it says: Existing entry alias contentanlystclient exists, overwrite? [no]: It seems that maybe the -list command only lists .ce

Hi,I am just starting our with Coldfusion Builder and I am baffled by an error I can't seem to resolve.Using localhost and coldfusion Builder default root: C:\Users\hp\ColdFusion Builder 3 workspace\MISTweb, whenI attempt

I have to create several reports who's data will be displayed like this:TYPE# COMPLETEDTURN TIMEMulti-Family (MF)Multi – Family FHASingle Family (SF)Single Family FHACondoLandTotal/Average:Total: Average:It seems I would need to query separately for each "TYPE"? Everything I tried outputs Cartesian products -The action page from the date search (BUSINESS DAYS ELAPSED) form:<cfset Session.StartDate = "#CreateODBCDate(FORM.StartDate)#"><cfset Session.EndDate = "#CreateODBCDate(FORM.EndDate)#"><cfscript>function businessDaysBetween(date1,date2) { var numberOfDays = 0;while (date1 LT date2) {date1 = dateAdd("d",1,date1); if(dayOfWeek(date1) GTE 2 AND dayOfWeek(date1) LTE 6) numberOfDays = incrementValue(numberOfDays); }return numberOfDays;}</cfscript>HOME SALES (order_type_ID = 1):<cfquery name="client_report_sales" datasource="#Request.BaseDSN#">SELECT order_ID, order_property_type_ID, order_order_type_ID, order_status_ID, order_create_date, order_inspection

Hi,I am in the process of converting the pages from a cflayout (tab format) into individual pages because the the pages in the tab format work with some users IE 8, 9 and 11 browsers and does not work with other users IE 8, 9, 11 browsers.In the tab format, when the Update Calculation link is selected, the page would take the values entered in the Number of One Way Trip/Day and Day/Year and calculate the value for the Total calculated units box. (Per the image)When creating the individual page, is there a way to have the page refresh, keeping the value entered in the Number of One Way Trip/Day and Day/Year, when the link is selected to have the calculated value placed in the Total calculated units box?Thanks,Mike

Hello all,I'm new to VB .Net as well as coldfusion flatforms.I've got an issue while running vb .net dlls from coldfusion ui side.I'm trying to call vb .net dlls from coldfusion ui. i'm able to create cfobject. but functions having reference type parameters are unable to dump or unable to call from coldfusion.  Public Function InitDB(ByRef ConnectionType As String, ByRef In_Ansrefid As Integer, ByRef TestFlag As Boolean) As Short functions having ByRef are not identifing by coldfusionCould please suggest me why reference type parameter functions are not identifying by coldfusion?if possible could please suggest me any documentation which describes how to call vb .net dlls from coldfusion ui part.

I am running CF 8, J2EE and need to modify the JVM settings. After doing some research, it seems like you can do this through CF Admin if you are NOT using J2EE - otherwise it's a lot more complicated. Can anyone confirm if that's the case (I don't see any JVM options in our CF Admin instance right now), and if so, what the best way to go about making changes would be? Thank you!

I have installed installed CF10 on Windows2012R2 under a trial license and now wish to apply the license code I have been supplied with. When applied it errors with "the serial number you have applied is invalid". The text with the license says this applies to CF11 but I was told that this will still work for CF10. What is the workaround for this?

I'm working with a database that stores links to various pieces of government regulation.  Each regulation has a discipline, subdiscipline, regulation type, and responsible office.  Each one also has a list of assigned keywords.Previously, we were just using an HTML form to do a <cfquery> to search these items.  At one point, someone tied our Google appliance into the keyword search to improve results, but now we're dumping the appliance due to cost issues.  I've been asked to come up with a replacement for the appliance, so my first thought was Solr.I've created a collection, then used cfindex to index it.  If I use cfsearch to pull keyword results, it works quite well.  Here's my cfindex tag:<cfindex     collection="docsearch"     action="update"     type="custom"     category="category_name"     body="keyword"    custom1="discipline"    cust

CF11, getting every 5 min message: [ajp-bio-8014-exec-423] - An error occurred while fetching element from authcache in the coldfusion-out.logWhat is the reason of the message?

Hi we are in the process of migrating from CF6.1 + oracle 8i to coldfusion 8 + oracle 10g and I keep having this error in the log files:"Element NATIVEERRORCODE is undefined in CFCATCH." I think the error is happening somewhere in this codes: <cfcatch type="any"> <cfset ok = false> <cfif request.debug> <cfoutput> #cfcatch.message#<br><br>#cfcatch.detail# </cfoutput> </cfif> <cfset validPageRequest = true> <cfinclude template="../../o_generic/cfm/cf_log_err.cfm"> </cfcatch> Any ideas?? Thanks in advance

I have a form that collects the personal info then it loops through items so the user can add a row of addition items. ​Upon submitting my form,the personal data is inserted into a mySQL table, it then inserts the items into the items table by a cfloop. It works great but my clients now wants me to incorporate a popup window upon submitting the form. The popup will ask if they "Are sure your order is complete." If yes, then the form is submitted. How can I get the popup window to send the data to the appropriate tables?Below is the cfloop I am using:<cfloop from="1" to="#getnumba#" index="idx">            <!--- At first, it displays the original one row form --->            <!--- User enters the data and hits "Add Another" --->            <!--- The page reloads with the data already entered and creates

Hi All,How can I define a function that call a Oracle sp but right away return something?The sp is a long process, I can check if the process finish later with another function.<cffunction name="callFunctionCC" access="remote" output="false" returnformat="any">     <cfargument name="myID" type="numeric" required="true">     <cfset var myResult = "The process start" />     <cfset var qryData = "" />     <cfstoredproc procedure="TT.CALCS.getLongProcess" datasource="#application.str_dsn#">         <cfprocparam value="#arguments.myID#" cfsqltype="cf_SQL_NUMERIC">         <cfprocresult name="qryData">     </cfstoredproc>     <cfreturn myResult/></cffunction>Thanks,

I am attempting to implement a REST endpoint that accepts a multi-part form request that includes form data as well as a file upload. Is that even possible? Is it possible to just accept a file upload and nothing else (e.g. specify a unique ID in the URL and POST/PUT data in the request body)? I've tried numerous things and have been unable to successfully implement a REST endpoint that accepts a file upload...Specify a CFARGUMENT type="binary" to the CFFUNCTION that is the REST endpoint definition. This results in a CF REST API compile error.Submit a multipart/form-data POST/PUT request and use CFFILE to handle the file upload in the body of the CFFUNCTION. This causes the CF REST framework to not see any of the form-field parameters that are required by CFARGUMENT tags.Uploading the file to a separate endpoint that expects only the file and setting the HTTP content-type header to the file's MIME type. The CF REST framework rejects this because it wants a specific content-type (presum

I'm consulting for a company, and their server is being used by intruders to send spam email. It is Windows 2008 x64 with IIS, CF9, and SQL Server. The CF server is running their home grown web site, and my suspicion is that there is an unsecured .cfm file that allows all cfmail parameters to be provided via form variables, or else the intruders got their own .cfm file somewhere that's doing it. The files showing up in spool and undelivr all appear to be formatted in such a way that they look just like legitimate emails I compared, so that's another reason I think it's a rogue .cfm file. I have mail logged turned all the way up to debug, but it still doesn't show where the email "came from". I found other evidence of exploit severe enough that I have informed the customer that their server needs to be completely flattened and reinstalled before it cant be trusted again. I'm going on site in 3 weeks to do this rebuilt, but in the meantime, I am continuing to see evidence that spam email

Hello,I tried to add this as a bug to the Coldfusion Bug tracker (https://bugbase.adobe.com/) but ironically, I get a default Coldfusion error page when I log in.I believe there is a serious bug with the for-in construct when used in a particular fashion. In particular, if the "in" expression is a function call, it appears that the function is invoked multiple times (to be precise, it always appears to be 5 times).Clearly there are many situations where this could have serious consequences, not least if the function does any serious work.Key points:Tested on Coldfusion 10 update 16Using a for-in construct where the "in" expression invokes a function results in that function being invoked multiple times.It doesn't seem to matter what the function returns (e.g. struct, array, potentially other iterables)Workaround:Assign the result of the function call to a local variable outside the for-in constructSeverity:This a serious issue as,It is easy to cause using a common idiomIt is completed

I'm trying to create a check to distinguish between someone requesting the default page vs. explicitly requesting the default page. I'm running CF11 under IIS. My site has a default document of index.cfm. I need to determine if the user requested http://my.domain.com/ vs. http://my.domain.com/index.cfmI cannot find any difference in the CGI scope between the two calls and I've also looked at the contents of getHttpRequestData() to no avail.

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