Questions

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?

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>