Questions

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. 

Hi all,I have just installed the latest update, which all went fine - however when I try to access the Administrator (which was working perfectly just prior to updating), I get an error which states, "The isAdminClientCertAuthEnabled method was not found."I have searched everywhere and can not find resolution to this error. If anyone can shed some light on how to fix it, it would be greatly appreciated. Thanks..

We are trying to setup our Shibboleth to authenticate logins to adobe.com. Adobe support documentation says to add this to our relying-party but we are running Shibboleth V2 and it does not match this format. Any idea on how to accomplish this in V2? It specifically says add the line:<bean parent="SAML2.SSO" p:nameIDFormatPrecedence="urn:oasis:names:tc:SAML:1.1:nameid-format:emailAddress" p:postAuthenticationFlows="attribute-release" /><bean id="shibboleth.DefaultRelyingParty" parent="RelyingParty">    <property name="profileConfigurations">        <list>            <bean parent="Shibboleth.SSO" p:postAuthenticationFlows="attribute-release" />            <ref bean="SAML1.AttributeQuery" />            <ref bean="SAML1.ArtifactResolution"

Hi All,I am trying to bulk insert 102K records to oracle db. I found this:Data Insert Issue from Coldfusion to Oracle - Stack Overflow But it takes a lot of time.Is there a way to do faster bulk inserts?Thanks in advanced.John

I am baffled by this problem and hope someone can help.  I have a perennial plant website that takes online orders.  For most customers, including me when I place test orders, things work as designed.  However some customers generate errors.When a new customer order comes in I create a customer ID and an order ID:<cfset variables.CustID = #CreateUUID()#><cfset variables.CustOrderID = #CreateUUID()#>I have tried this without the # signs and the result seems to be the same.  In the usual case a Coldfusion UUID is created in the form 8-4-4-16.I write the customer ID to the customer table into an nvarchar(max) column and write both the customer ID and order ID into the order table into nvarchar(max) columns.  I also have an order item detail table into which I write the custOrderID into an nvarchar(max) column.As noted, this works for most customers.However, for some customers - at least one that I am working with - two odd things occur that I can't fig

Hi Folks,Trying to follow the progression on this beta, but this forum layout with the cards is not helpful.  Anything being done to change this to a more traditional forum layout, I'm sure there are some folks at Adobe that can help with basic UIX.Thanks,Phill Nacelli

How can I format the x axis number format with commas ie. 123,443,323,234?  CF 11H