ColdFusion

I have set up a scheduled task in ColdFusion Administrator using CF9. This is set up to go to a specified URL, and when this is run in a browser it sends an email as expected. However, when using the scheduled tasks, nothing happens. I have viewed the scheduler.log file and it says that it is executing as expected. One thing I have noticed, is that there is nothing under the Application Name in the server.log file.Any suggestions here would be most welcome.

Hi,I am using Cold Fusion 11 and trying to schedule an execution of an email process.Tried to send a basic email in Cold Fusion using the Scheduler. Did not receive the email.Checked the scheduler error log and the message in log is: Connection Failure: Status code unavailableThe scheduler has not been used before.The basic email functionality works standalone.Per preliminary research about the scheduler, there is information that some type of cert needs to be installed in Cold Fusion in a Java keystore.Does something need to be installed?If so, is there any detailed instructions?Thanks,Mike

I am relatively new to CF and desperately looking for help to send a meeting notice to users using CF (version 9) and Outlook 2013.Do you have a working example code that you can share?I read so many different examples but feel lost at basic initial step of making the connection using cfexchangeconnectionI work in a large company so all the servers mgmt are handled by IT group. Same with CF servers.

Hello, all,I'm using canonicalize() as part of a URL and FORM scope sanitizing process, and it's not doing what the specs say it should do.For example, in scrubbing a URL parameter, the following _should_ throw an error:www.domain.com/page.cfm?var=home%27alert(%22abc%22)%27This should trigger an error, and cause my onError() handler in application.cfc to run.  But it isn't working.url.var = canonicalize(url.var,true,true);What is going on???  Why isn't this throwing an error?V/r,^_^

Hello,I posed this question to StackExchange and then directed here. I hope someone can help. Please excuse my lack of understanding of Coldfusion.The company I work for wish to update their webpages with only small cosmetic changes. For example, changing a background cover, padding, border etc.I was informed that the site was built using Coldfusion. I can't see anything in the code to suggest it is. The only back-end is some PHP for a contact form. Aside from this, the site is static.  I would like to know the reason(s) why I cant just update the CSS and HTML in Dreamweaver and update it using SFTP? Thanks,Michael.

I purchased Cf11 Standard. Is there a way it can support oracle 11g 32bit R2 ? I don't see any options to have oracle database with CF11 in the Databasources under ColdFusion administrator. I tried installing and setting up a new server.Any help would be greatly appreciated.

Hi folks,I have a very strange problem and I cannot find a solution.I have 5 server instances (CF11 Enterprise) named: cfserver1, cfserver2 ... cfserver5Stopping cfserver1 or cfserver3 or cfserver4 or cfserver5 works as expected..But stopping cfserver2 does also stop cfserver3, cfserver4 AND cfserver5.I've alread checked all server.xml files and ports, but I cannot find the reason why stopping cfserver2 results in stopping also cfserver3, cfserver4 AND cfserver5.Does anyone have a hint for me ?Best regardsKnut

Is there a way to set one Scheduled Task to run on EST and another Scheduled Task to run on PST?

I am coming back to CF to build an application.  I have not used CF since the Allaire days so there is some learning curve here.I have started a db in MySql (Workbench) and would like to access via Coldfusion Builder.  I get the error below in the CF Administrator Data Sources tab when I try to add the new db.  I don't actually know how to point CF to the db and there is no browse tool.ThxConnection verification failed for data source: M1Connectjava.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user ''@'localhost' (using password: NO)The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][MySQL JDBC Driver][MySQL]Access denied for user ''@'localhost' (using password: NO)

Hi there... looking through the documentation I am currently having difficulty working out the standard way of achieving my requirements.I have a menu which is dynamic depending on the user and I would like to cache it.I would then like to be able to either flush the cache for a specific user or for all users at once.I was hoping I could wrap the navigation cfml in a cfcache tag such as<cfcache key="NavCache" id="id#USERID#"   >    #NAVHTML#</cfcache>I could then use the cacheRemoveAll function to clear the "NavCache" region and up this point everything is working great.The problem occurs when I then attempt to flush a specific cache object by id.I have tried cacheRemove method and the <cfcache> tag with the action="flush" attribute....however I have had no success.First off... am I going about this in the wrong way ?If I am along the right lines... what am I doing wrong?Thanks very much

I'm having a problem in CF 2016 with a grid I'm trying to populate with a bound cfc method.  If my method returns no data, I get a JavaScript error: ext-all.js:18 Uncaught TypeError: Cannot read property 'id' of undefined(…).  However, this code executes fine in CF 9.Is this a bug?  Or should I be doing something different in CF 2016 to handle a method that returns no data?My exact version is 2016.0.0.298074.Below is the code I'm testing with.  First, the page with the cfgrid:<cfajaximport tags="cfform,cfpod,cfdiv,cfgrid" /><h1>Invoke method</h1><cfinvoke component="data" method="getColors" returnvariable="qColors"><cfdump var="#qColors#" label="invoked method"><h1>Bind method</h1><cfform id="frmColors">     <cfgrid name="grdColors" format="html" pagesize="5"          bind="cfc:data.getColorsRemote({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgr

Hello all,We are planning to upgrade our version 10 Enterprise as it would not connect to our Oracle 12c enterprise database.What does CF 11 Standard give us that CF 10 Enterprise does not and would it be able to connect with Oracle 12c enterprise edition?We have installed CF on multiple servers. Is that the key of standard (install on one server only) vs. enterprise (can install on multiple servers) and would CF 11 connect with Oracle 12c enterprise database.Thanks

Question:Does a cfhttp request, using a GET method, remove Headers such as Content-Type?And if so, is there a way around this?Problem:I'm making an external API call that requires certain information be passed within the Content-Type header ...<cfhttpparam type="header" name="Content-Type" value="application/json">vs.<cfhttpparam type="header" name="Content-Type" value="application/xml">to determine the type of information returned to me. JSON or XML.When attempting to use the first param type, it returns an Error. However, when doing so with a POST method, it does not.The second param type works no matter what type of method I use.I'm using ColdFusion 11.I would really prefer to be working with JSON, but if I can't get JSON data back when I'm not using POST, I'll have to resort to using XML, a far less appealing option.

After installing CF11, I now see that there is no option for Oracle in the driver selection list anymore. I need to connect to an Oracle 11g R2 database. I downloaded the ojdbc.jar driver from Oracle and placed it in the /jre/lib folder. I've restarted CF, but do not know how to connect. Is there something I can do to get Oracle to show up in the selection list like it used to in earlier versions of CF (like 7 and 8)?

I work for a small government agency in Idaho and for the last two weeks we've been trying to purchase a copy of CF Server 11 (YES I know it's an old version) and two copies of Dreamweaver.   For reasons I can't understand Adobe just isn't interested in selling product to us. Because of a time crunch that is now upon us, our purchaser has spent the last two days on the phone with Dell software and Adobe trying to get this PO filled.  Both sides say sure no problem but neither side will deliver.  All we need is a link to download and a serial number!!!Uh Adobe... You just pushed management here into discussing options for web development other than Adobe products.  If you won't sell product to us or support us we will go somewhere else.  There are options after all. Adobe should invest in customer support!!!

I recently installed CF 2016 standard on El Capitan 10.11.6. Once I had CF installed I installed OS X server 5.2. I originally tried installing OS X server prior to installing CF but every time I would receive an error when running the connector after install. By installing OS X server after installing CF I was able to get the connector to run. OS X server works with Apache. I believe OS X ties into the pre-packaged installation of Apache that is included in El Capitan but I am not 100% sure.The issue I am now having is that when a place .cfm files in the root directory it shows the text rather than running the code. I checked the apache server.xml file and it appears the root directory is the default CF wwwroot. I placed the website files in the root directory and still only see text instead of running code.I have full access to the CF Admin panel, and can change any settings, so I am pretty sure it installed ok.I am not real knowledgeable with running terminal.Is this a connector iss

Hello people, I have an SQL query that performs some profit calculations before the result is displayed.As I was CFlooping, I noticed that while most results (chargeToCustomer - Cost = Profit) were accurate, some of them were off by 1 cent.Since I don't know SQL server functions very well, I decided to leave the calculations to Coldfusion.But I'm getting similar results. Out of 144 records, I have about 10 that are off by 1 cent.Has anyone experienced something similar?Is there any decimal function I need to add in order to respect the values? I have the perception that some values are either rounded up or down, which causes the result to be off.My formula is extremely simple: <cfset myProfit = Charge - Cost>No magic, not weird formulas and not hidden fees Thank you in advance!

Desde la web de Adobe sólo puedo comprar licencia de ColdFusion 2016 como upgrade de ColdFusion 10 u 11, pero no del 9. ¿Existe alguna manera de lograrlo o tendré que comprar una licencia completamente nueva?Por otro lado, ¿existe algún contacto comercial en España de ColdFusion?

How do I manage Credit Cards? My client uses QuickBooks, I have never developed app where it involves credit Card purchases. Can I use quickbook to do this? or what is the third party software I have to use for credit card purchases. Please give example, I am stuck on this. Thanks

I have a question that I am hoping someone might help with, an issue I come across with a daily process we have.We have a process that executes a cold fusion script on a daily basis (business days). It pulls in daily production from a file given to us with the previous day's data. On Tuesdays, we get 3 files (Saturday-Monday). We concatenate the files into one before the cold fusion script executes. The way our process works is our cold fusion script kicks off and runs a few things, and eventually ends with the following code:<cfif #qry_stgDate.stg_date# lt #qry_nextloadDate.next_date#>    <cfoutput>Got nothing to load, inform the development team</cfoutput>    <cfquery name="qry_dlDate" datasource="#request.DS#">        select max(to_date(trandate,'yyyymmdd')) as dl_date from         dl_prod_dly     </cfquery>    <cfmail to=

I have the following code and ColdFusion Builder 3 is showing I'm getting an error on line 17 on the cfdata.result & #count# concatenation.<cfset cfData = structNew() /><cfloop condition = "count lt numHttpCalls" >  <h4>Head: #count#</h4>  <cfif not ArrayIsEmpty(cateData) >  <cfhttp url="https://example.com/api/head/category.json" method="get" timeout="15" throwonerror="false" proxyServer="webproxy.example.com" proxyport="8070">  <cfhttpparam type="url" name="_authbykey" value="56a7d8c5123465c4058361237">  <cfhttpparam type="url" name="project_id" value="25c4ffd13123456527e294fe6">  <!---The limit has to be less than 10 or elese the snippet will be ignored --->  <cfhttpparam type="url" name="limit" value="10"/>  <!---Specify the categories we want to display on the page below.--->  <cfloop index="x" from="1" to="#arrayLen(cateData)#">  <!---<p>Cate Name

Just installed the latest bunch of updates and websites are running but now when I try to access the admin I get a message sayingThe Solr service is not available.    This exception is usually caused by service startup failure. Check your server configuration.       The error occurred in Application.cfm: line 89Called from Application.cfm: line 85Called from Application.cfm: line 4Called from Application.cfm: line 1-1 : Unable to display error's location in a CFML template. is there something I need to do to get it back?Thanks!

We recently upgraded from ColdFusion 10 to ColdFusion 2016.  There appears to have been a change (either in CF 11 or CF 2016) to what the log files are named when you archive them in CFADMIN.CF10 archived log name: logfilename.log.1CF 2016 archived log name: logfilename.1.logThis name change is annoying because now the archived log files show up in the CFADMIN Log File list (I assume because it is just displaying all *.log files).  If I manually rename one to the old format it does not show up.  Is there a setting/configuration somewhere to control how CFADMIN names these (perhaps to revert to the CF 10 naming)?

When installing the latest server update for CF11 on MAC, the CFServer stops working.  The message show in the CMD prompt is The ColdFusion 11 server is starting up and will be available shortly.There has been an error starting ColdFusion 11 server, please check the logs.However no logging takes place.

Hi,I have been using CFFILEUpload and CFFILE in one of my project.This has been running fine and now we are having sudden issues stating , while we upload, status error code 302 in the progress bar.I searched and could not get much information on it.Any sights on this issue..I have checked the Targeting server folder has got all permissions to write the file and session is active while uploading the file. Thanks in advance!