ColdFusion

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

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?