ColdFusion

I have the following working page but not sure how to add in a DateTimeFormat function?Here is my current page and what I tried, but get error: Variable DATETIMEFORMAT is undefined.Here is the online link to image: http://screencast.com/t/MKYrH1Lkp

All,  Just did a fresh install of ColdFusion 11 on a brand new instance of Windows Server 2012 Standard, 64 bit.  Attempting to add a site, and getting an IIS error 404 2 1260, which is the sub_code for "ERROR_ACCESS_DISABLED_BY_POLICY"  I have ensured that the user account connecting to the app from ColdFusion has the requisite permissions to the filesystem.  Any insight or tips would be appreciated.Thanks,AJ

Where is the new license price for ColdFusion-11-Standard on Adobe's CF11 page? Adobe ColdFusion 11 FamilyI couldn't find it anywhere on Abobe's sites. I chatted with sales support and they sent me to the link above. I believe it's $1,499, but you should fix this unless there is some compelling reason to hide this price from the public.

Hi guys, I have a form page/processing page that takes data from a form and then inserts into a database/prints to a PDF via CFDOCUMENT with this on a submit button:<cfinput type="submit" name="submit" value="PRINT" formtarget="_blank" onclick="submitFormOkay = true;">It opens the generated PDF properly into the new  tab as expected.My problem is, I can't seem to automatically reload the original tab/page...which has code on it that clears the session variables the form and gets it ready for the next entry.How can I launch this CFDOCUMENT in a new tab, and also refresh the original tab simultaneously?One note: The form page and processing page are the same, separated by IF/THEN's for program flow.Thanks in advance!T

I have two tables of events that I want to join in a query, schoolCal and newSchedules. Both have schedID and event. I would like them to order by the eventDate. My code is:<cfquery name="getevent" Datasource="#application.dsn#">select schoolCal.eventDate, schoolCal.date_end, schoolCal.event, newSchedules.eventDate, newSchedules.eventfrom schoolCal,newScheduleswhere schoolCal.schedID = newSchedules.schedIDorder by eventDate</cfquery>Two problems, the largest problem the newSchedules table is not showing up in the output and I get an error when I try to order by eventDateHow do I get both tables to show and how do I get the cfquery  to order by eventDate? 

Hi, every one.Nowadays, I have some works with Adobe FLEX Builder 2.0.I have downloaded the FLEX builder 2.0.1 and installed.After that, I have to install ColdFusion extensions for Flex Builder 2.0.It needs that the ColdFusion MX 7.0.2 should be installed.I tried googling and downloaded ColdFusion MX 7.0.0 and installed.But I can not find CFMX 7.0.2 installer.Could anyone please help me ??????????????Thanks for your reading.Regards.

Migrating from ColdFusion MX7 to ColdFusion 10 running on Server 2012. Scheduled task that work on older server are not working on new server. At the end of schedule task they write to an output file and all I get is Connection Failure.Through googling I found where you need to import certificate to keystore and I did all that but still get error.What am I missing?Thank you in advance,Leslie

So I realize that the new CF11 mobile features have been received with some very mixed reviews, but I wanted to try them out to see if I could use them for some really simple device detection, however I cannot get anything to actually work.For example, I am looking at the doc for cfclientsettings, specifically at the first example on the page under the "Device detection" heading. Here's the code for reference (I formatted it a little to ensure it's easy to read here):<cfClientSettings detectDevice=true />  <cfclient><cffunction access="public" name="showCanvasSupport" returntype="void"> <cfset evalStr = "document.getElementById('canvas').innerHTML='" & cfclient.canvas & "'"></cffunction></cfclient>Canvas support -<b id="canvas"></b><br><button onclick="invokeCFClientFunction('showCanvasSupport',null)">Show canvas support</button>Creating a new .cfm page and adding this code produces the text and button on th

I hope some help is out there. I will post the error message at the end of this post. I can't verify a datasource in Administrator. this is the error:Connection verification failed for data source: DHDataWeb_Dev java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer  JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433.  Reason: Connection refused: connect The root cause was that:  java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC  Driver]Error establishing socket to host and port: 127.0.0.1:1433.  Reason: Connection refused: connectAny help would be greatly appreciated. I know this should be very easy, but I can't get it to work. I am running Windows 7 SP1, My SQL database, web server (IIS 7) and CF server are all running on the same box.Thanks in advance.....Didger (who is most confused)

Can one use optional argument for a GET REST service?  For example:http://somesite/rest/someservice/{year}/orhttp://somesite/rest/someservice/{year}/{catalognumber}In the first case, it returns all the catalog information given a year.  In the second case, it only returns information for a given year and catalognumber?How may I proceed in accomplishing that?  Thanks in advance.

Can one use optional arguments for a REST web service?  Example:http://somesite/rest/someservice/{year}/ or http://somesite/rest/someservice/{year}/{cataglognumber}whereThe first uri returns all the catalog items given a year andThe second uri only returns the information given a year and a specific catalog numberHow may I go about doing that?  Thanks in advance

Is there any way to clean these javascript files?/cfide/scripts/ajax/yui/animation/animation-min.js /cfide/scripts/ajax/yui/calendar/calendar-min.js /cfide/scripts/ajax/yui/yahoo-dom-event/yahoo-dom-event.jsCVE-2010-4710 : Cross-site scripting (XSS) vulnerability in the addItem method in the Menu widget in YUI before 2.9.0 al…

Hello, all,I've been working for weeks on a form that will (when submit) generate an Excel spreadsheet, then attach said spreadsheet to an email and send it off.Basically, once a form has been submit (and after the form data has been validated, server-side), my code takes the form scope, and uses <cfscript> with SpreadsheetNew, SpreadsheetFormatRows, SpreadsheetFormatColumns, SpreadsheetSetCellValue, etc.,  to generate an Excel object.  Then, I use CFMAILPARAM inside a CFMAIL tag to set the object as an attachment, and place the email in spool.It was working flawlessly, last week (as of Friday, before I left to go home.)  Suddenly, this morning (Monday), it is not working.I have not changed any code.  Our SA has not updated, upgraded, or changed anything - not the physical server, not the Apache server, not the ColdFusion Server.The CF logs are showing one line, each:  "The {log name} log has initialized."  That's it.  Nothing more.Has anyone el

Is there a way to turn off the weekly reports?

I upgraded to CF10 from CF8 and moved my websites over to the new server for testing. The main issue seems to be directory related. I built the applications in dreamweaver using developer toolbox to augment my code writing skills. That said, I can't get the admin pages to render, I only get the 404 or 500 error. The pages are there and the website itself runs correctly i.e. it pulls data and displays correctly. The update pages in the admin directory are the problem. I am curious if CF10 changes how it allows includes or directory structure.Website rootjakartaCFIDEincludesimagesadminmiscindex.cfmAdmin uses files from includes directory.... Works fine in CF8. 'NO GO HERE'Access Data Driver working fine.... Well except that I can't get the update pages to display.I have the virtual directories for jakarta installed in the root also. Any ideas on where to start looking. debugging pages aren't displaying either.

ColdFusion 10 Enterprise server running on Windows Server 2008 R2.Scenario 1:Established new web site and pointed it to the CF site files, setup proper mappings in CFIDE Administrator, everything works perfectly. Scenario 2:Because I need multiple SSL sites on this server, I needed to move the CF site under the Default Web site as an app/VD. Created the site/app and pointed it to the same CF site files in the same folders. Created Virtual directory JAKARTA and pointed it to: C:\ColdFusion10\config\wsconfig\1Accessing site throws 403. Analyzed some logs and traces and it looks as though it is failing on the ISAPI redirect or related file access thereof. Again, same files, same folders, one as website (works), one as Virtual directory/app off Default Web Site (does not work). Both the web site and the app were assigned the same App pool.I provided the necessary permissions to the IIS_IUSRS group on the folders that make up the site, and also the IIS APPPOOL running the site.I then gave t

In the example below, the <cfclient> tags are red, but not for the <cfinclude> tag.<cfclient>  <!--- All cfclient code to creat dynamic HTML and   interface with data access CFC is in the following included file --->  <cfinclude template="index_include.cfm" ></cfclient>Similarly, the <html> tags are blue, but not the <head> tags<html>  <head>  <META HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE">  <meta name="viewport" content="width=device-width, initial-scale=1.0">  <link rel="stylesheet" href="css/jquery.mobile-1.4.2.min.css" ></link>  <script src="js/jquery-2.1.0.min.js" ></script>  <script src="js/app.js"></script>  <script src="js/jquery.mobile-1.4.2.min.js" ></script>  <style >  table th {  text-align:left;  }  </style>  </head></html>

We use the cf binaryencode function to convert a binary file to a base64 string that then is inserted into a coldfusion structure. Then we use the serizlizeJSON function to convert that structure to JSON.When it fails we get this error:JsonParsingError - Failed to decode VALUE_STRING as base64 (MIME-NO-LINEFEEDS): Illegal character 'ﻘ' (code 0xfed8) in base64 content at [Source: java.io.StringReader@192fd063; line: 1, column: 12229]Using the same code and the same file works correctly in CFMX 9.We narrowed down to the serializeJSON function by manually creating the JSON string and bypassing the serializeJSON function completely.Running CF11 Update 5 did not solve this either.Anyone have any ideas on how to remedy this?thanks!- Alex

Following an installation guide from Adobe, I installed ColdFusion 11 Developer Edition on Windows 8.1 that has IIS 8.5 installed. I've all the required features for ColdFusion enabled on IIS 8.5 as shown in this figure.The installation created a virtual directory CFIDE in IIS but it did not create the physical directory the virtual directory points to. In IIS when I click on the virtual directory CFIDE created by the ColdFusion installation (or CF Web Configuration tool), I get the following error:I then re-ran the ColdFusion Web Configuration Tool to first remove the IIS configuration and the add it again. But still the same issue. How can I remedy the issue? Thanks..Nam

     I have a cfchart line chart in ColdFusion 11 which has value has zero for some months (jan to Jul) as shown below :However in the graph value 0 is plotted . I need the graph to start displaying the plotting from where values are greater than 0. the same was working in ColdFusion 7 as shown below(red line):

I am working on a real estate application.   I am having difficulty with the pulling down the information from my MLS Server (Hawaii in case your wondering).I have looked through the site and have played with the different snippets of code that are on different sites and have played with error after error.  Is there anyone out there that can guide me in the right direction?

We regularly have to run webinspect scans on our CF servers.  Recently, we started getting CSRF findings on both our new CF11 servers as well as our one remaining CF9 server.  After doing research, it appears that with CF10 and later, there are tags to remediate this.  My questions are:- is this the only method to remediate?  Are we really going to have to add this token logic to every form that the scan finds, which could be hundreds?- is there not some administrator parameter that can remediate this across the server?Thanks in advance for any assistance...

I have a database table where users have indicated their interests, and I'd like to understand the simplest way to generate a graph of the data.Most of the data in this survey was gathered in the form of checkboxes, and in the database I entered a "1" if they checked the item, or a "0" if they didn't.  So the table might look like this:field          valueapples          1oranges          0pineapples          0bananas          0dogs          1cats          0birds          0The user above only likes apples.(for fruits) and only likes dogs (for pets)Is there a simple way for me to display the results for all users in the database

Hi All,We are creating a query using  <cfset QueryAddrow(qryMasterFile) />At the time to insert the data to oracle db we do:<cftransaction action = "begin">  <cftry>     <cfquery name="deleteMasterFile" datasource="#application.str_dsn#">              DELETE FROM master_file              WHERE my_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.my_id#">     </cfquery>    <cfoutput query = "qryMasterFile">          <cfquery name = "insertData" datasource = "#application.str_dsn#">                               INSERT INTO MASTER_FILE ( list o

The error I receive is "•Invalid extension of the file name. Valid extensions are :log,txt.  I did read that in such instances that I am to work with c:\ColdFusion 11\cfusion\lib\neo-cron.xml.  I would appreciate any insight that can be provided on working with this xml file.