Questions

I currently have a project that I took over from another developer. Part of the application outputs data from a SQL Server 2008 database to an Excel file that has three sheets or tabs, which are created in order, left to right. I am working to fix a problem in which when opening the Excel file, the first and third sheets are "grouped". Next to the file name in the title bar, it says [Group] and both sheets appear to be active. The problem with this is that, if the user were to, say, highlight row 5 in sheet 3, row 5 also gets highlighted in sheet 1. I have searched everywhere with every search string I can think of and can't find anything! I even tried recreating a skeleton of the functionality based on the CF documentation and ran into the same problems. I have figured out a few things on my own.First, the middle sheet is not affected at all. Second, once in Excel, if you select the middle sheet, everything else gets fixed (of course, that's not a great solution for the end user). Thi

Hi everyone,I am working on moving a CF7MX project to CF10 and one of the changes involve updating some code used for generating csv files so that it makes use of the CF spreadsheet functions.  One thing I noticed was that I can no longer use the "Format Cells..." functionality with xls files generated with the CF spreadsheet functions.If I try it with any other file it works like a charm, but with these CF generated files clicking on the button shown above does nothing.  Is this a already bug known by Adobe? Is there a way to make this work?Regards,Miguel Arvelo

how save applet as image file in cf please help me ?? below is my code<APPLET style="border: solid 1px gray"                                            id="EIDAWebComponent" name="EIDAWebComponent"                                            CODE="emiratesid.ae.webcomponents.EIDAApplet"                                            ARCHIVE="EIDA_IDCard_A

Hi All,To prevent crosssite scripting attacks I ticked the the check box "Enable Global Script Protection" in CF admin. But it is not working , I mean not able to prevent the scripting attacks.Steps I followed1] I executed the below URL.     https://xyz.abc.com/index.cfm?cardholder_number=&<script>alert(1)</script>2] In the fornt end I got a javascript alert message as injected in the URL.But this alert message should not come as I have enabled script protection in CF admin. Right????Now I removed "&" (https://xyz.abc.com/index.cfm?cardholder_number=<script>alert(1)</script>) from the above URL  then I was not getting the javascript alert message. Does this mean that script protection will not work if we are adding "&" to the URL????.I searched the neo-security.xml and its looks like below.<var name='CrossSiteScriptPatterns'><struct type='coldfusion.server.ConfigMap'><var name='<\s*(object|embed|script|a

Trying to get a site login set up and I keep getting the above error. I have enabled session vars in the CF admin, and have used sessionmanagement in my cfapplication. Not sure what I've done wrong. <cfapplication name="myApp" sessionmanagement="yes" setclientcookies="yes" sessiontimeout="#CreateTimeSpan(0,1,0,0)#"> <!--- Now define that this user is logged out by default ---> <CFPARAM NAME="session.allowin" DEFAULT="false" /> <CFPARAM NAME="session.userName" DEFAULT="" /> <!--- Now if the variable "session.allowin" does not equal true, send user to the login page ---> <!--- the other thing you must check for is if the page calling this application.cfm is the "login.cfm" page and the "Login_process.cfm" page since the Application.cfm is always called, if this is not checked the application will simply Loop over and over. To check that, you do the following call ---> <cfif session.allowin neq "true">      <c

I have an e-marketing application that was developed in ColdFusion 7 and uses an Access database. I have recently migrated the database to SQL Server Express 2012 and ColdFusion 10. However, it has now stopped working, although the same code works on CF7.The app is accessed via a browser based interface and allows the user to schedule the automated sending of emails and also specify what the delay should be between sending each. For instance, I may send 100 emails and set the delay to 4 seconds between each.When I look in the logs I see: javax.mail.AuthenticationFailedException: 504 Access to this service has been denied by the mail administratorDoes anyone know what I need to do enable the service?

I created a couple of reports and try to run different format.I just realized that some report works flashpaper, but some of them do not.I set default format to flashpaper at design time for all reports.The reports work for PDF, Excel, RTF, XML and HTML, but for flashpaper some of them work, some of them do not.I would like to know are there any property and code need to set it works.I use IE 8 which should support flashpaper, since some of the reports work.Your help and information is great appreciated,Regards,Iccsi,

I had the Master Collection 3 installed on an old laptop. I brought the software through my school's program. A few years after, I bought the MC 4 upgrade through my school. Since, I have had to purchase a new computer and I tried to install the MC4 upgrade. I can only use a trail version for 30 days because I need the MC 3 serial number which I cannot find. Is there a way to retrieve the serial number associated with my account or Adobe ID? I have the serial number for the MC suite 4 but it will not activate unless I enter the MC suite 3 serial number. Hence, I can only use it on a trail basis for 30 days. Thank you in advance.

So I tested my server before I implemented live and everything worked just fine. So after I entered the license key all my “ColdFusion Collections” were gone and my search pages are throwing a 500 error. This is what I get inside CF11-------------------------The Solr indexing engines allows you to easily develop search capabilities for your ColdFusion applications. A Solr collection is a group of information that can be indexed and searched as a set. Use this form to create and manage your Solr collections.Unable to retrieve collections from the Search Services.Ensure that you have installed ColdFusion Search Service and it is running.--------------------------Running on:CF11 IIS 8.1MS 2012 R2Thank you!

I'm currently running a WAMP server to run some PHP code. A part of my codebase is in Coldfusion. Is there a way I can run CF without shelling out 4 grand?

Hi all. We have need for an easy to use, browser based end-user reporting tool that can be hosted by CF10. We are spending a fantastic amount of time building custom tabular reports for our client and would prefer to give them a tool in our app that let's them build reports whenever they want. Do any of you know of any good reporting tools where the end-user could build their own reports?Thanks for your help.-Andy

I'm trying to upgrade my SQL Anywhere database server from 10 to 16I want to use the newer JDBC connection( My database runs on a different machine/server than the CF server )On my test systemServer Product    ColdFusionVersion    ColdFusion 10,282462Edition    Developer  Operating System    Windows 2003   Standard Service Pack 2OS Version    5.2  Update Level    /C:/ColdFusion10/cfusion/lib/updates/chf10000002.jar  Adobe Driver Version    4.1 (Build 0001)  Data sources using the old jdbc-odbc bridge driver workCF data source name: -> demoJDBC URL ->jdbc:ianywhere:driver=SQL Anywhere 10;dbn=demo;links=tcpip(HOST=xx.0.0.xx;PORT=2620);eng=demo16Driver Class -> ianywhere.ml.jdbcodbc.jdbc3.IDriverDriver Name -> SQL Anywhere 10User Name ->  dbaPassword -> sql(with, as you might expect, numeric values in place of xx)In order for these t

Moderator, I'm pretty sure it was rejected because we're not allowed to post jobs. It would be awesome though if you could help the adobe coldfusion community by posting this job somewhere. Any ideas? Any recommendations?

I have following code to generate the report for pdf format.I would like to let users to choose report type 'pdf' or 'excel'I need pass the user select from user interface to <cfreport format= "PDF" or "Excel".Can you please advise how I can pass the user select Report Type from lsReportType to my cfReport?Your help and information is great appreciated,Regards,Iccsi<cfstoredproc procedure="spGetReportType">   <cfprocresult name="rsReportType" resultset="1"></cfstoredproc> <cfreport format = "PDF" template= "MyReport.cfr" query="#myQuery#">   </cfreport> <td><select width="50" name="lstReportType" id="lstReportType">      <cfoutput query="rsReportType">         <option value="#rsReportType.ReportTypeID#" <cfif (isDefined("form.ReportTypeID") AND form.ReportTypeID EQ rsReportType.ReportTypeID)>selected="selected"</cfif>>#rsReportType.Re

HiDoes anyone have any links or resources you can point me to that describes performance diffs between using cfquery and using ORM? I understand that the CF world is already on the ORM bandwagon but I need to get a client some real world numbers regarding the diffs.Thanks in advance,Rich

I am using coldfusion 10 and I am searching a collection of pdf's.  I need to be able to highlight the 'search term' within the pdf.  How do I do that.

Hello, I need an information about ColdFusion Enterprise. Is a licensing on a virtual server possible?

A little background:We upgraded from CF8 Enterprise to CF10 Enterprise about a week ago. In order to transfer all of our scheduled tasks to the new server I copied neo-cron.xml over to the new folder. I quickly discovered that this was a bad idea on encountering all kinds of weird issues such as being unable to edit tasks or delete them; I'd get messages likeAn error occured scheduling the task.Unable to store Job : 'SERVERSCHEDULETASK#$%^DEFAULT.job_TEST TASK', because one already exists with this identification....when trying to edit an existing task. I'm actually still getting that one sometimes. I'd get similar errors when trying to delete some tasks.Well, I took to google and discovered that copying neo-cron.xml from CF8 to CF10 is a bad idea. So, after making a .txt reference file of all of the tasks, I shut down CF10, deleted neo-cron.xml and neo-cron.bak, replaced neo-cron.xml with the blank one from our CF10 dev server, and restarted the service. Then I manually recreated all

I'm getting the following error message in CF11 when  trying to access my MYSQL database on a local machine: Could not create connection to database server. Attempted reconnect 3 times. Giving up. I created the DB in the admin page. I also verified the DB. I can open the database in the command prompt. The only thing I can't do is connect it in CF11. Everything tells me the DB is connected and working fine, just not when I view the data in the web page. Any suggestions would be appreciated. EDIT: forgot to mention the rest of the error message, I hope it helps:The error occurred in D:/inetpub/wwwroot/Applewood Community_03/textareaTest.cfm: line 9   Called from using password: line -1  Called from using password: line -1

HiI downloaded the new CFBuilder 3 yesterday and went to use the Apptacular plugin to "Generate Application" but received the following error:The web site you are accessing has experienced an unexpected error.Please contact the website administrator. The following information is meant for the website developer for debugging purposes.Error Occurred While Processing RequestInvalid CFML construct found on line 38 at column 45.ColdFusion was looking at the following text:outputThe CFML compiler was processing:A script statement beginning with writeDump on line 38, column 17.A script statement beginning with public on line 37, column 9.   The error occurred in /Applications/ColdFusion11/cfusion/wwwroot/Apptacular/handlers/Application.cfc: line 3836 :  37 :           public void function onError(any exception, string eventname){38 :                 &nbsp

Hello,Where could I found the Enterprise version of Coldfusion 10 for RedHat ?ThanksOth

Hi all,I currently have a win 2003 server running CF9 and CFBuilder. I have decided up upgrade to CF11 and CFBuilder 3 on a win 2008 server.CFBuilder developed codeI installed CF11 without much issue in Production mode, moved some of my CF9 code and over it worked ok, a few coding issues but nothing major. I then attempted to install CFBuilder 3 I chose not to install the local admin server as I had installed CF11. I attempted to set up a server in CFBuilder using 'other' and pointing it to my cf root but the server just showed as stopped.I then noticed my CF11 was broke. The admin page would not display, the code I copied over would not display. I looked at the main CF11 service and it was running, I tried to restart it but it crashed. I then attempted to uninstall CF11 and CFBuilder but they would not uninstall properly.I have rebuilt my 2008 VM, so now have a clean server to start again.So - any advice on where I went wrong, or pointers on what I should do ?This set up is used to ho

II'm trying to have my images do the following after upload:If greater then 2000px wide then resize down to 2000px (I got that functioning ok as of now)crop off the top and bottom 25% of the image to make it rectangular. MY my problem lies in trying to figure out how to crop that 25% off the top and bottom equally no matter what the height is.. I can't control all the possible different sizes a user might upload (height and width) I just know I need it about 2000px wide and the height be around 650px (roughly) and cropped at the top and bottom. Could anyone help help me with writing something like that up? Thanks allot

I purchased CF Builder 2 during a promotion a few years ago, and CF Builder 3 does not recognize that license number when trying to upgrade.  any ideas?

We are looking to upgrade our existing CF server from CF5 to the latest version. I found some system requirements on the website, but I’m not sure of the version required and a few other things.Our current set up is as follows:•OS: Windows Server 2000 SP4•Processor: 2.4 Ghz Intel Xeon•RAM: 3.14 GB•C Drive: 10 GB•D Drive: 30 GB•CF Version: CF5The questions I have are:1.What version of CF would we need to run our application? We have CF installed on a DEV server and a PROD server (both with the same specs as mentioned above).2.What is the price of the suggested version?3.Are there version steps that we much take to upgrade to the latest version or should we just start with a fresh install of the newest version?4.Can support be provided to configure the new version on our new server once we get it installed? Is there a price or is it rolled into the version’s cost?Any help or information would be greatly appreciated.Thanks