ColdFusion

I have 4 queries that have a date column. I need to output to a table sorted by date desc.But the dates that need to be sorted are from the 4 queries.Its not a good candidate for  UNION as each query has different columns, like thisQuery 1name - address -city -dateQuery 2col a- col b- DateQuery 3col d col E- DateQuery 4col d -col e- col f   - DateAnysuggestionss?

This is Venkat from Infrastructure Support and we are providing support for our client using Adobe ColdFusion platform. Our Client purchased the Adobe ColdFusion 10.0 Standard license under TLP Licensing Program and the support contract was ended on 24th March, 2014 and we would like to renew the support contract now. Could you please share the quote for renewing Adobe Support Contract  at the earliest and the ColdFusion licensing information as below,

Reason: Cannot complete operation becausee resource no longer exists.Opened a single CFC outside of a project to edit, error above ensued trying to add a bookmark. Same error when file was opened \\foo\bar\baz.cfc or z:\bar\baz.cfc

Greetings all -I'm hoping someone can help explain why this following attempt at binding a CFC is not working:1. I set up a CF Server Mapping to my cfc folder:Logical path = /testcfcPhysical path = E:\ColdFusion8\Components\testcfc2. I set up a virtual directory to my cfc folder:Virtual path: /testcfcPhysical path: E:\ColdFusion8\Components\testcfc3. If I use CFINVOKE to call the CFC, it works as expected.<cfinvoke component="testcfc.testRequests" method="get_Clients" returnvariable="var"><cfinvokeargument name="fiscal_year" value="#year(now())#"></cfinvoke><cfdump var="#var#">4. If I attempt to bind the CFC, I get the error "Error Invoke CFC /testResults.cfc: Not Found"<cfselect name="tstClientID" id="tstClientID" bind="cfc:testcfc.tstRequests.get_Clients('#year(now())#')" bindonload="true" value="client_id" display="client_name" />Debugging the error, I see that CF is attempting to find the CFC in the root directory of the app... it is disregarding the d

I plan to run the following two processes. In order to maintain data consistency I plan to use CFLOCK. I've never use CFLOCK in the past and not sure if this is going to work in maintaining data integrity. Please advise.   <cflock scope = "Session" timeout = "30" type = "Exclusive">                 <cfexecute name="SomeName" arguments ="#PathToFile#  #PathToLogfile#" errorFile="#PathToErrorFileLog#" outputFile="#PathToOutPutFileLog#"             timeout="300></cfexecute>                    <cfquery name="UpdateUserID">              Update TempTable              SET UserID = '#session.userid#'  

Hey Guys,We just had a PCI scan on one of our servers, and the following issue was returned:J2EE Misconfiguration: Insufficient Session ID LengthMy understanding is that the Session ID length is set in the underlying JVM for CF.Is there any solution to this?ThanksSteve

I saw a post about this a few years ago, but never an answer.We have some very old forms that use the hidden field type of server side validation to check required fields (_required).  The same forms on ColdFusion 10 return a correctly formatted validation error page.  The form under CF11 returns a page that shows the html tags.The form contains hidden fields like this: <input type="hidden" name="From_required" value="Name of person submitting request is required.">When a form is submitted with an empty field the page displayed looks like this: Form entries are incomplete or invalid.    <ul><li>Name of person submitting request is required. </li></ul> Go <a href="javascript:history.back()">back</a> and correct the problem. I know using this type of validation isn't good, but we need to get them over to CF11 as is for now.  I tried changing the form to a cfform, but got the same results.  I also changed the _requir

During install of CF11, the Web Configuration Tool does not create a "CFML" handler in IIS 7.5 for the main web site. Specifics: 1. Uninstalled CF10. 2. Installed CF11. 3. Got websites functional. Default web page set to "index.cfm". 4. Found main page errors when no page specified. i.e. (https://www.xxx.yyy/) , Error: 404.5 Page not found, cfhandler error. 5. Several attempts of Web config Tool, once for specific web sites and then for ALL web sites. 6. Each attempt left the "CFML" handler out of the configuration for the main site. 7. Finally, running tool for "All", and then in main site "Handler Mappings", click on "Revert to Parent" pops in the missing handler and all works well. 8. Add corrective process to CF11 install procedures.

If I need to get a date & time value for a SQL query for 5:00 PM yesterday, and 5 PM today how do I do thatI want to get all of the records between 5 PM yesterday and 5 PM todayselect *  from MYTABLE            WHERE  BATCH_DATE > (yesterday at 5PM ) AND   BATCH_DATE <  (todayat 5PM)  order by id desc

Is it possible to use TLSv 1.1 on Coldfusion MX 6.1? If so how can I do it?Any help would be appreciated.Thanks,Joe Klovance

I would like to add coding keyboard shortcuts, but can't find a place to add. For instance: I would like to add "cntrl+p" for "<p></p>" tags to match eclipse shortcut.  I see how to edit existing shortcuts, but not how to add.  Help would be appreciated. Thanks.

I have recently upgraded from ColdFusion 9 to ColdFusion 11. However in my websites in IIS the object handlers still point to ColdFusion 9. I during the installation of CF 11 used the wsconfig and there are no error messages in the log files. I can find no documentation on how to point the Object Handlers to Cold Fusion 11. Can anyone help?Thank you in advance!

Greetings,After applying update 12 to CF11 enterprise server, our users reported strange behavior on cfinput   type='datefield' .in Google Chrome. Looks like conflict with Google Chrome type[date] that shows Chrome calendar.No problem with Firefox or IE.Would be nice if Adobe support look into that issue.I checked the page source for cfinput tag type='datefield' in Google ChromeThis is before update 12<div  style="float:left;">   <input name="NewsExpirationDate" id="NewsExpirationDate"  type="datefield" value="04/27/2017" class="datefieldinput DateClass edit"  placeholder="mm/dd/yyyy"  />     </div><div  id="NewsExpirationDateSystemSetupForm_cf_buttondiv" style="float:left;padding:3px;">      <img id="NewsExpirationDateSystemSetupForm_cf_button" src="/CFIDE/scripts/ajax/resources/cf/images/DateChooser.png" alt='Date Picker' />        </

Debugging error output isn't restricted to the IPs specified to receive debugging output in certain cases.This is an issue that has been around since at least ColdFusion 9, as far as I know.Within CFAdmin, we have disabled the global error template (/CFIDE/administrator/templates/secure_profile_error.cfm) in order to enable error debug output for our debugging-enabled IPs.  The problem is that the template that dumps out error information is loaded and processed regardless of whether or not the user's IP is in the debugging IP list.  The "normal" way to get around this, as far as I know, is to specify an error template within your application.  For example, we do something along the lines of:<CFIF NOT isDevIP> <CFERROR TYPE="Exception" TEMPLATE="ErrorTemplate.cfm"> </CFIF>However, this doesn't catch everything.  Exceptions that occur prior to the <CFERROR> tag being processed will still result in all users seeing the debugging error output re

I can´t download Coldfusion 2016 from the Adobe website.I found the right page. I fill out the info form. I select linux 64 version. I press download. A broken link page is displayed.I see someone else posted the same problem 2 months ago but there has been no reply.Any help, please?Bob

My Boss is really pissed off at me. Without knowledge I have advise my boss to purchase ColdFusion Standard License but we really needed ColdFusion Enterprise License.Is there a way we can refund and get ColdFusion Enterprise License?

I'm only posting this because it is not coming up when i search on the text in the subject.I'm using CF 11,0,11,301867  on Server 2012 with IIS 8 for both the web service itself and the web service being called.I'm dumping the error structure in a custom error page and getting this:1. The apps are currently housed on the same server, but were not originally.  both servers have this error2. The following folders give the following users full control: SYSTEM (the user running CF) and Everyone and a spot check of subfolders and files indicates the setting has been inherited.  Essentially these folders are currently world writeable:     C:\coldfusion11\cfusion\stubs     C:\coldfusion11\cfusion\wwwroot     C:\websites\myappfolder (the IIS root folder for the application)3. the service is invoked from a CFC with one function that simply calls the web service and returns the result as follows:<cfinvoke  webserv

Hi, I need help on the function REFindNocase. The project is old and still using CF9 so there is a limitation on what can be use. Each student has a different BookSelectList. Example: it can be NULL (which allows them to see all books), or 1 (which allows them to see only Book A) or 1,2,3 (which allows them to see only Book A, B, C) We have the below: <cfif REFindNocase("(1|2|3|4|5|6)",#Selection.BookSelectList#)>     <cfinclude template="showbooks.cfm"> </cfif> Which works fine until we hit book 10, since 10 consist of "1". REFindNocase will return 1 and display something they are not meant to see. What can I do to avoid that? Can REFindNOcase compare Numbers instead of String? If so, how it can be done? Thanks in advance!

Hello, all,I've got a page where I'm using CFINCLUDE to include another .cfm page that has a list of groups that a user belongs to, and a form field that will allow an admin to add a group to a user's list.  It's a select drop-down with an ADD button.  The admin should be able to add a group to the user's list without refreshing the page, so I'm using AJaX to submit the data to a cfc; the cfc query runs (successfully adding the group), and returns either a 1 for success, or anything else for a fail.If a 1 is returned, I'm trying to use jQuery.load() to refresh the data in the div surrounding the CFINCLUDE.  But the div becomes empty, and even FireBug is showing that the GET from the .load() is returning nothing.Some sample pseudo-code:Parent page (records.cfm):<div id="rec_adminlist"><cfinclude template="rec_adminlist.cfm" /></div><script type="text/javascript">function reloadDiv(divObj,pg){divObj.load(pg);}</script>Child page (rec_adminlist

I have a Windows 2012R2 server running CF 11.  ColdFusion is running as a local service account, and is working properly for all other applications on this web server. I am migrating an old app over from ColdFusion 8 that requires Windows Authentication.  When using Anonymous access, the users can access the app and it works properly.  When I turn on Windows Authentication, users are getting a 401 error.  Event Viewer shows a successful logon (4624).  If they access "file.cfm", they get a 401 error.  If they access "file.txt", they get the contents of the file successfully.  Authentication is successful, apparently, and both files have the same permissions.  When the user is made a local Administrator, he is able to access the file.  Taking away Administrator privileges, we get the 401.  I tried giving that user full control over webroot, over CF.root, over everything I could think of, but no luck.  I tried using ProcMon to point m

I have inherited maintenance of a website created in Cold Fusion back in 2007.  While I can easily make the typical content edits in Dreamweaver, there has recently been a problem with on of the form pages and I know nothing about coding Cold Fusion.When completing and submitting the form this error message is generated:Variable G is undefined. The error occurred in <generated>: line 1Called from C:/inetpub/vhosts/designerbuilders.com/httpdocs/cfc/clients.cfc: line 121Called from C:/inetpub/vhosts/designerbuilders.com/httpdocs/register.cfm: line 246-1 : Unable to display error's location in a CFML template. Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser  Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.133 Safari/537.36Remote Address  24.145.40.29Referrer  http://www.designerbuilders.com/register.cf

Just like the title asks... is there a simple way to download the hotfixes and updates for CF11?I visited the adobe site, click link after link which led to a broken URL for a blog. Isn't there just a list and a download link available? I have to install these settings on the PC that doesn't have the internet connection

We're looking for a few Cold Fusion 9 license keys, if you have some outstanding and would like to sell them, let me know...Thanks everyone,Ryan

It appears that I am going to have to upgrade my installation.I believe the first step is to get a car file from my current installation. The problem is that I keep getting errors when I try to do it. On the "Archive Information" page and try to "Select All" I get the following error;Element VERITY.COLLECTIONS is undefined in REQUEST.Every time I try to change tabs I get a javascript error as follows;Uncaught ReferenceError: setFormValue is not definedThe buildWizard has the same setFormValue error.Is there any way around those errors?Thanks,Joe Klovance

I am using coldfusion 2016 and I am attempting to create a simple bar chart with an arrow above one of the bars in the chart.  I know that coldfusion uses zingcharts for its charting library and I know that zingcharts is able to add arrows  (Chart Arrows | ZingChart ).  Is there a way to accomplish this using cfchart?To further complicate the issue, I would like these charts to appear in a pdf which is generated using cfdocument.  Is this possible?If not, is there an easy way to use a 3rd party charting library (such as d3, chart.js, etc) to generate charts for use in a pdf generated using cfdocument?