ColdFusion

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; /

Folks, Is there any code review tools available for CF?... (Either Open Source or Commercial).. Your help is greatly appreciated... Regards, David R

When serializing an object with a null or "undefined value" property (at least when it's a date), serializeJson dies trying to format the null date.'' is not a valid date/time format.----------------component displayName="Order" accessors="true" {     property name="orderNumber" type="string"     property name="dateOrdered" type="date"}...var order = new Order();order.setOrderNumber("12345");serializeJson(order);  // BOOM!---------------------In the past, null/undefined values would be excluded from the serialization -- and that's exactly what I want.Is this just the way it is now?! Or is there something else I can do?

Hi experts - I want to create a CFschedule task to run every 30 seconds and was wondering what would happen if a Task tries to fire up while the previous task is still running - does it wait or die or ???[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]

Hello,When I send Coldfusion accentuated, it does not happen because of; ect...Here is an example :<meta http-equiv="Content-Type" content="text/html ; charset = utf-8 "/> <body> <CFOUTPUT> <cfset mesx = "Nous avons collecté le maximum d'informations sur les golfs.<br>Nous n'avons pu, faute d'information et en particulier d'e-mail,… "> mesx : #mesx# </CFOUTPUT>Here's the feedback :Invalid CFML construct found on line 29 at column 67. ColdFusion was looking at the following text:;The CFML compiler was processing:An expression that began on line 29, column 64. The expression might be missing an ending #, for example, #expr instead of #expr#.An expression beginning with \", on line 29, column 23.This message is usually caused by a problem in the expressions structure.A cfset tag beginning on line 29, column 10.The error occurred in \\192.168.0.1\H3637\zennetbuilder.com\Admin\EssaiD.cfm: line 2927 : <TR>28

Hello, all,I've got a virtual network running in VMware Workstation 11 that has two Ubuntu Servers (Trusty Tahr, CLI only) and a Windows 7 client (need the GUI for Workbench.)  It has been running smoothly for over two years.  Until yesterday.I started up my clients, opened a browser to go to the DEV environment, and the site came up fine.  Then I tried to log on to my site.  Error.  Checking the resulting email, it said something about trying to connect three times to the database and giving up.So I checked various logs and came across this in /var/log/mysql/error.log:IP address 'x.x.2.161' could not be resolved: Name or service not knownThis was never a problem in the last two years.  Why now?  And how can the system NOT resolve AN IP ADDRESS????Please advise.V/r,^ _ ^PS ColdFusion 11 running on Ubuntu 14.04.5 LTS on one client; MySQL 5.6.33-0ubuntu0.14.04.1 on another client.

I have a calculation in Report Builder that possibly returns a value that contains a decimal. I need to truncate this value to an integer. "Floor" is not in the mathematical functions. Is there a way in Report Builder to truncate a value?Ex: 9.86 needs to appear as 9 not rounded to 10.

Hello Community!   I recently began working on a POC with CF2016 and was a little shocked to learn that the defacto method of getting to the /CFIDE/administrator was via localhost through SSH Tunneling (Per lockdown pdf).   The out of the box alternative to ssh tunneling was to punch a hole in the firewall for port 8500.  Security be damned!   Both of these methods were unacceptable (seriously adobe!).  Thus began a 2 day deep dive into a flawed Java product.   In stead of boring you with a 14 hour deep dive as to everything that didn't work - here is what did work :PreReqs :RHEL 7 X64 Minimum installColdfusion2016 Enterprise Edition patched to 2016.0.02.299200Tomcat Version 8.0.32.0Java JRE Server 1.8.0_102Firewalld Rule for 8443/tcp allowed from Devops TeamSteps :1. Download latest JRE 8 Server edition to /opt/coldfusion2016/   (Update CF JVM path to match i.e. /opt/coldfusion2016/jdk1.8.0_102/jre/ )2. Download and deploy Un

Can someone please help me if 'ColdFusion Builder' Embedded or Bundled Java?