ColdFusion

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.

I have written a basic page as a Proof of Concept that runs a basic query from a single table.  If I run the page via web browser the page displays the resultset form query but from CLI it fails with the error about the datasource not being found.Do I have to configure something to enable the CLI to be able to read the datasources?If I cannot figure this out, then I will have to switch languages to provide a CLI option for getting data into my system.Thank you for any information you can provide.Greg Howard

Since I began using CFBuilder 3.1 several months ago, there have been four times when CFBuilder just locks up at startup. The "processing" circle spins for a long time and the title bar says "(Not Responding)". The only way I've been able to solve this is to uninstall CFBuilder, delete the .settings, .project, and settings.xml files in all my projects, reinstall, and then recreate each project. Is there another way to go around this problem? Any help is greatly appreciated.

Conundrum - on both my CF 2016 Devlt and Production Servers a SERVER LEVEL CFSchedule Task that I have programatically created intermittently "dies" at midnight.  I have it scheduled to run every 60 seconds, but sometimes it seems to run at 11.59.something and then the CFSchedule "Next Run" date/time is set to a date/time far into the future.  For example, this is what the Scheduled Tasks Server Setting is now showing:Interval 1min 0secLast Run: 8/28/2017 11:59:22PMNext Run: 8/29/2017 6.38.22PM (??????????????????)Repeat: -1Remaining Count: InfiniteCluster: NOHere is the Code to boot off the CFSchedule Task:<cfschedule action = "update" task = "myTaskNameHere" interval = "60"url = "http:/xxx.com.au/sendMessages.cfm" onMisfire = "FIRENOW"onException = "REFIRE"> I am stumped.

we have 2 separate physical servers in a cluster behind a F5 bigip load balancer, with a separate websocket virtual server set up with both nodes.  I can't seem to get a websocket data push to propagate between the two servers.  if i have one node enabled, it works fine, but if i send a wspublish from one server, it doesn't show up on the other server.  any ideas?

I have a MySQL DB with 20 million records. I need to search through it to find certain records.But I don't want the query running so long that it brings down the DB server Long running queries have done this before.Is it possible to write code that says if this query is taking longer than 20 seconds then stop processing and output a messageLike "please try your query again later"

Hey,I'm running ColdFusion Dev 2016.0.03.301771. When I try to add a MySQL 5 Datasource to connect a DB I am getting the following error:Connection verification failed for data source: xxx1_dbnamejava.sql.SQLException: Timed out trying to establish connectionThe root cause was that: java.sql.SQLException: Timed out trying to establish connectionAnyone know how I could fix this? I've tried reconfiguring the webserver configuration but it doesn’t seem to help. Could really use some help getting this setup.Thanks!

What is wrong with this Stored Proc ? It works fine in sqlplus but not with a CF call..I have created a simple Hello proc , and called from CF it works fine...Any help ? Thanks. Attach Code ::::::::::::The CF call :::::::::::::::::: <CFSTOREDPROC DATASOURCE="#FormVector#" PROCEDURE="your_pkg.your_proc" returncode="yes"> <CFPROCPARAM TYPE="IN" CFSQLTYPE="CF_SQL_NUMERIC" VALUE="2" NULL="No"> <CFPROCRESULT NAME="view"> </CFSTOREDPROC> <cfdump var="#view#"> ::::::::::::::The proc:::::::::::: CREATE OR REPLACE PACKAGE your_pkg IS -- Global declaration for ref_cursor TYPE ref_cur_type IS REF CURSOR; PROCEDURE your_proc(in_id IN NUMBER, out_rec OUT ref_cur_type); END your_pkg; / CREATE OR REPLACE PACKAGE BODY your_pkg IS PROCEDURE your_proc(in_id IN NUMBER, out_rec OUT ref_cur_type) IS BEGIN OPEN out_rec FOR SELECT * FROM BPAR WHERE UN = in_id; END your_proc; END your_pkg; /