ColdFusion

I have a CF page that reads an XML file into a query using <cffile>, XMLParse, and QueryAddrow.I then do a QoQ on the result, and voila! I have my page.  I cache the query for 8 hours and the XML file is only re-read when that cache expires.  It works well.My problem now is that the file contains data from three database tables instead of one, so I need to do an inner join on the tables.  But I can't do a QoQ with an inner join.Does anyone know a way for me to do this?

Hello,how do I set the title of a second yaxis?There is no attribute like yaxis2title in <cfchart>  tag.I'm working on ColdFusion 11  Standard.regardsClaudia

Hello fusebox or coldbox framework, we want to help.I couldn't find a detailed lecture on the website.I want to learn the logic of the framework.Please help

I am trying to use Coldfusion search in CF Builder 3 and it does not work for me. More to that Is not event listed as an option Under Search top menu

This is a Adobe ColdFusion support community. Why is there no Syntax Highlight for even ColdFusion? There are other but NOT ColdFusion? Is ColdFusion language just not that popular anymore to even provide a code syntax highlighter? Or am I missing something here?

I have a cfform on the page. When I submit the form, I want to submit it to self. Another word, I do not want to submit to another .cfm page. So, how do I do it?

My Search menu has "Search", "File" and "Text".Both Search and File bring up the same dialog, which has two tabs - File Search and Java Search.I don't see anything related to searching specific CF tags, and I don't see anyway to search against a specific directory.How exactly do I get to the ColdFusion Search dialog box in CF Builder 2016 (3.1)?And how exactly do I license CF Builder 2016?I bought a license, but when I put my key into the License ColdFusion Builder dialog and click OK the dialog simply disappears.There's no indication that the product is licensed (or not).Thanks

I have a form in the cfm page that if the user submit the form, I do not want to go to a different page. I want it to reload the page and I'll capture all the values and send the data that way. However, I need to hide the form once the user submitted the form. So, how do I detect if the page is a reload (after it's been submitted) or it's the first time it's been loaded?

Hi Team,How to load JSON file data to database using ColdFusin scripts? Could you please reply me with code or realted links to my mail bkchaitanya@gmail.comHope you do well waiting for your responseThanks in Advance

Hi ColdFusion Team,How to load JSON file or CSV file into oracle database using ColdFusion ? Please tell me ASAPThanks in Advance

Hi guys, I have this issue where I'm using Jquery to get a simple string from a cfc and although the string is returned correctly I also get a bunch of unwanted HTML code appended to the response. The HTML  code is CF's 500 error page.It does not happen if I comment out the ajax call but as soon as I put it back it happens.  It's driving me nuts.  There are no errors listed in the logs.  The original application was not written by me and it uses application.cfm and onrequestend.cfm, I've commented out all code in onrequestend.cfm in case that's what's causing it but no change.   I've attached screenshots of the alert pop up where you can see that the response is there at the top.Been browsing for a solution but cannot find it. Not sure where to start debugging it.  It must be something soo simple that I overlook. Any help would be much appreciated.Here's my simple JS:var thisEmail = $('#emailAddress').val();$.ajax({  type: "get",  url:"cfcs/

SQL Server 2008 R2CF 9.0.1Data type: money, nullQuery name: get_paymentsFields:payment_subtotalpayment_addpayment_subtractGreetingsThe best practice method to evaluate, add/subtract dollar sums to arrive at a grandTotal (that works) is tough to find.I simply want to display the grand total on a list of orders in a "grandTotal" column.Some advise doing the math in the DB,select sum(payment_subtotal+payment_add-payment_subtract) as grandTotalbut this does not work because the query selects from 4 tables using left-Joins- where in the query would this appear?others use <cfset grandTotal = 0>  <cfset grandTotal =  grandTotal + (get_payments.payment_subtotal + get_payments.payment_add) etc.or<cfset grandTotal = ArraySum(get_payments['payment_subtotal'])+ ArraySum(get_payments['payment_add']) etc.or Loops:<cfset grandTotal = 0><cfloop query="get_payments"><cfset grandTotal =  grandTotal + ( #get_payments.payment_amount# + #get_payments.handling_cost#

I am working on Coldfusion2016 installation. ColdFusion service would not start. I ran coldfusion.exe. There is an error indicating that " Error occurred during initialization of VM. Cold not reserve enough space for 1048576KB object heap".

I'm having an issue testing a form field for a null condition.  The field names on the form are created dynamically as the form is created based on a query that returns a list of documents uploaded by a user. Each row will contain the document ID, document title and file name. As I loop through the query I create the form field name for each row by attaching the document ID to a string. Here is the code that creates the form:<cfform action="ec_process_attachment_upld.cfm"  method="post" enctype="multipart/form-data">   <cfoutput><cfif #get_attachment_list.RecordCount# GT 0>       <table border="1">       <cfloop query="get_attachment_list">             <cfset f_name = "upld_attachment_file" & #attachment_id#>             <tr>   &

I'm very frustrated calling a UDF, not getting the correct resultsHere's the function, placed in a template named "basic_function.cfm"<cffunction name="test" access="public" output="yes" returnType="string"> <cfreturn "Hello World"></cffunction><cfoutput>#test#</cfoutput>The output I get: cfbasic_function2ecfm687063398$funcTEST@70c49b0cHow can I get the string "Hello World"?

i am running CF10 on w2k8r2 with Oracle 11g backend. hf-018 installed.Our documents are uploaded into oracle as bfiles,  up til a week or so ago we had no problems with uploading or opening  these files. Now when i try to open an uploaded document it hangs.is anyone else running into this?

Hi All,I have an issue with QoQ when the division is zero. I usually use nullif in oracle queries but it is not allow in QoQ.How can I go around this issue?Code example:<cfquery name="qrySum" dbtype="query">            select 'Item01' as DESCR            <cfloop from="2011" to="2016" index="y">                ,sum(FY_#y#)     as FY_#y#                ,sum(COST_#y#) as COST_#y#                ,sum(COST_#y#) / sum(FY_#y#) as PERC_#y#            </cfloop>            from qryItems      

I'm using cffile read to access to my json file. I like to know if cffile only uses absolute path or relative too? If I tried to use relative path, it kept giving me errors about file not exist.

Anybody know of an alternative to CFX_ImageCR3 by Efflare? Efflare appears to have gone out of business and the version of CFX_ImageCR3 seems to require an ever increasing amount of memory.

Hello everyone, I have a problem with my charts after I switced form CF9 to CF11. My previous code in CF 9 was able to handle data with multiple years. After switch to CF11 my code gives me wrong chart. Looks like multiple years are combined together. Here is my photo of CF9 chart:And her is my CF11 chart:As you can see, in CF11  2015 year is first then 2016, but at the same time blue and yellow bar are in the same box. That should not be that way. Also I lost my time values on my x scale. Here is my code that I used in CF9:<cfchart format="#ffPrint#" xaxistitle="#desc#" yaxistitle="#yTitle#" style="ChartStyle.xml"  chartheight="700" chartwidth="#graphWidth#" title="#title#"  showlegend="#theLegend#" >    <cfchartseries type="bar" itemcolumn="Spacer" valuecolumn="" seriescolor="white"  >  <cfoutput>  <cfloop list="#dataList#" index="i">  <cfchartdata item="#i#" value="0">  </cfloop>  </cfoutpu

I have seen this topic addressed for previous versions, but not CF 10.we are running cf 10 on win2k8r2 iis 7.5. recently we have experienced two things: 1 our application server will just go offline about every 2-3 hours, less if being used heavily.  2. we cannot access CF administrator.  It wont except user name/password all come back as invalid.  When the server is up and running everything works fine.is the a file that can be edited to turn off  metrics and cstat?   I saw the solution for editing jrun.xml,  but... CF 10 isn't using jrun

如题，why?也无法正常使用cftextarea。

  I have Coldfusion running on Windows 2008 R2 standard, IIS 7.I went in to check the log files,  as I have been having cfdocument hanging issues, to see if I could see what is going on and I found thousands of "words-_42551637582208396016989565005225560069.tmp" files in the directory that contain the cfdocument xml output like this"<?xml version="1.0" encoding="UTF-8"?><DocText xmlns="http://ns.adobe.com/DDX/DocText/1.0/"><TextPerPage><Page pageNumber="1">Loan Presentation - Narrative NARRATIVE Description of Business / Management This is a test of Description of Business Management narrative . in the Loan Presentation . Background and History This is a test of Background and History narrative in the Loan Presentation . Current Account Relationships This is a test of Current Account Relationships narrative in the Loan Presentation . Credit Overall Strengths and Weaknesses This is a test of Credit Overall Strengths and Weaknesses narrative in the Loan

Hi,I'd like to know the licensing cost for ColdFusion 12 Enterprise Edition and the compatibility matrix of the same version please.Thanks,Indradip

Server Setup:-Windows Server 2008-IIS 7-Coldfusion 10We have developed a Coldfusion REST service.This service works when files are uploaded to the server and the Coldfusion REST service is restarted/refreshed. I test the end points and they all work.The first thing next day, I test the end points and they do not work. The return is “Status 500 - The page … can not be displayed.”I do not believe this to be a IIS problem/issue. If the files are re-uploaded and the REST service is once again restarted/refreshed the end points will start to work again. Funny thing is, just refreshing the REST service will not make the end points start working… the files must be re-uploaded first.Has anyone experienced this?Does anyone have any suggestions?***I have a feeling that the virus scanner on the server may be the cause of the REST services going unresponsive over the course of the night.Are there certain directories that should not be scanned by a virus scanner?When the REST services are compiled(