ColdFusion

I need to figure out of a date falls on a holiday...such as memorial / labor day or thanksgiving, easter, etc.these holidays float based on week of months or day of week... I'm sure there is code out there to do thisI'd hate to reinvent the wheelthx

Hello,I have several websites that I'm working on, and each one needs it's own development environment located on my own computer. At the moment my web root is located at: http://127.0.0.1:8500/. The problem is now that I have several subfolders underneath this web root, each one of them representing a separate website. I like referencing my images, stylesheets, javascript, and links as links that are relative the root URL, like this "/images/myimage.jpg". The problem is that now with multiple websites stored on my computer, the links don't point to my subfolders /company1, /company2, etc. Instead they point to the root itself, which doesn't work.I was able to fix this by going into the following file and updating some code:C:\ColdFusion11\cfusion\runtime\conf\server.xmlI uncommented this line of code and added the web root of my choice;<Context path="/" docBase="<cf_home>\wwwroot" WorkDir="<cf_home>\runtime\conf\Catalina\localhost\tmp" ></Context> This works gr

Hello, all,I'm using a hidden iFrame that loads a page using CFCONTENT and CFHEADER to stream an Excel file from a form submit.  I'm _trying_ to use JavaScript to change the value of the button element that submits the form in the parent page. I'm not seeing any success.  Does Javascript still run when a page uses CFCONTENT and CFHEADER? I can't even get a simple JS alert() to work.V/r,^_^

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SAVEPOINT test123' at line 1That's the error I'm getting, when using simple Savepoint syntax, which works in PHP, and navicat, and mysql workbench.ColdFusion:  v9MySQL: v5.5 CommunityEven installed (& tested) MySQL Connector:  v5.38 (latest)It refuses to use that syntax via coldfusion, and it's a response that is processed from mysql server I thought?Stacktrace: base.cfc -> com.mysql.jdbc.StatementImpl.execute -> com.mysql.jdbc.MysqlIO.sendCommand -> com.mysql.jdbc.MysqlIO.checkErrorPacket -> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorExceptio So why would this work everywhere except coldfusion (via or not via jdbc even)? Yes I'm aware that coldfusion has a transaction{} system, however that is block-based (single script run), and I need a session based rollback/commit system (keep connection open, single per user session

Hello, all,I'm working on a form that uses AJaX (jQuery) to submit the form data, after the fields have been serialized.I've done this several times, and never had a problem.. until this.  I've compared this code to the code that is working elsewhere, and I'm just not seeing any differences that could cause my issue.Here is some pseudo-code: <form name="peopleSave" id="peopleSave" method="post">     <input type="text" name="firstName" id="firstName" value="" />  First Name     <br /><input type="text" name="lastName" id="lastName" value="" />  Last Name     <br /><input type="button" name="submitBtn" id="submitBtn" value="Submit" class="sbmt" /> </form> Here is actual code: <script type="text/javascript" src="/scripts/jquery/jquery.min.js"></script> <script type="text/javascript" src="/scripts/jquery/jquery-ui.js"></script> <script type="text/javascript"&

I ran into a problem with my ColdFusion 11 64-bit installation/migration on a Windows Server 2012 R2/IIS 8.5.  I was following the ColdFusion 11 Lockdown Guide - Pete Freitag (very helpful) and I ran into problems on page 35 "Run the ColdFusion Web Server Configuration Tool".  When I attempted to do this for ALL IIS websites I encountered a Windows error [APPCRASH - Exception Code:c0000005].  Also, note my Administrator-Command Prompt window provided this error message "Error while configuring connector for IIS. Make sure you have administrator privileges".  However, I did not experience this error with all of the migrated sites.  I traced my steps backward to discover the problem.  I used the Microsoft Web Deployment tool (good tool) to migrate the old IIS websites to the new IIS.  I utilized Metabase Explorer the IIS 6.0 Resource Tools to discover that some of the migrated sites that were crashing did not have the key/value ID:6006 | Name: DefaultDo

CodeBelow is the script, the queries in the thread only use the variables on the cfthread call. The process works about 80% of the time and then I receive Java.util.concurrentmodificationexception on one of the threads, occasionally more than one.  Using CF 9,0,0,251028, but have tested with 9,0,2,282541 with the same issue.Any hekp is appreciated<cfquery name = "variables.Dts" datasource="#mydsn#">select  to_char(next_day(to_date('#selDate#','mm/dd/yyyy')-56,'sat')+(level-1)*7-2,'mm/dd/yyyy') as thu,to_char(next_day(to_date('#selDate#','mm/dd/yyyy')-56,'sat')+(level-1)*7-1,'mm/dd/yyyy') as fri,to_char(next_day(to_date('#selDate#','mm/dd/yyyy')-56,'sat')+(level-1)*7,'mm/dd/yyyy') as satfrom dualconnect by  level <  9</cfquery><!--- test ---><cfset qtr = 0><cfset tname = ''><cfloop query="variables.dts" ><cfset qtr += 1><cfthread name="t#qtr#" action="run" sat2='#variables.dts.sat#' thu2='#variables.dts.thu#' selarea2='

Hi,this has probably been asked many many times but i cant seem to find a solution.Environment: CF11 CFH6 (but admin says its not installed..)Windows server 2012 R216GB RamIntel Xeon E3 3.1Ghz 64bitIssue: All cache features in CF admin are disabled.I dont like this but my issue is concerning the cache.I have a custom CMS, the content is served via the VFS (ram://) drive, its stored in a DB and if the file does not exist we create it in the VFS and its included into the index.cfm.anyway, when a change is made to this type of content, the changes are not visible. I can restart the application which clears out the VFS, i can add white space to the end of the file and a few other tricks to trick CF into thinking the file has changes so that it will reload it but nothing works.The only way to fix is to log into the CF admin console and click the clear template cache button. Again the Trusted Cache is disabled.This is the first issue.The second is when i attempt to call the admin API to clea

Hi everyone,Ive got a very strange issue with my AWS Instance of CF 11. Its using the AMI provided on Amazon and has had nothing but problems since I subscribed to it. It all started with it being provisioned with a developer license and being charged for enterprise by mistake.Anyhow, my issue is rather strange in that I have an M3 Large instance, with an application Ive had running quite successfully using Hostek. No real major issues to report whilst hosting with Hostek, but the only difference is the Hostek instance is a single instance with MSSQL and CF10 all on the one box.With my AWS instance, I have CF 11, and MSSQL via an RDS. Everytime I run a page with a few queries on it, the CPU within the Task manager spikes up to 90 - 100%. I run the exact same page via my Hostek account or via my local vmWare development environment and I get 3%.The main difference here is that SQL is served via RDS and I cant seem to find any reason why my production machine cant handle any thing.The CP

I updated a test server from ColdFusion 10 to ColdFusion 11 30 days Enterprise trail edition with update 7.However, every time I hit refresh in my browsers, I get a new cfid. As a result, a valid session is not found so the login page doesn't work.I checked the session in coldfusion admin page and my cookie in my browsers, they are both created correctly.This is what I have in my application.cfm<CFAPPLICATION NAME="TESTWEB"  CLIENTMANAGEMENT="Yes"  SETCLIENTCOOKIES="Yes"  SESSIONMANAGEMENT="Yes"  SESSIONTIMEOUT = "#CreateTimeSpan(7,0,0,0)#"  SETDOMAINCOOKIES = "No">However, when I open the page from the host computer, then the cfid doesn't get change everytime I hit refresh, so everything works.During login, I had code that set cfid/cftoken to cookie, but since I changed to SETCLIENTCOOKIES="Yes", I removed those code. The only other place would be in logout.I am not using jsessionids, only coldFusion session id.Timeout for all session variables is 7 days

This is really strange.I got a message from xssposed.org that my website is vulnerable to cross site scripting. They gave me a url that a specially crafted url variable could cause a pop up alert on my website.I narrowed it down to cfparam.Create a file that just has:<cfparam name="video" default="1" type="integer">Name the file test.cfmUpload it and go to your website:  xxxxx.com/test.cfm?video=%22%3E%3Csvg/onload=prompt(/XSS/)%3EIt is seen best using firefox.This website is running an old version of coldfusion  8.01  (It is for a small cancer charity that can't afford to upgrade). I also maintain a few websites on a server that is running coldfusion 10 enterprise, so I tried it there also and the same thing happens.If I replace type = "integer" with type - "any" it doesn't happen.  Does this happen on the current version of coldfusion?  The admin option for "enable global script protect" is enabled

Anyone successfully installed CF11 (or any other version) on a Windows 10 machine?I installed IIS, ISAPI Extensions, ASP.NET, and CGI.  The CF11 installer seemed to run well, and got to the point where it would normally launch CF Admin and came up with a 404 error.  I ran the Web Server Configuration Tool, and it pops up a warning box that says "Version 10.0 installed. Supported versions are 4.x, 5.x, 6.x, 7.x, 8.x" after I chose all IIS sites. Also, there isn't a numbered folder under c:\ColdFusion11\config\wsconfig\ like there should be, so there are no Handler Mappings for CF file extensions in IIS.You'd think Adobe would be all over this as many developers will be switching to Windows 10 soon.

I am trying to connect to an FTP server using port 990 (FTP using SSL).  From what I can tell, cfftp does not support FTPS - it only supports SFTP.  We have been doing using ftp4j and this has worked for us in the past.  See ColdFusion and FTP over implicit TLS/SSL :: Aliaspooryorik Musings.However, the client has installed a new ftp server, and we can no longer drop more than a zero byte file.  In a manual test using FireFTP, we get the same error of "TLS session of data connection has not resumed or the session does not match the control connection".  A test using Filezilla client works however.  From what I can tell, this is because of needing to enforce TLS session resumption and the Filezilla client does this..Has anyone dealt with and solved this in Coldfusion?

I'm trying to install Coldfusion 11 on Windows 10 (64 bit) and I'm getting "Access Denied" in Akamai Download Manager. Is there a way for me to directly download it?

An exception occurred when instantiating a COM object.The cause of this exception was that: AutomationException: 0x80040154 - Class not registered.I get this error when trying to use an old 32bit  .dll.My company has moved from CFMX on Win 2003 to CF10 (64Bit) on Win2008 R2 (64bit). Is there something I can do to get this to work? The .dll has been registered in windows.

I am running ColdFusion 11, and the relevant website works well. However, whenever I apply available update 5, it breaks the website. The error message I receive is the following.Detailed Error Information:Module                     IsapiModuleNotification               ExecuteRequestHandlerHandler                    ISAPI-dllError Code               0x00000000Requested URL       https://website:443/jakarta/isapi_redirect.dllPhysical Path           D:\Programs\ColdFusion11\config\wsconfig\1\isapi_redirect.dllLogon Method          Anon

Hi All,I have a field value that can be stored with many values for a single record: Work_Order = '555555,666666,111111' (note, these are actually stored as a single string value in the db with commas .)I need to parse this field and enter the string values into the where clause of a new query:<CFSET WOIDS = CapProjects.Work_Order> <cfloop condition="#find(',,',WOIDS)#"> <cfset WOIDS = "#rereplace(WOIDS,',,',',null,','ALL')#"><br> </cfloop>  <cfquery name="CapProjectsWOIDS" datasource="#URL.DB#">  SELECT [ENGOPSMTRLSID]      ,[Work_Order]  FROM ENGOPSMTRLS  WHERE<CFOUTPUT>  ENGOPSMTRLSID = #URL.INDEX#</CFOUTPUT>AND<CFOUTPUT>  Work_Order in  (<cfloop index="idx" list="#variables.WOIDS#">        <cfqueryparam                     &nbsp

I'm just starting with Webtrends and have a task to show Webtrends data in a web page portal. What I envision is a HTML div with graphs. Of course, my site is ColdFusion based. Does anyone have suggestions or guidance on how to accomplish this? We're currently running Webtrends version 8.7, but are preparing to upgrade to version 10.

I have just had to rebuild my server and I am trying to get coldfusion reconfigured and I did not configure it the first time.  I have loaded coldfusion 10 on the c:/drive and all my data is on the d:/drive and I cannot get coldfusion to see the data.  What do I need to do?

Postgres doesn't have the USE directive, unlike SQL Server or MySQL. There is the \c <database> command, but that only works in the psql REPL. Is there an alternative to USE that can be used with cfquery in Postgres? We would be using this with CF 11.

I have already made the necessary changes to the RDSServlet settings in web.xml.  This happens on every browser and it doesn't matter if I'm local or remote.

Hello, all,I've got a query flattened into a JSON string.  The query does contain double-quotes in some of the data, so I try to strip that out.  I'm replacing " with "HOWEVER, the action page is using regex replacement to convert back to ", but it isn't completely working.I've tried the following with ReplaceNoCase() and REReplaceNoCase() - neither is working.<cfset form.XLJson = ReplaceNoCase(form.XLJson,'"','"','ALL') />The above code will take:Smith, John "Johnny"turn it into Smith, John "Johnny"BUT, what it changes back to isSmith, John ";Johnny";Am I missing something, here?V/r,^_^

Hello, all,I've got a few pages that I'm working on where, after the page loads, I use Javascript to dynamically create a form, then use CF to convert a query object to JSON, insert that into the form, and submit it (as opposed to running the same query twice), and the action page will DeserializeJSON()  to generate an Excel spreadsheet from the query.These pages are all working flawlessly.Now, I'm trying to do the same thing, except insead of using CF to convert a query into JSON, I'm creating a Javascript JSON of the data to pass to the form.  But when the page submits, DeserializeJSON() isn't working, even though I'm using the same format that CF uses.I'm getting the following error:JSON parsing failure: Expected ',' or ']' at character 60721:'M' in ... (JSON string)Well, at almost 100,000 characters, I'm having trouble finding that position (Word is useless for this), so can't view the issue directly.  However, I'm wondering if anyone knows a way to take a Javascript

The first time I installed CB3, it works fine. My workspace is under wwwroot. When I run the project, it runs in HTML.I have to reinstall CB3 per recommendation from Adobe after I had trouble create CFC using Extension.After I reinstalled the CB3, the page cannot be loaded in HTML. Instead it returns in Notepad with error message:The filename, directory name or volume label syntax is incorrect.Please help.Thank you.Shen