Questions

I can download the files as specified, but cannot proceed from there

I'm loving CF9's spreadsheet functions but I've noticed that if the content of a cell would be clipped (visually), setting the column width using spreadsheetSetColumnWidth is not working.  Anyone have a clue how to approach this?

I keep losing connection while trying to code a program in CF Builder.  Keep getting the following error:

I recently upgraded from ColdFusion 8 to ColdFusion 10. I did not had any issues but lately some of the end users are complaining that the cfgrid does not shows any data and is blank. They don't get any error message but the grid is empty and there is no data.We are not able to recreate the issue at our end. I have tried on couple of machines, different browsers and it works everytime.I was wondering if this is a known issue or bug. Is there a hotfix available to this problem?Thanks

Hi,I'm trying to use CFGRID with groupfield attribute to display search results on a page.  The results data depending on the criteria being used by a user may result to many different product category.  Each product category has many different fields although there are some fields that are common to all product category.  So far I was able to display the result in group; however, it only displays the columns based on the first group.  Below is my code as my test.  There are 100+ fields, but have to simplify for testing purposes.<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Untitled Document</title></head><body><cfquery name="qGetProductsCategory" datasource="#application.DSN#">    SELECT referenc

windows 2008/iis 7x

Hi, I'm still confuse with the use of init() with cfc.If I only have the init function on my cfc but I don't set anything within the init(), for example:<cfcomponent> <!--- For example I have this init() within my component but I don't set anything --->    <CFFUNCTION name="Init" access="public" returntype="any" output="false" hint="Returns an initialized component instance.">    <cfreturn THIS ></cfreturn>   </CFFUNCTION> <!--- Then I have many more functions below ---> <CFFUNCTION name="ValidateEmpId">     <!---- validation codes here ---> </CFFUNCTION> <CFFUNCTION name="ValidateEmpSal">   <!---- validation codes here ---> </CFFUNCTION> <CFFUNCTION name="ValidateAddr">   <!---- validation codes here ---> <CFRETURN Sal> </CFFUNCTION> </cfcomponent> <!--- When I call this init() from my .cfm this way, what will happen? I d

I have some valid JSON data that's being converted successfully by DeserializeJSON... until it gets to a certain size, or that's certainly what appears to be happening.  The breaking point seems to be somewhere in the neighborhood of 35,000 characters... about 35KB.  When the conversion fails, it fails with a "JSON parsing failure: Unexpected end of JSON string" message.  And when the conversion fails, the JSON data is deemed to be valid per tools like this one:  http://www.freeformatter.com/json-validator.html.So, is there a limit on the size of the JSON data that can be converted by DeserializeJSON?Thanks!

Hello All,   I am having a problem with one of our applications. It is written in ColdFusion and uses SQL server. The problem that we are having is when we use the URL Http://bma.com (that is not actually the site name)  we cannot see all the data that it is suppose to pull in. I get an error on page and when I select to view the error this is what I getMessage: 'WddxRecordset' is undefined Line: 184 Char: 2 Code: 0 URI: http://bma.com/user_maintenance.cfm and Message: 'jsusersTLV' is undefined Line: 3208 Char: 6 Code: 0 URI: http://bma.com/user_maintenance.cfmIf I put the IP address in the URL for example http://165.83.109.246/bma/login.cfm all of the data is displayed as it should.Any thoughts or sugguestios on how to correct this? Thanks

I have a devotional that goes out daily from a MOBILE table containing:mob_idcalendardatetitlescripturebody The same devotional goes out to 3 different churches.I have a second TABLE called EDITED that holds an edited version of the daily devotional, containing:edit_idcalendardateetitleescriptureebody The query should look in the edited table for a devotional first to see if it matches the current date then send it out. Otherwise it sends out the default devotional  that corresponds with the current date.I would like to send out in replacement of the default devotional  to the church that edited the devotional.I am using the following outer Join but it doesn’t work. It sends the same devotional to everybody.<cfoutput><cfloop query="getClients"><!--- determine if there is an edited version of the devotional available for this day ---><cfquery name="getDevotional" datasource="#application.dsn#">SELECT mobile.mob_id, mobile.display_date, mobile.title, mob

Hi,My ColdFusion 10 server is not responding to http POST requests with XML body (like you use for web services or soap requests).I need to setup a web services interface on my server that allows to accept XML form submits from the Adobe DPS server.(http://www.adobe.com/devnet/digitalpublishingsuite/articles/dps-entitlement.html)I have been using Ben Nadel's posting to get up to speed on XML post submits (http://www.bennadel.com/blog/745-Posting-XML-With-ColdFusion-CFHttp-And-CFHttpParam.htm), but I'm running into a problem because it seems my ColdFusion 10 server (on windows 7, with IIS) is not responding to XML POST requests. I've build a simple post cfm script, and a receiver cfm script, but any request is only timing out.If I do a simple POST with formfields, then it works:<!--- Set the URL. ---><cfset strURL = "my server" /><!--- Create the XML data to post. ---><cfsavecontent variable="strXML">    <credentials>    &

I made a website and about a year ago the contactus.cfm page disappeared, although the other three pages were still visible. Would that be because I had not updated it? Or some other reason?

I am using cf9 with mySQl 5+. I have two tables:Signups -  where people signup to take a course.Course_eval – once the course is completed, the student fills in the course evaluationI use an inner join on userID in both tables.I have a page, showsignups.cfm, that lists all of the students by course. Once a student finishes the survey, a button will show up next to the student in the showsignups.cfm page where it can be clicked on to show the survey by the individual student.My problem is instead of showing all students with or without the survey buttons, it only shows the students who have finished the survey. It should show:Student’s name | survey buttonStudent’s name |Student’s name | survey buttonStudent's name | I thought using a cfloop through the students would give me the effect I want, but alas, no. Here is the code I am using for the cfquery:<cfquery name="getsignups" datasource="#application.dsn#">select signups.courseTitle,signups.property,signups.calendardate,sig

The error cfm page included in <cferror> tag in Application.cfm gets called multiple times, so email notification is sent more than once. Any thoughts how this can be handled?

How do I over-ride the gray screen color in a cfwindow that is created by coldfusion.window.create?The following JS does not work for IE11 on Windows 8.1:  varwConfig = new Object();  wConfig.bodystyle = "background-color: blue"; //changed it to 'blue'wConfig.center = true; //center the window on pageColdFusion.Window.create('mywin', 'test window', 'theUrl.com', wConfig); The above launches the window fine, but keep the same gray color. The wConfig.center=true works, but not the bodystyle. I have also tried 'bodyStyle' as I hear CF10 is case-senstive(?) for URLs, given this is AJAX.

Greetings,Does the CF10 includes the CKEditor? Also does the same version includes a licensed version of the spell check?Thank you.

I use CFMail to send mail. Because the mail contains Spanish, I need the email support utf-8 character set.I use following code to display Spanish characters, but the email shows funny characters.I would like to know are there any way to display utf-8 characters for special language.Your help and information is great appreciated,Regards,Iccsi,<CFMAIL FROM="#myMail.Frommail#" TO="#MyMail.ToEMail#"   bcc="#MyMail.BccEMail#" SUBJECT="My Subject" charset="utf-8"TYPE="Plain Text">      #MyEmail.EMailMessage#</CFMAIL>

Hello....I currently have a production server that runs:Windows Server 2008 R2 64 BitIIS 7.5Cold Fusion 9.0.1 32 Bit (JVM version 1.6.0_17)Our website uses a COM object to generate JPG images which emulate a GIS system.  Everything works well on this config.I need to setup a new production server, with Windows Server 2008 R2 64 Bit, IIS 7.5I have tried to install both ColdFusion 9.0.2 (JVM Version 1.6.0_29) as well as ColdFusion 10.0.0 (JVM Version 1.6.0_29).In both cases, I cannot invoke my COM object.  I receive an object instantiation error.Here is what the CF Log says:An exception occurred when instantiating a COM object.The cause of this exception was that: java.lang.RuntimeException: Can not use native code: Initialisation failed.I confirmed that on this server, ColdFusion 9.0.0 (JVM version 1.6.0_14) works, so I'm pretty certain that it is not an object registration error or anything.I have attempted to install ColdFusion 10.0.0 with JVM version 1.6.0_17, but cannot st

We're running a page that contains an include file with code that loops through a recordset and displays a map using CFMap. We have similar code working on several other pages, but on one page in particular, no map is displayed. There are no error messages, just no map.We've also troubleshooted by simplifying different parts of the code, such as the window display HTML to rule out syntax issue, and also placed the map at the top of the page to rule out CSS type display issues, and still no go. in the abscence of error messages, i'm not sure how to troubleshoot this. There doesnt appear to be any in the log files on the server as well.Does anyone have a suggestion as far as how to troubleshoot this issue?

Hello,We are having a problem with the security provider JSafe JCE running on WebSphere 7. The administrator of Coldfusion 10 does not run after setting the password.We had remove the security provider at runtime using these lines of code:<cfset objSecurity = createObject("java", "java.security.Security") />    <cfset objSecurity.removeProvider('JsafeJCE')>After this everything starts working again in the application. However, the Web Sphere Application server is having troubles with it as well.When I go to the Troubleshooting section of WebSphere, and hit the option to see the Class Loader Viewer, the page is not able to show results and it freezes.IBM support ask this:          If certs are trusted by JSSE2:  This error usually occurs when the provider used to parse the cert in the jar to be verified and that used to parse the hardcoded certs are different.  Also check if they are adding third party pro

If my server is at 9.0.1 with no hot fixes and I want to get to 9.0.1 up to date with the latest hotfixes up to apsb13-27. Do I install the cumulative hotfix 4 for coldfusion-901 as described in http://helpx.adobe.com/coldfusion/kb/cumulative-hotfix-4-coldfusion-901.html and then install apsb13-27 (update 11) as described in http://helpx.adobe.com/coldfusion/kb/coldfusion-security-hotfix-apsb13-27.html?I don't need to install cumulative hotfix 1, 2 & 3 first; right? Cummulative hotfix 4 includes 1, 2 & 3; right?One other question, from people that have done this type of upgrade...is it pretty safe? I plan to test pretty thoroughly on dev before doing the same on prod, but I was wondering if others have seen very many issues when doing this?

I need to send an email when user change select list.I can use cfmail to send out email, I would like to know is it possible to trigger the mail when user click and change the select list or I have to use when user click a button,Your help and information is great appreciated,Regards,Iccsi,

I want to to pass the value users select from form.MySelect.I use <cfif IsDefined("form.MySelect")</cfif>it seems that ColdFusion server does not recognize it.It works if I use text control.I would like to know are there anyway to pass select value to ColdFsuion server to use <CFIF IsDefined>If not, any suggestions or use hidden controls to set the value when user select a value from drop down box.Your help and information is great appreciated,Regards,Iccsi,

I can't get new datasource to connect to a local SQL Server Express (2008).On SSE, I enabled non-NTLM authentication, created an account specifically for CFServer, and was able to log into SQL Server through Management Studio. But the datasource still won't connect.When I enter computerName/SQLServerName for the Server, I get a message saying "...The requested instance is either invalid or not running."When I enter just SQLServerName, message says "Error establishing socket. Unknown host: SQLServerName."When I enter (local), I get a message saying "Error establishing socket. Unknown host: (local)"When I enter 127.0.0.1, message says "Error establishing socket to host and port: 127.0.0.1:1433. Reason: Connection refused: connect"I don't know why the first is considered invalid, or why the fourth is refusing connection. Am I forgetting something?

When will Cold Fusion support RH Linux version 6.5?