ColdFusion

I am working on some Date Helper functions where I need to convert UTC dates to unixtimestamps and vice versa. Interestingly I came across an inconsistency using the DateConvert function in cooperation with DateDiff in that the timestamps are different. DateConvert makes the timestamp using local time while DateAdd uses the appropriate UTC Date. I was wondering if this is a bug / anomaly or my misunderstanding how DateConvert works in ColdFusion.The following is syntax to reproduce scenario <cfset unixEpoch = CreateDate(1970,1,1) /> <cfoutput>     <pre>     Local Date:        #Now()# [CORRECT]     UTC Date:          #DateConvert("local2Utc", now())# [CORRECT]     =======================================================     UTC to Unix Timestamp Conversion     ===========================================

I think I put all the information in the ? but here it is again:  "How do I uninstall ColdFusion 10 from my machine.  I have uninstalled the .net service and the jetty service but it will not let me uninstall the coldfusion 10 service with odbc services.  the error is error: loading: c:\coldfusion10\jre\bin\msvcr.dll."

I'd like to be able to run a .CFM file from a DOS Command Prompt window. Is there an EXE that I can use to do that?Thanks.

I have two domains (A and B) hosted on the same server.  I need to query sql db's on one domain from the other domain.I thought it should be as easy as this, but it's not finding the db.From Domain A:<CFQUERY datasource="datasource on domain B" DBSERVER="serverurl for domain B" username="username" password="!password">SELECT * FROM table</CFQUERY>Thanks!

I am attempting to take a lot of data from a csv file and import it into a mysql database.My Code <cffile action="read"file="http://website.com/testtmk.csv" variable="datacsv"> <cfloop index="index" list="#datacsv#" delimiters="#chr(10)##chr(13)#"> <cfquery datasource="X" username="Y" password="Z!" name="putproperty">INSERT INTO property   (Property_id, Amenities, Association, Association_Fee, Association_includes, Bath_full, Baths_half, Beds, Building, City, Easement, FloodZone,   Floor, Flooring, Furnished, Inclusion, Tenure, ListPrice, ListSvc, LotFeature, LotSize, Maintenance, MLSID, Neighbourhood, Parking, ParkingTotal,   Permitaddress, PotoCount, PoolFeatures, Postal, PropertyCondition, PropertyType, PublicRemarks, Restrictions, SQFTBuilding`, SQFTGarage`, SQFTLanai,   SQFTRoof, SQFTRoofO, SQFTTotal, State, Status, Stories, StreetName, StreetNumber, StreetSuff, UnitFeatures, UnitNumber, Utilities, View,    Virtu

I have CF v8 and want to get to v11 if possible. Never seen this product so I'm very new. This is going to be a virtual machine and I have access to MS SRV2012 and lower, I'd like to get to Srv2012 STD OR ENT. Current working system is - MS SRV 2003 STD, CF STD v8.0.1.195765, SQL 2005 Express and Autodesk Express Viewer. I want to get this system to the latest if at all possible. What I have to date - I found a login dashboard for CF administration but have no password for login. I have some questions to start me in any direction.:1) License of CF installation to server. The server software may have differing types of license structures based on use. I'm hoping that because we're using CF STD I can stick to that version for 11.2) Client license access. Clients who access the servers site or app may also need different types of licenses. Some will write some will query only.3) Server installation itself:3a) I will create a new server so I assume I'll not have upgrade as an option. I thi

I'm clearly not understanding how to parse my XML file.  I can get the first "child" but I don't know how to get children after that.To get the league name I use the below code which was pulled from a cffile which retrieved the XML doc and that works fine: <cfdump var="#mydoc#">#mydoc.league.xmlattributes.name# = NBAIn the below, what would be the code to get the "home" team "name"?Cheers!My XML:xml document [short version]leagueXmlText  XmlAttributesstructalias NBA id 4353138d-4c22-4396-95d8-5f587d2df25c name NBA xmlnsdaily-scheduleXmlText  XmlAttributesstructdate 2015-12-25 gamesXmlText   gameXmlText   XmlAttributesstructaway_team 583ecc9a-fb46-11e1-82cb-f4ce4684ea4c coverage full home_team 583ecea6-fb46-11e1-82cb-f4ce4684ea4c id b55c5579-950b-4726-8d36-6467f6caa772 scheduled 2015-12-25T17:00:00+00:00 status scheduled venueXmlTextXmlAttributesstructaddress 601 Biscayne Blvd. capacity 19600 city Miami country USA id b67d5f09-28b2-5bc6-9097-af31

My error:Error Executing Database Query.Field 'Association' doesn't have a default value The error occurred in D:/home/manpcs.com/wwwroot/Untitled_cfm.cfm: line 119 : 10 :  VALUES 11 : ('#listgetAt(index,1 )#') 12 : 13 : </cfquery> sqlState  HY000datasource  pcsvendorErrorCode  1364sql   INSERT INTO property (Amenities) VALUES ('"BO1F')My Code: <cffile action="read"file="http://website.com/testtmk.csv" variable="datacsv"> <cfloop index="index" list="#datacsv#" delimiters= "#chr(10)##chr(13)#" > <cfquery datasource="X" username="Y" password="Z" timeout="90">INSERT INTO property   (Amenities) VALUES    ('#listgetAt(index,1 )#')</cfquery> </cfloop> I am pulling from a CSV file.  Some of the data in one cell is seperated by comas, I also seem to be picking up some extra " marks.  Any help is appreciated.

I have a scheduled task registered in ColdFusion 11 Admin console. ColdFusion 11 is hosted over IIS 7.5. The schedule task is to run 1 perticular file from sub application of the main app. After upgrading application from ColdFusion 9 to ColdFusion 11, scheduled task stopped working.Note that, on IIS, main App has "Anonymous Authentication - Disabled" and "Windows Authentication - Enabled" ...While for sub app (which is being called by scheduled task) has "Anonymous Authentication - Enabled" and "Windows Authentication - Disabled".Moreover, when I try to run the scheduled task manually, it shows "Authentication falure" error in log file asHTTP Error 401.2 - Unauthorized You are not authorized to view this page due to invalid authentication headers.Any help would be greatly appriciated.Thank you.

Is there any way to Email an Email Attachment for Cold Fusion to Manipulate.Sort of like <cffile action = "upload"> however user is emailing the file into the Cold Fusion Server.The reason for this:Now we  have an app  that reads data on users smart phones and the user emails the file to themselves.However now we have found in some cases we need to do some basic manipulation that Cold Fusion could easily do to clean up the data.So user would email attachment of data to our server and then server would do clean up and email cleaned file to user.If there is nothing in CF to do this, any other language?Thanks

Where do I even start...Scenario: I am the senior architect of multiple corporate .Net solutions.  Recently I decided to introduce ColdFusion11 to serve as a job server for background tasks (Scheduled ETL, Email Provider, Ad Hoc PDF generation and whatever other tasks we may wish to offload in a separate thread.) While I must admit, I stopped doing ColdFusion development some years ago; however, this does not negate the fact that I was an early adopter of ColdFusion and have well over 10 years of seasoned "in the trenches" experience with the language from the Alliare days, through the Macromedia days and into the Adobe days. Truth is - I have been a huge advocate of ColdFusion and implemented it many large corporations. Having said that -- I figured implementing a ColdFusion stack would be a cinch given my background. Unfortunately, this is not the case. I must say that some of the features I hoped to use (PDF & Web Services) are proving to be a big headache for me and I can'

I'm on section 2.6 and I'm not able to view the cfide/administrator website.

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?