ColdFusion

I am testing CFBuilder and when I select to export to sftp there's no option for public key authentication. Is this a bug?

Has anyone attempted to integrate with GP using Cold Fusion?  Just curious before I delve into the documents.

Just using function "week" which gives 2 as week number for monday January 4th which is wrong.According to ISO standard, week number one is the week containing January 4th.Regards,Pierre.

Hi All,I am able to display a pdf file as:<cfpdfform source="#filename#" action="populate" overwrite="yes"/>But it shows this message:"This pdf document contains forms. The filling of form fields is not supported."How can I make the pdf file editable?Thanks !

I am in the process of moving my coldfusion 9 installation two a new server during the process I have found that the CF-9 will no longer connect to the mail server. Could having CF-9 installed on two different server cause the CF-9 not to connect to my mail server?

We run a legacy system and would like to upgrade from CF ver.6.1MX to ver.9 - is this possible?

Hello,"Beginner" in Coldfusion , I made an installation at the request of a third person. Here are the tech. specs of the server :- OS : Windows 2008R2- IIS 7.0- Coldfusion 9.0.1 + hotfix - JRE 7u51According to the documentation, no problem : everything works, I can go to Coldfusion admin page, type password, create instances etc.But... I had to take the document root (wwwroot) of a previous IIS web server (sick !) and then apply the same configurations (other server will be deleted). So I made a backup (wwwroot.bak) following the CF clean installation on the new server. Then import the doc. root of other server (NTFS permissions also replicated) . In this folder "wwwroot", I had a CFIDE directory because CF was also installed on the previous server.I do all IIS configurations and...This is where the problem occurs : I can't access to the CF administration page located in "wwwroot\CFIDE\administrator\index.cfm"=> HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on

I have followed the learncfinaweek pretty good and don't see any errors in my code.   Below is the error, that needs resolved, and the page with the code.  Any help is appreciated.  It should simply be like this: <cfset blogPost.dateposted = importData['Date Posted'] />  , which allows the column in excel to have a space in between the words.Property : dateposted - The value class coldfusion.sql.QueryColumn cannot be converted to a date.Root cause :org.hibernate.HibernateException: Property : dateposted - The value class coldfusion.sql.QueryColumn cannot be converted to a date<cfimport taglib="../../customTags" prefix="ct" /><ct:securityCheck redirectPage="#cgi.script_name#"/><cfparam name="form.submitted" default="0" /><cfparam name="form.importFile" default="" /><cfif form.submitted>    <!--- Upload File--->    <cffile action="upload" destination="#getTempDirectory()#" filefield="impor

I'm trying to add a new mime type on our web server so that FileGetMimeType() will return /application/x-sas-data for a .sas7bdat file.  I've tried both updating the /etc/mime.types and putting AddType into the httpd.conf file and restarted httpd without success.Red Hat Linux 7.2Apache 2.4.6Coldfusion 11Any help would be appreciated.

How do I use <cfindex with different values for docboost for different records.  (ie. I need same to be 5,some with different values for docboost for different record.  (ie. I need some to be 5,some 10, ect).  I can break it up in to multiple calls to <cfindex.  But, If I do this the index will be "incomplete" while I am indexing which I can not have because the index is mission critical.

I want to connect CF11 to a Progress Open Edge 10.28 Database.  In the SYSWOW64 ODBCAD32.exe,  I have a Progress Open Edge 10.2B driver that is used for Crystal Reports and Microsoft Excel.How can I use the same driver to connect CF 11 to the Progress Database?I have not found much information on this topic. Thanks,Tim

I have a document library of hundreds of Word docs.  Due to a third party extension that we are using to create these Word docs, it can take a long time to open them.  I know, ditch the third party app - if only it were that simple.Anyhow, one feature we have is in the footer of the document it let's people know the document is only valid for the date printed and it shows the date.  This way each time it's opened, it has the current date.Can I have cf9 convert these on click?  I have a table of contents that displays the files.<a href="sops/#sops_title_pk#.#Trim(SOPs_title_ext)#" target="_blank">#Trim(Sections.SOPs_manual_prefix)#.#SOPs_title_section#.#SOPs_title_number#.#SOPs_title_revision#</a>Thanks

Hello CF folk, I hope you can help.I'm using jQuery .ajax to post a javascript array to a CF page, which queries a database table and returns a serialized result.  In the 'Network' tab of Developer Tools the result looks good and contains expected data, however it gives an error message "Syntax error :Unexpected token: /".   The response is prefixed by two slashes as below.//{"COLUMNS":["Field1","Field2","Field3","Field4"],"DATA":[[1,0,162,"text1"],[2,0,162,"text2"],[3,0,704,"text3"],[4,0,705,"text4"],[5,0,127,"text5"],[6,0,0,""]]} The .ajax request is below:  $.ajax({       type: "POST",       dataType: "json",       url:  "/links.cfm",       data: {"images" : JSON.stringify(thumbnails_array)},       error: function(xhr, textStatus, errorThrown){            a

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.