ColdFusion

Hi,I have been working with the CF admin api on CF 2016 (patch 6) and when I try and do anything with security, datasources, etc I get an error on the CHECKADMINROLES function. I am using the admin user, even tried creating a new user with full access to everything just in case. Anyone know a way around this as the docs are pretty poor.ERROR:coldfusion.runtime.CustomException:        at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142)        at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696)        at cfaccessmanager2ecfc293914889$funcCHECKADMINROLES.runFunction(/CFIDE/adminapi/accessmanager.cfc:57)        at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)        at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)        at coldfusio

Hello All,I have this simple code to show a pop up window using cfwindow:<cfajaximport tags = "cfwindow"><cfwindow initshow="true"  x="200" y="200"> this is cfwindow contents</cfwindow>It supposes to show a pop up window with the words say "this is cfwindow contents".BUT I only see "this is cfwindow contents", there is no frame, no pop up window, and it gives me NO error, I think it has something to do with css.It happens the same thing with ipod, cflayout.It's hard to fix  the issue since it not gives me any error messageI wonder if anyone out there has the same issueThank youHPpham_mn@yahoo.com

If one uses the Help>Check for Updates feature in CFBuilder 2018 beta, it returns an error:No repository found at https://cfdownload.adobe.com/pub/adobe/coldfusion/PR/cfb4standalonerepo.Of course, I realize that today there are no such updates for the beta, only 3 days old, but over time people will think to check this, and it seems there ought to be a repo with whatever it needs so that it gets no error, but instead causes this to return the message that there are no updates, like we would get in production CFB deployments between available updates.

Hello All,I have this very simple code to show a pop up window using cfwindow:<cfajaximport tags = "cfwindow"><cfwindow initshow="true"  x="200" y="200"> this is cfwindow contents</cfwindow>It supposes to show a pop up window with the words say "this is cfwindow contents".BUT I only see "this is cfwindow contents", there is no pop up window, and it gives me NO error, I think it has something to do with css.I have spent a day to debug it but I  don't have any luck.Since it not gives me any error messageI wonder if anyone out there has the same issueThank youHPpham_mn@yahoo.com

Hello, all,I've recently been tasked to investigate using Twitter, Facebook, and YouTube APIs on our public-facing page. I have been looking into it, and the Twitter API is very simple - they even have a page that you can use to customise the look and feel of whatever page you wish to grab tweets from and it creates an anchor tag with all the parameters. Very nice.However, I have come across a stumbling block. The Facebook and YouTube APIs involve using IFRAME. On our network, IFRAME is proscribed. Major security issue (primarily cross-site scripting.)Is anyone aware of alternative methods for putting a Facebook or YouTube widget on a site that does NOT use IFRAME?V/r,^ _ ^

I previously used CF10, and had a copy of CFML Reference and Developing ColdFusion 10 Applications​ to look things up in.I'm looking for the CF2016 versions of those documents, and I don't see them anywhere. There's an Archive​ with links to all the older versions, but no equivalent for CF2016. Somehow I did get a file called coldfusion_2016_cfml_ref.pdf but it's a stub, containing web links instead of documentation for tags and functions.Did they give up on producing an actual manual? Do I have to rely on flaky web searches instead of having a fast, reliable, searchable-on-my-own-terms, local copy? Or did I just miss the link to place where the real documentation is kept?

Hello all,I'm a project lead for my company and am currently evaluating switching to ColdFusion Builder 2016 from Dreamweaver as our primary IDE.  As such, I'm having a bit of a learning curve finding some neccessary items for our development and deployment strategy currently in place.  Granted our set up is not the best, and if I would have been around when it was initially designed, would have done it differently, but doing a complete change at this time is not really an option.Our current set up, every developer has a local server configured (we are currently developing in CF9, but I'm working on getting us switched to CF2016, lots of issues to work out with that).  When a developer is working on stuff and ready to test it on a our staging server, they compare files to the remote staging server, merge any changes that other developers may have made, then upload the new version to the staging server.  This is all handled through RDS currently.As part of the upgrad

I created the following stored procedure to summarize counts by week:CREATE DEFINER=`user`@`%` PROCEDURE `TT_by_Week`()BEGINSET SESSION group_concat_max_len = 1000000;DROP TABLE IF EXISTS tmp_results;CREATE TEMPORARY TABLE tmp_results ASSELECT td_type, FROM_DAYS(TO_DAYS(ttDate) -MOD(TO_DAYS(ttDate) -2, 7)) AS ttDate, ttCategory, ttNum, Count(ttNum) ticketsFROM v_closed_ticketsWHERE extract(year from ttDate) = '2018' AND ttCategory IN ('TT')GROUP BY td_type, ttDateORDER BY td_type, ttDate ASC;SELECT CONCAT('SELECT td_type, ',tickets_by_dates,'FROM tmp_resultsGROUP BY td_type WITH ROLLUP')INTO @queryFROM(SELECT GROUP_CONCAT(CONCAT('IFNULL(COUNT(CASE WHEN ttDate=''',actual_date,''' THEN tickets END), ''-'') AS "',col_name,'"')) tickets_by_datesFROM (SELECT actual_date, DATE_FORMAT(actual_date,'%m/%d') AS col_nameFROM (SELECT DISTINCT ttDate AS actual_date FROM tmp_results) AS dates) dates_with_col_names) result;PREPARE statement FROM @query;EXECUTE statement;DEALLOCATE PREPARE statement;E

Howdy,Does CF2016 support local and remote EJB calls to different Application Server(JBOSS) ..? If not can CF configuration be modified to support EJBs ?

Hello,Q1: The api manager installs on port 9000.Would I typically install the manager on port 80 for production use so my subscribers see a url like this?http://api.mydomain.com/API/v1.0/ping?api_key=123456789abc Q2:If we are only going to have 1 API is there anyway to remove the /API from my example so it looks like this:http://api.mydomain.com/v1.0/ping?api_key=123456789abc Q3: Since i am using the API manager would I put my actual API on an internal IP that only the API server has access to?Q4:  If am sending the api key to my api from the api manager, how does my api verify the api key is correct?  Do I need to connect to the redis db to check the api?

I have this field where my users can enter notes<textarea id="solution" cols="150" rows="10" name="notes" ></textarea>The value "notes"  field gets passed to another page through the url.The problem is that the line breaks/paragraph returns/formatting doesn't get savedthey filed gets passed like thishttp://abc.corp.cfm?Load=40156&notes=AB How can I pass the notes field through the url where the formatting is kept?

Anyone run into issues with their code not working when trying to upgrade from an extremely old version of ColdFusion like CFMX 7 or CF8 to the latest and greatest?Wondering if CF 8 code was easily copied and executed into CF 2016 or CF 11?Just curious.Thanks in advance!

I went into the CFIDE in CF11 to add a new SQL data source and ran into an issue. So, I type in the Data Source Name, select the MS SQL driver, hit the Add button and the form refreshes to blank fields and no data source is created. I know it's supposed to take you to a detail page where you can enter in login info, etc, but it never does. It's almost like the form submits itself back to the page but no processing ever occurs. Things I've tried:Restarting CF.Multiple different browsers.Different computers.Ensured ad blockers were disabled.Ensured CF 11 was up to date.Tried to select different drivers from the dropdown select box just to make sure.The server is CF 11 Dev Edition. I'm not aware of any restrictions on the dev edition that would prevent me from adding a data source. I have 3 active data sources currently and had no problem setting them up.Any ideas? I've wasted 4 hours trying to figure this out already.Thank in advance

I have a page which has been the same since CF7. Recently we moved our application to CF11 to support TLS1.2 and I've since noticed that this one particular bit of code has stopped functioning correctly and it's lead me down a weird road. This is the following code block. It's meant to create date/time ranges for conditional statements and compare the current time against those ranges, performing a certain task.<!--- Set date ---><cfset thisDate = getDate()><!--- Determine what flight they should see. ---><!--- If it's after 9am and before 10pm ---><cfif thisDate GTE CreateDateTime(DatePart("yyyy",thisDate),DatePart("m",thisDate),DatePart("d",thisDate),9,0,0)ANDthisDate LT CreateDateTime(DatePart("yyyy",thisDate),DatePart("m",thisDate),DatePart("d",thisDate),21,0,0)><cfset d1 = "#DatePart('m',thisDate)#/#DatePart('d',thisDate)#/#DatePart('yyyy',thisDate)# 9:00:00"><cfset d2 = "#DatePart('m',thisDate)#/#DatePart('d',thisDate)#/#DatePart('yyyy',this

We recently upgraded to ColdFusion 2016.  When trying to add a datasource, Microsoft Access with Unicode doesn't appear in the available list of drivers.  We have a 32-bit machine and that does appear.  Is this simply how 64-bit works, or am I missing something?

Anyone having trouble with CF11 caching CF10 files when they upgraded?  Where do I change the settings to the ColdFusion 11 directory rather than ColdFusion 10?HTTP Error 500.19 - Internal Server ErrorThe requested page cannot be accessed because the related configuration data for the page is invalid.ModuleIIS Web CoreNotificationBeginRequestHandlerNot yet determinedError Code0x80070003Config ErrorCannot read configuration fileConfig File\\?\C:\ColdFusion10\cfusion\wwwroot\ipmcenters_org\web.config

I have tried to clone my dev server to make test and UAT servers, but it has gone horribly awry.IIS crashes after reboot as soon as you bring the cloned instance up.  Uninstalling and reinstalling ISS fixes this, but then you can never connect ColdFusion back to IIS.  If you try to run wsconfig.exe and add a web server, it just tells you that "All the IIS sites are already configured by some other version of ColdFusion.I got ColdFusion support on the phone and we went through a bunch of things but could never find a root cause.  We played with temp directories, reinstalled ColdFusion, turned off the Windows Process Activation Service, made dummy IIS sites running as a new user and then tried to connect to the dummy site, none of it work.ColdFusion support seems out of answers.  Anyone have any idea?  I would hate to have to build every server from scratch rather than cloning.

Hi,We had to start from scratch on our test server, so the sysadmin team installed ColdFusion 11 and attempted to connect IIS.  The .cfm pages show up fine in the CFIDE directory, but we need our 'web root' to be a different directory on a different drive (F:\someDir).  The .cfm pages in the different directory (F:\someDir) display as html (including showing the ColdFusion tags).  This is our first time trying IIS, in the past we've successfully connected using Apache, but not on this new server.We've checked directory and file permissions.  We've removed the web connector and added it back.   The sysadmin team created a site in IIS with F:\someDir. Unfortunately I don't know enough about IIS to help our sysadmin team troubleshoot, but I'm guessing it might be related to a 'Jakarta virtual directory in IIS for that site'. Can anyone explain 'Jakarta virtual directory in IIS' in more detail or give some ideas on what could be happening?Thanks!

We recently had an outage in one of the Production environments where the monitoring service didnt start and below is the error we saw in the logs.[8/31/17 4:52:21:286 MDT] 00000069 SystemOut     O Aug 31, 2017 04:52:21 AM Error [server.startup : 0] - Unable to initialise Monitoring service: java.lang.NoSuchMethodError: org/slf4j/spi/LocationAwareLogger.log(Lorg/slf4j/Marker;Ljava/lang/String;ILjava/lang/String;[Ljava/lang/Object;Ljava/lang/Throwable;)VI see the below error in exception.log that the Monitoring service is unable to initialize.-- exception.log"Error","server.startup : 0","08/31/17","04:52:21",,"Unable to initialise Monitoring service: java.lang.NoSuchMethodError: org/slf4j/spi/LocationAwareLogger.log(Lorg/slf4j/Marker;Ljava/lang/String;ILjava/lang/String;[Ljava/lang/Object;Ljava/lang/Throwable;)V"java.lang.NoSuchMethodError: org/slf4j/spi/LocationAwareLogger.log(Lorg/slf4j/Marker;Ljava/lang/String;ILjava/lang/String;[Ljava/lang/Object;Ljava/lang/Throw

I've found an odd quirk in cfgrids (CF11 U14) when viewed through Chrome (Version 67.0.3396.87 (Official Build) (64-bit))When zoom is set to 100%, the following cfgrid behaves as expected.  It display 10 records in the 310px high area and can scroll all the way to the last record.<cfgrid name="testGrid" title="Test Grid" format="html" pageSize="1000" height="310" width="500"selectOnLoad="false" stripeRows="true" preservepageonsort="true" bind="...query..." >     <cfgridcolumn name="var1"  header="Var 1" width="100" />     <cfgridcolumn name="var2" header="Var 2" width="290" />     <cfgridcolumn name="var3" header="Var 3" width="60"  />     <cfgridcolumn name="var4" header="Var 4" width="50"  />     <cfgridcolumn name="var5" display="false"  /></cfgrid>However, if Chrome is zoomed to less than 100% or is 110%, it appears t

e're trying to run the CF 2016 server alongside a Java Middle Tier running in a JBoss EAP 7 Standalone server.  I'm copying over the .ear file and the appropriate client .jar files, but when we actually go to lookup the jndiName on the InitialContext, the server fails.  Neither the ColdFusion log nor the Middle Tier server.log show any errors.  We have already shown that we can hit the Middle Tier from a test connection tool running in Eclipse.Has anyone else encountered this problem, and/or is there some CF Server setting that might be wrong?Below are the settings for the InitialContext and the method to get the InitialContext.  The bolded line is what fails.Joshua Sharf @SuppressWarnings("unchecked") public <T> T getRemote(Class<T> remote, String jndiName) { InitialContext initialContext = null; T remoteReturned = null; try { initialContext = getInitialContext(); remoteReturned = (T)initialContext.lookup(jndiName); } catch (Exception e) { _logger.

I need to set up a CMS to post to Facebook and Twitter. I know that I need to set up authorisation first but i am completely lost with it. Is there an "idiots guide" tutorial that explains it step by step for CF10?I've tried looking at this:GitHub - coldfumonkeh/oauth2: A ColdFusion CFC to manage authentication using the OAuth2 protocol but i have no idea what I am doing. Can anyone suggest an alternative/place to look at?Thanks (hopefully).

Hi,We have new requirement from security department to reset jsessionid after a user resets his password. I tried to reset it with this statement <cfcookie name="jsessionid" value="#VARIABLES.RandomID##cookie.jsessionid#" domain="#REQUEST.Site.Domain#" httponly="true" secure="yes">But, this created a second jsessionid.CF2016Thank you,Gena

We've recently upgraded CF11 to CF2016 in our dev and stage environments a few weeks ago.  After weeks of testing, we decided to push to production with:Ubuntu 16.04.1 LTSCF2016, Update 6Java "1.8.0_171"Apache 2.4.18Redis 2.6.13 for session managementEverything worked well for a day or so, then we started to see high CPU utilization on java leading to 504 gateway timeouts.I've tried changing AcceptFilter http and AcceptFilter https to none. I've tried uninstalling FusionReactor 7.2.4I've noticed here:https://helpx.adobe.com/pdf/coldfusion2016-support-matrix.pdf that Ubuntu 16.04.1 isn't listed as supported, but the AWS Marketplace CF2016 image is bundled with it.Anyone have any experience with a similar stack?

I am facing issue for extracting contents from uploading both pdf and word ? i am trying a upload cv and i want to extract the content from there and saved to database.