Questions

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?

Is some restriction to use cfmap in conjanction with cfdiv bind?I have <cfdiv id="resultdiv" bind="url:map.cfm" />The bind is workin, I can see the page, and cfmap is working as I can see it if I use cfinclude instead of cfdiv.For some reason if I use cfdiv, I got the error

I have the table:    IDcondition_idproperty_id1c_3b_12c_13b_23c_3b_44c_13b_15c_3b_26c_4b_1I need to select all properties with condition_id c_3 and c_13 not just c_3 or c_13 (I expect in the result it should be only b_1 and b_2)The query like this:SELECT * FROM tableWHERE condition_id IN (  3,13                                                            )The result (b_1, b_2, b_4)What do I do wrong?

I try to set up a datasource to SQL server 2008 Express.And I get always that message :The requested instance is either invalid or not running.I spent a full day looking at all forums threads, I have learn a lot, Looking through all Google return on that subject, but it still not working.I ask for help to solve this situation.Here is my situation :- Windows server 2008 R2 - CF9.0 - SQL server Express 2008- Working through TSE (terminal server)- on SQL server , I can acces the management studio, connect, create DB, anything- I can Stop/Restart the SQL server service throuh the SQLconfig manager- I have enable TCP/IP in SQLserver for 2 IPs : 127.0.0.1 and the server externel IP on which I connect through TSE, both on port 1433- SQL server Express 2008 is installed on Hard Disk 😧  (not on C:)  (C is small for diskspace)- The SQL server Instance showed in SQL management Studio is : LARDE\SQLEXPRESS- Authentification in SQL server : SQL server and Windows- the CF datasourc

Using Access databases, (.mdb files , lighter than accdb)How can I know when the mdb file have been last modified ?Looking for a simple way.If possible, by querying something ?Thanks for any suggestion,Pierre.

I  need to send e-mails using CFMAIL, but am unable to verify the connection to the CF Administrator Mail Server, which presently is localhost.This question has been asked in other places, but I have checked the remedies suggested there (firewall blocking, etc) to no avail.I am using Server Port 25 and have tried enabling both TLS and SSL.There are no basic Server issues, since I get the message "Server has been updated successfully" upon re-entering the Server Settings data.Thanks in advance for comments.

I have two fields that I need to concatenate after I have performed a calcutation. I am taking a school year and subtracting 5 years. School Year = 201314. I want the result to be 200809 so that I can select any courses that have a School Year greater than 200809.I have tried many variations of:LEFT(sysvar.cur_schyr,4) - 5 + RIGHT(sysvar.cur_schyr,2) - 5 as "B4SchYr" this adds 2009 + 08 and gives me 2017 when I want 200809 returned. How do I treat the numeric strings as characters?Thanks.

Hello All,I am very new to Coldfusion and hosting coldfusion based sites in IIS.Recently I was trying to host 2 sites whose homepage is working fine. But the links are not functional. When spoke to the developer, as per him, there needs to be a mapping for 301 and 404 errors in IIS.I did set a 404 error page in IIS console, with the cfm script he asked to set (/404index.cfm) as Execute URL.But it is giving me a blank page. If this is not set, then it gives me 404 error with coldfusion stack trace.Coldfusion is updated to the latest patch 11. I am getting clueless on this. Can someone suggest a solution?Thanks in advance.Regards,Kurian.

hello, i am using ColdFusion MX 7,0,2,142559.  the issue is that i have several data sources, however one of them locks out every now and then.  Not sure what is causing only this data source to lock out.  Any suggestions?  by the way this is running on oracle database.

Hi all,I have the csv file with the format below.It has about 15 fields.  I want to read this CSV file and inserts the records into my table but got an error below.43;Test;;TEST PASS;Time Completed;22.13202;21.55828;;119.95;3 - WATER SEAT P;315.0;120;5.0;16/07/2012;22:17:36;======ERROR  ===========Invalid list index 14. In function ListGetAt(list, index [, delimiters]), the value of index, 14, is not a valid as the first argument (this list has 13 elements). Valid indexes are in the range 1 through the number of elements in the list.  ===========Can anyone can help me plz?<cfoutput><!--- get and read the CSV-TXT file ---> <cffile action="read" file="#thisFile#" variable="csvfile"><!--- loop through the CSV-TXT file on line breaks and insert into database ---> <cfloop index="index" list="#csvfile#" delimiters="#chr(10)##chr(13)#">     <cfquery name="importcsv" datasource="#request.dataSource#">     &n

I'm setting up a new app in CF 10, and have set up my application.cfc. I created a test page that calls onError() manually, as a test. Like the title says, I get a message saying "onError is not defined", but onError() itself is handling this error. I know this because I have it output a string to indicate that it has fired.Also, I'm trying to test onError() by intentionally not closing a tag and calling the page. onError() won't fire here; instead I get the standard ColdFusion error grey box.Any help on these is much appreciated.

I am running the following:ColdFusion 8 Developer /EnterpriseRedHat Linux Enterprise 6.0Apache is my webserverThe JRE is what came with ColdFusionI am trying to Enable SSL connection between Flex/Flash Applicationand Coldfsuion.I followed the direction outlined in:http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=UseFlexDataService_09.htmlHowever, when I get to:Flex Integration:keytool -export -v -alias FlexAssembler -keystore cf.keystore -rfc -file cf.cerI get a Java IOException: Keystore was tampered with, or password was incorrect.The password is correct.  The file is on a closed system, so nobody has tampered withthe file.I assume I am supposed to import the certificated into/opt/coldfusion8/funtime/jre/lib/security/cacertsI have tried removing the "JRE cacerts" file, but that failed.As suggested by another website.Any ideas.Brian

I cannot seem to get my REST service to work... I get a 404 when I call the URL.Im running Win 7, CF 10 developer, Apache webserver. I've developed on this for years, so the setup works - but this is my first go at REST services thru CF... I mention that because CF is working, the dir and webserver are working etc.Directory looks like thisC:\wwwroot\restTestCODE - saved as "obj1.cfc" - ( Note: I've tried restpath with and without the / )<cfcomponent restpath="/restTest" rest="true" >      <cffunction name="getMethod" access="remote" returntype="String" httpmethod="GET" >          <cfreturn "this is a string returned" />      </cffunction>  </cfcomponent>The coldfusion ADMIN setup looks like thisRoot path: 'C:\wwwroot\restTest' Service Mapping: 'test'I'm using the service mapping because I don't have an associated application name - no Application.cfc - I was trying to keep