ColdFusion

   Solved a problem today that I doubt Adobe will patch in cf10, so here you go.System Specs :Windows Server 2008 R2Coldfusion 10 10,0,23,302580Java 1.8.0_74 Symptom (from the exception.log): java.lang.NoSuchMethodError: org.openxmlformats.schemas.wordprocessingml.x2006.main.CTFFData.getCheckBoxList()Ljava/util/List;at org.apache.poi.xwpf.usermodel.XWPFRun.text(XWPFRun.java:1001)at org.apache.poi.xwpf.usermodel.XWPFRun.toString(XWPFRun.java:971)at org.apache.poi.xwpf.usermodel.XWPFParagraph.getText(XWPFParagraph.java:215)at org.apache.poi.xwpf.usermodel.XWPFTable.<init>(XWPFTable.java:117)at org.apache.poi.xwpf.usermodel.XWPFDocument.onDocumentRead(XWPFDocument.java:152)at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:166)at org.apache.poi.xwpf.usermodel.XWPFDocument.<init>(XWPFDocument.java:118)at org.apache.poi.xwpf.extractor.XWPFWordExtractor.<init>(XWPFWordExtractor.java:59)at coldfusion.tagext.search.MSDocument.readDocx(MSDocument.java:164)at c

We applied the APSB14-23_FIX, which contains the hf902-00007.jar, and appears to be the latest CF9.0.2 update from Adobe.The CF server runs with that update under Java 1.7.0_55, but when we try to repoint to using Java 1.7.0_151, we get the Client Storage error, and even though the server does start, any request fails due to lack of availability of client scope variables.Our Version: 9,0,2,282541 Server.log:"Information","main","08/28/17","08:41:52",,"Starting client..." "Error","main","08/28/17","08:41:53",,"Unable to initialize Client Storage service:java.lang.ExceptionInInitializerError"My suspicion is that CF9 is not compatible with the java 155 release, but since it is in the '1.7. series, that ought not to be the case.Has anyone else seen this error, and were they able to resolve it?Thanks,Ian[Moved from the non-technical Lounge Forum to the specific Program forum... Mod][Here is the list of all Adobe forums... https://forums.adobe.com/welcome]

I have a cfselect and when a user selects Vendor from the list, a div displays showing a company field to enter the company name. I am trying to get to the logic that checks if Vendor is selected, make the company field required`. Here is what i got so far. When I fill out the form and choose vendor the div with the company field displays but I cannot make it requiredThank you!<cfif form1.county EQ 'Vendor'>                                                          <cfinput type="text" name="company" id="company" width="190" message="Please enter your company name." required="yes" >                    

Hi, I have a simple function that searches for a user (see below). using cfscript. cf2016 QryGetUser = Queryexecute("SELECT tblUsers.ID,tblUsers.OrganisaztionID,tblUsers.Username,tblUsers.Password,tblUsers.AccessLevelFROM tblUserswhere tblUsers.Username=?", [username],{datasource="myds"});I want to have the “username” parameter in the WHERE optional.So traditionally I have:Wrapped the where clause in IF statements to check if a Parameter isdefined.e.g.Where 1=1ANDIf(isdefined(“parameter2”){AND field2=parameter2}So this works just fine but gets a little cumbersome and hard to read,however with optional parameters I figure I am going to have to build my SQLstatement dynamically in any case. I have several parts to this question:1 – Is there a cleaner solution apart from building the SQL string2 – Would it be bad practice to pass the whole built SQL string as aparameter to this function, the entire select statement being built outside ofthe function3- Depending on the above answers would

I'm trying to test the first sample from here ColdFusion Help | Using the cfprogressbar tagwhere cfprogressbar ... bind="cfc:pbar.getProgessData()" and the backyard code in pb.cfcThere are plenty more similar samples out there to run cfprogressbar with cfc callback bind since CF9 or so but I get all the same results.I'm running it on ColdFusion 2016 Update 4 and it only runs once from 0% to 10%. Only one step. Tested with both IE and Chrome with F12 debugger.In the browser debugger I see pbar.cfc?method=getProgessData& ... calls every one second as it should but the response is always the same like {"MESSAGE":"10%","STATUS":0.1}How can fix it, any ideas, please?UPDATE: It works only via http://localhost or https://localhostStuck via http://127.0.0.1 or https://127.0.0.1 or direct public available IP address or any domain name to that computer

Hello, all,I've got a query that is giving me fits.I'm trying to bring some code that my boss recently wrote into the 21st century.  One section that he wrote, he is using three queries to get base information, looping through one of the queries and running a query within that loop.  I hate this.  Every time I see code that runs a query within a loop, it makes my teeth itch.  So, I'm trying to run a single query using LEFT OUTER JOIN.I've got it working, but for one thing.  I am trying to get our Oracle db to aggregate some data into a string using LISTAGG(), and that is causing this query to take 14 seconds to get the data (the way my boss wrote the code, it's almost instant.)  Of the two tables involved, one has ~2000 records, the other ~4000, and the query is retrieving 23.  If I take out the LISTAGG() portion, the query is almost instant.I was hoping to get the db to do more of the heavy lifting.  Is there anything faster than LISTAGG() for a

Hello, all,I recently ran across CFOBJECTCACHE, which has a single attribute with a single option, action="clear".  This was introduced in CF5.I haven't used it, yet, but it looks like I might have a reason to, soon.  But I am wondering if Adobe (or even Lucee) is planning on modifying it so that one can clear a specific query (as opposed to all cached queries within an application)?  Seems to me that if one has a site/app that has many (say, 30 or more) cached queries that this could put a huge strain on the CF Server due to all queries being re-run after this tag is used.I know that this isn't a forum that is staffed by Adobe employees, but occasionally an Adobe employee does peruse, here.  What say you, Adobe?V/r,^ _ ^

I develop systems for both Windows and IOS devices. Would "select" form fields to appear as a "spinning wheel" on IOS devices, and "normally" on Windows systems.Found this online, Spinning wheel on webkit for iPhone/iPod touch – Page 11 – Matteo Spinelli's Cubiq.org -- but wondered if there's anything else available as jQuery or ??

Hi,We are running an application on a hosted CF11 server that uses the cfspreadsheet tag for one of the pages.Until a few days ago that tag was working without any problems, but now any pages that are using cfspreadsheet don't return anything to the browser.The browser hangs until ~5 minutes later it shows a "the server did not return any page" error message (different message in different browsers). I get the same results when I run it with my xls testfile with 2 lines of data and ~20 columns, that ran many times without any problems, and still runs fine on my development server.I did not find anything online about this issue, but as far as I know CF is using the Apache POI library for the cfspreadsheet tag.The hosting company did restart the server for us but that did not fix the issue. My guess at the moment is that they have installed some security update on the Windows server that messed up how that POI library is used and now it just hangs when it is called by CF and CF doesn't c

I'm trying to adjust the neo-security.xml file on my CF9 instance to trap cross site scripting things like:myurl.cfm/?'==alert(22)=='myurl.cfm/?'++alert(22)'I modified the xml like this but it seems I haven't gotten the regular expression right.    <data>    <struct type="coldfusion.server.ConfigMap">      <var name="admin.userid.root">        <string>admin</string>      </var>      <var name="rds.security.enabled">        <boolean value="true" />      </var>      <var name="admin.userid.required">        <boolean value="false" />      </var>      <var name="contexts">       

After Upgrading to CF11 Update 12 CFGRID functionality is not working. I am getting an Undefined exception when I try to access CFGRID object from an AJAX call.This issue is fixed in CF-4198947. It is fixed by replacing a Jar and Js file. But these files are not shared in the ticket. Can some one help me in getting those files.

I have a query result set as given below.I want to display details from this query in a pattern of name1 amount1  unit1,name2 amount2 unit2,name3 amount3 unit3,name4 amount4 unit 4 and that too in RTL (Right To Left) direction since data from the query is Arabic.For example : please see the screen shot of pdf file.Issue:Order of Arabic text is not correct as expected as given in the above screenshot. Below is the code snippet I used to generate pdf but order of display is wrong.    <cfset local.qBuckets = QueryNew("amount,name,unit","varchar,varchar,varchar") />    <cfset Queryaddrow(local.qBuckets,4)>    <cfset x=1>    <cfset Querysetcell(local.qBuckets,'amount','غير محدودة',x)>    <cfset Querysetcell(local.qBuckets,'name','لبيانات المحلية والعالمية',x)>    <cfset Querysetcell(local.qBuckets,'unit','جيجابايت',x)>    <cfset y=2> &n

I am looking at the API manager to provide both public (as in free) and licensed (as in paid access) to our API's.  The difference is that the public API's would be throttled and the licensed accounts would have unlimited, or un-throttled, access. In setting up and testing a public API, I set the authentication type to none (since existing users of our API do not currently specify something akin to an api_key).  I can access the API through the API manager (localhost:9100/......) but it does not throttle.  I have even set the UNLIMITED SLA to 1 request/minute but I still get unlimited access to the API from a browser.  However, if I use an authentication type of apiKey, and add an api_key to a query, I get throttled access even using the UNLIMITED SLA which is set to 1 request/minute.  So I know the SLA and hence throttling, work.  However, I cannot find a way to throttle public API's (those with an authentication type of 'none'). To complicate matters, I

Hi,We got this notice from CyberSource:I assume this means we have to limit outbound CFHTTP calls as TLS 1.2Can someone provide information on:1. How we can configure this2. How we can actually test this, like using a script to output which version of TLS we are connecting with?Thanks!Dear Valued Merchant,As previously announced, CyberSource is moving to eliminate support of Data Encryption Standard (also known as "3DES" or "Triple DES") security ciphers for securing browser based as well as server-to-server communication channels.All merchants opening secure browser-based connections to CyberSource web portals and/or server-to-server connections to our transaction processing endpoints will need to ensure that they are not using DES-based ciphers to establish the necessary TLS connections to CyberSource, prior to the termination date, to avoid possible Production impact. Note:  These ciphers have already been disabled in our CAS, or Sandbox, environment so you may test connections

Now that CF is certifified for JDK 1.7, I installed the latest update from Adobe and installed JDK 1.7.  However, ColdFusion 9.01 with Hotfix 3 on Windows 2008 will not start.This is the error in couldfusion-out.logError loading: C:\Program Files\Java\jdk1.7.0\jre\bin\server\jvm.dllI confirmed that the jvm.dll file is there.  When I change the jvm.config file to point back to the original Java path, it starts fine.Anyone else run into this?

Hello, all,I was just wondering if there is a native lookahead when using the GROUP attribute of CFOUTPUT to determine things like how many records are in the group?For example, let's say I had a query like so:CATEGORY                      SPEC                 ROLECAT I                         SPEC I               ROLE ICAT I                         SPEC I               ROLE IICAT I        &n

I have been working with the API Manager, locally on Windows, and find a number of issues/bugs.When importing a working REST API configured in ColdFusion, it builds the resources but a save fails with an error box (red in the lower right hand corner) that SHOULD contain error text but is empty. (I deleted one of the API's and it saved (the API was similar to another but not identical - I don't know why it thought they were the same, CF allows me to register and run both). One is /Service/club/{ClubID} and the other is /Service/club/{ClubID}-{Account}.  These both work in CF but I cannot have both in the API managerAlso, when trying to test the saved API using basicAuth, I get a 500 server error.  A look in the logs shows an exception that I cannot find information on anywhere.  The entire trace is shown below. The API's work fine when using authentication of none or apiKeySo, I guess the questions are:1. Why do I receive an empty error box (red box with an icon on the le

I have this code that outputs select lists of months and select lists of the dates (1-31)The form loads OK and the months and dates are in the lists just fine.But when I select a month and a date I want it to stay selected when I submit the formSo if I choose May 5 and click submitI want it to look like thisBut no matter what I select it always ends up January and 1Here is the code<tr>            <th>Choose  Feed Date:</th>            <th align="left"> <select name="feed_date_m">                <cfloop index="m" from=1 to=12>                  <option value="#m#" <cfif #form.feed_date_m# is "m">selected</cfif>>#monthasstring(m)#  </option>  &

I have a small client (just 2 users) that need a CF web app deployed in house.they don't need any features other than queries and the express edition fits the need perfectly.the license information is unclear but I feel it's perfectly acceptable to deploy express edition if it meets my requirements, license free?if they require more features or users later then they could opt to purchase std. Version

Hi,For some reason the datefield (picker) wont work on my local OSX CF2016.It just displays a text box and a missing image where the picker icon should be to the right.?

     I have  a issue about Coldfusion Builder 3 on my laptop Dell XPS 15 -4k screen resolution (op. system : windows 10). When i open Cold. Builder icons and fonts very small and not resizable :/. Do you have any expreriences about that issue, my eclipse has issue too.. Can you help me please ?SS: thanks.

Hello, all,I'm trying to convert a project so that the components folder is outside of the webroot.  For the most part, this has been a smooth transition.Until (dun dun dunnnnnnnn) I get to the parts where I am using AJaX to submit forms.  When the component was in the webroot, it was very simple, very straightforward.  Now that the components exist outside the webroot, cfajaxproxy is giving me fits.If all I'm submitting is a single form field value, it works.  If I'm submitting an entire form using jQuery.serializeArray(), suddenly there's a problem.postData = $('#'+formID).serializeArray();thisComponent = new ERC(); //Component is in F:\webdocs\_com\public\ERC.cfc and components are mapped in application.cfcthisComponent.setHTTPmethod('POST');thisComponent.setCallbackHandler(displayResult);thisComponent.setErrorHandler(displayFail);thisComponent.dtsSurvey(postData); // Submit the form to the function "dtsSurvey" in ERC.cfcThis results in the error message mentione

Hello, all,I'm trying to set up our projects so that the components folder will not be inside webroot, primarily due to bots attempting to spider our site and generating error emails every time they get to our components folder.One thing that I've noticed (and it makes sense) is that application variables are not available to the components when the components are not in webroot.  For example, I have a CFTRY/CFCATCH set up in a function that will email the error information to us.  The "to" attribute is set to "application.errorEmail" which is set to my email address in application.cfc, but the components outside webroot can't get application.errorEmail.Will I have to manually set application variables in the components in order to keep them out of webroot?  Or is there a simpler way to get the application variables to the components?V/r,^ _ ^

I have a word docx named coded_word.doc that is coded (written)  like this%COURTESY_TITLE% %FIRST_NAME% , %LAST_NAME%Dear %COURTESY_TITLE% %LAST_NAME%,------------------------------------------------------------------------------------------------------------------------------------------------------------------------I have cf code like this<!---Read the file---><cfset mydoc= FileRead("#GetDirectoryFromPath(GetCurrentTemplatePath())#coded_word.docx") /> <!---Replace the coded variables in he word doc withthese values. These ultimately will be from a query result---><cfset mydoc= Replace(rtf,"%COURTESY_TITLE%","Mr.") /><cfset mydoc= Replace(rtf,"%FIRST_NAME%","Charles") /><cfset mydoc= Replace(rtf,"%LAST_NAME%","Jones") /><!---Then download the modified file---><CFHEADER NAME="content-disposition" VALUE="attachment; filename=mydoc_updated.doc"><cfcontent type="application/vnd.ms-word" file="#GetDirectoryFromPath(GetCurrentTemplateP

The pie chart below was created in ColdFusion v11 with the following javascript:{"graphset":[  {  "border-width":1,   "background-color":"transparent",  "foreground-color":"black",  "plot":{  "value-box":{"color":"black"},  "border-color":"black",  "tooltip-text":"%t\n%v"  },  "plotarea":{  "margin":"dynamic"  },  "legend":{  "border-color":"red",  "layout":"2x",  "x":10,  "y":30,  "shadow":true,  "height":"40px"  }  }  ]}in v2016 the JS does not work at all and received an error:SyntaxError: unterminated string literal (zingchart-rhino.min.js#8(eval)#1) The specific sequence of files included or processed is: C:\websites\HazTrak\html\HazPortal.cfm, line: 1if I take out the javascript the pie chart looks like:I either need a fixed so that v2016 will work with the same JS or an xml file to do the same as the js did.