ColdFusion

Can someone help me resolve why when I generate a 2 tab spreadsheet, the contents for the second sheet show but the first tab is the one highlighted at the bottom of the page? I have tried trying to make the first sheet active again before making the file but it gives me a write error. See attached image.Second question how do I use cfspreadsheet update functionality to add a sheet to the front of an existing spreadsheet, I cant seem to find any good documentation on it.

I am using Coldfusion 2016 on rhl7 and cant write a spreadsheet file.<cfscript> ///We need an absolute path, so get the current directory path. theFile=GetDirectoryFromPath(GetCurrentTemplatePath()) & "newSpreadsheet.xls"; //Create a new Excel spreadsheet object. theSheet = SpreadsheetNew("Expenses"); SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");SpreadSheetAddRow(theSheet,"Order,First Name,Last Name,Address,Amount,City");</cfscript> <!--- Write the spreadsheet to a file, replacing any existing file. ---> <cfspreadsheet action="write" filename="#theFile#" name="theSheet" overwrite=true sheetname = "Expenses">Returns the following error:An exception occurred while using action=write.java.lang.ArrayIndexOutOfBoundsException: 0Can anyone help?

Hi. I've been looking at the ColdFusion feature list and under Email Management, I read "Attach a callback handler to the CFMAIL tag to get delivery notifications." Can anyone provide a link to an example of what this looks like? Thanks in advance.

I am in the process of developing a contact management system for my company and have built coldfusion pages that allow the user to import their personal contacts from outlook, as well as export contacts from the system into their MS Outlook contacts. The process is fairly simple on the users (in my mind) but it requires using Outlook's import/export function, which is about 6 or 7 steps. My users would of course like to have this process simplified. Is it possible to have a button on one of my pages that automates the entire process? i.e. creates the csv file (or whatever other format is needed) and then automatically pushes that data into outlook (and vice versa) ? Any thoughts or suggestions are greatly appreciated!

Update 16 has deleted all Scheduled Tasks all servers updated. Just gone??

Recently Adobe released HF16 for CF11 but I am having issues installing it.   the details log file states that all prerequisites are successful but it errors out with "No Administration Privileges" even though I am running it from an administration command line.I didnt have this problem when I implemented HF15.  Matter of fact, as a test, I uninstalled and reinstalled hotfix_15.jar without any issues in the same command line. Is there a place I can look to see what HF16 is attempting to access or do where HF15 didnt?  This is all on a Windows 2008R2 server.Here is the log output (minus some details on the admin line)...Install Log Detail:Check Disk Space:                                   Status: SUCCESSFUL                &nb

I've been working on this for a month and I'm stumped.  This is the code to logout...<cfscript>   StructClear(session);   StructClear(application);</cfscript>...that's it (besides some HTML "You've logged out").This works fine on our DEV & TEST environments, but gets a 500 Error on our PROD environment.  Nothing in the error log.  I've searched exhaustively and cannot find anything.  And we have a System Admin who is difficult..."it's the code."Any idea?Thanks in advance.ColdFusion v11.

Hi There,As soon as ColdFusion 2018 update 2 was installed and the Apache connector was rebuilt, we are seeing this following error in mod_jk.log, repeatedly.[Thu Feb 14 12:42:06 2019] [16186:139977799252096] [error] uri_worker_map_update::jk_uri_worker_map.c (1299): Unable to stat the /opt/coldfusion2018/config/wsconfig/1/uriworkermap.properties (errno=13)The server is running RHEL 7, with SELinux and locked down. However the apache is running without any issues and the web application doesn't experience any issues. But the mod_jk.log is flooded with this entry.It would be great, if someone could assist on this please. We didn't face this issue before.

Hi, here's my problem. My web server uses CF MX 7. I want to get form output, create a .pdf from it, and send the .pdf as an email attachment. This seems to be easy using CF MX 8 and beyond: use cfdocument to create a .pdf and attach the .pdf to an email usig cfmailparam, without writing to disk first. This cannot be done in CF MX 7.So, to accomplish what I want in CF MX 7, I need a way of doing the following:1) Output form data to the browser. (Done)2) Save the format to disk *in the format in which it is outputted to the browser*. (CFFILE does not help in this regard)3) Convert the file on disk to .pdf format. (I assume CFdocument will do this.)4) Send the .pdf file as an attachment to an email.Is this possible? If so, how can it be achieved? Thanks very much.Best wishesChris

I installed ColdFusion 2016 Update 8 and my Scheduled Tasks disappeared!!!How do I get my Scheduled Tasks back?

We installed the CF11 Update 16 today and it deleted all our scheduled tasks.  Unfortunately, we didn't notice until we installed on 3 other servers.  All tasks gone.We tried to restore with a recent CF Archive from the Admin.  Did not restore tasks.It looks like the system did create a backup of the old tasks file: neo-chron.bak.However, when we rename this back to neo-chron.xml and restart the server, CF replaces it with a blank file and makes a backup again. Any help or ideas?  Looks like we need to crawl through the XML and re-enter tasks by hand?Logs look to show Null Point Exception:"Error","localhost-startStop-1","02/15/19","14:14:25",,""java.lang.NullPointerException    at coldfusion.runtime.Cast._boolean(Cast.java:323)    at coldfusion.scheduling.ScheduleTagData.setAttributes(ScheduleTagData.java:1309)    at coldfusion.scheduling.ScheduleTagData.<init>(ScheduleTagData.java:349)    at coldfusi

During installation of CF2018 on windows 2019, I'm not getting option to select IIS as web user. In-Built web server is being used.  Anyone had this same issue?

I have a process that reads an ID from a table, increments it by 1 then calls several pages that write the new ID to different tables. I want to use cflock to prevent a second user from reading the ID before it gets incremented and written back out. This process can happen on several different pages. If the lock name is universal across the site does CF prevent it from running on page2.cfm if page1.cfm is running it and it's locked? My code looks like this:<cflock name = "ConnectBack" timeout = "50" type = "Exclusive">!- Get current ID !- Increment it by one!-  Cflocation pages that write it out to new tables</cflock>Thanks....

Hello,I need to make a user pause for 5 seconds when another user is completing a particular task. I can't figure out why my cflocation tag doesn't execute after the cfflush is done. If I remove the cffush it works. What am I missing?Thanks in advance for any assistance.<style>.loader {  border: 16px solid #f3f3f3;  border-radius: 50%;  border-top: 16px solid blue;  border-right: 16px solid green;  border-bottom: 16px solid red;  border-left: 16px solid pink;  width: 120px;  height: 120px;  -webkit-animation: spin 2s linear infinite;  animation: spin 2s linear infinite;}@-webkit-keyframes spin {  0% { -webkit-transform: rotate(0deg); }  100% { -webkit-transform: rotate(360deg); }}@14668356 spin {  0% { transform: rotate(0deg); }  100% { transform: rotate(360deg); }}</style><cfflush>Please Wait. Another user is creating a configuration file.<br><div class="loader"></div><cfflush&

Hello,We are using Cold Fusion 2018 on a windows server 2016. When I try to access a cfm file I get an error, the details of which tell me that I do not have access to a table( dba_data_files) in a query that is being run. When I copied and pasted the same query in my SQL editor I do have access to the table with the same user which the cfm file is supposed to access. I have double checked the data sources in cfm admin page and also the System DSN all are looking to point to the same database and the user. So what could be wrong why am I getting this error ? ThanksIQError Executing Database Query.    [Macromedia][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist       The error occurred in C:/inetpub/wwwroot/TOPS/admin/admin_datafiles.cfm: line 2018 : 19 : <cfif dbtype is 'oracle'> 20 : <cfquery name="Select2" datasource="#datasource#" UserName="#Session.UserName#" Password="#Session.Password#"> 21 : SELECT file_name, tablespa

After installing the latest update hotfix 16 on our coldfusion 11 server (Win 2008 R2 with latest patches and latest java jdk) the CF server restarts (access to CF admin is working) but the CF ODBC service does no more start. After un-installing the update it works again.This already was an issue in update 15, see discussion "CF 11 update 15 - ODBC server no more starts".Adobe please fix.RgdsManuela

I am having problems with VCard encoding, such that my coldfusion generated VCards are compatible with Apples Address Book, but remain unreadable by Outlook or anything on a PC. A link is clicked which sends a persons id to the script which then outputs the details (beginning of script shown underneath). (I understood that VCard v2.1, not v3.0, would allow me to specify UTF-8 as Charset) The Outputted VCards look to all intents and purposes correct when opened in Apples Textedit or Microsofts Wordpad, though when opened with Notepad on a PC I can see that line breaks are replaced with a rectangle (suggesting no character) and this is preventing Outlook from reading the details. Also, the file has no extension and so isn't recognised on a PC as being .vcf. Anyone shed any light on this?

Please download the attached file to view this post

(Raises hand)Can anyone, here, tell me about the most recently discovered CF zero day exploit?I'm not an admin, but I've been coding CF since late 2000 and am curious about what is known about this most recent exploit.V/r,^ _ ^

Hi there,I was able to successfully install CF2018 PerformanceMonitoringToolset in the server. But its not able to discover the server, automatically, as the application server is running over https(port 443). Is there anyway to configure the Performance Monitoring Tool to run over https and to use Apache? I couldn't find its configuration files. Thank you,Annie

Hi, I want to allow users a way to import their contacts from outlook into my CF based system. When I say system I mean I want to build an interface that allows the user to click a link that says import contacts, the user would have a choice, perhaps a text file, excel file or outlook. I can do the text and probably code the part to import from excel but 1. How can I export from outlook using CF? 2. How can I do this in a way that works in both Firefox and IE? Thanks, -WestSide

Can ColdFusion 2018 be installed on Windows 2019 Server?  Thanks.

Using a recent version of ColdFusion that has the built in POI library, using HWPF or XWPF (it does not matter which one), does anyone have sample code that would read a word file from the server, replace text (for example: replace "*test*" with "12345") and then output this new version of the file to the browser? No need to save the file. Pushing the new file data via cfcontent is what I am looking for.Any help would be appreciated. Thank you in advance.

I have strings like thisPGH2019AprilPA73-01.docxPGH2019AprilPA73-0.docxPGH2019AprilREC73-0.docxI need to extract the number 73 from the string.The number could be 2 or 3 digits long, like 99 or 101 EG: PGH2019AprilPA99-01.docx or PGH2019AprilPA101-01.docxThe number is always right before the -0PGH2019AprilPA73-01.docxPGH2019AprilPA73-0.docxPGH2019AprilREC73-0.docxHow would I extract this 2 or 3 digit number that precedes the -0?

Hello,I created a tracker entry CF-4203491 a few months ago and the bug has recently been verified and is to be fixed. The email  no-reply email I received reads:Target Version updated to 'Alpha'Version updated to '13.0'Version updated to '2016'It looks like the latest Update 1 version for the 2018 (13.0)  was released on September 11, 2018.Can I expect CF-4203491 to be included in Update 2 for ColdFusion release 2018 (13.0)? If so, is there an expected release date for this software Update? It seems like Updates are release every quarter or so but was hoping for an expected release date.Thanks,Jim