ColdFusion

Earlier versions of CF didn't let a comma slip through to mess up SQL statements.  This version does.  Not only that, but the javascript code in cfform.js, if extracted and run separately against a <form..>..</form> rather than a <cfform..>..</cfform> does trap and reject commas.  By the way this is true of validate="date", and validate="float" also.  I submitted a bug report on 9/14/15 and have had no response so far.  I notice that there were reports of this on this forum back in 2014.  Any thoughts other than abandon cfform?

I mistakenly installed 32 bit version. Can I just rerun install with 64 bit version?

Hi there Does any one have a fool-proof document for creating and proving a 2 server ColdFusion 10 cluster? Most of the documents I have found are missing something.  More specifically, what is the difference between HTTP Port and Admin Component Port in the remote instance manager?Should the Cluster Manager show anything on the remote node?Is there a cluster monitor that show's its state? Is the there a simple test to prove it works. If this is in the remote node server.xml <Engine jvmRoute="cfusion" name="Catalina" defaultHost="localhost">should the jvmRoute value in the Instance Manager should be set to cfusion?Thanks for your helpRichard

Hello, all,I'm fairly confident that this is related to my recent posts about SESSION and iFrame.  I'm just not sure how to fix it.I have been working for several months on this project; but I only recently discovered that there are differences in CFAdmin between our dev and production environments.  Production is much more restrictive.SO.. I bit the bullet, and set J2EE sessions to enabled; I set setDomainCookies to 'yes'; and enabled "Use UUID for cftoken" (that is what we have in production.)Suddenly, the forms that I've been working on for months (that submit form data via jQuery AJaX) are breaking.  All of them.  FireBug says that "JSESSIONID has changed".  Well, duh, that's supposed to be a security feature.Is there a way to submit form data via AJaX without undoing any of the settings I outlined, above?Vr,^_^

Is there a alternative to using IP Addresses for Debugging in CF Admin?Our IP Addresses are changed regularly, so can I use computer name?

After installing ColdFusion 11 Enterprise Evaluation then upgrading that installed version to a paid licensed version, we cannot get the Web Server Configuration Tool to work. This is on Windows Server 2012 R2. All  updates are installed on everything.This tool was just fine before we upgraded. It opens but it is empty. We cannot see any sites associated with it so we cannot active new sites.When any .cfm file other than the default document is run on the new site (and the new site not updated with the Web Server Configuration Tool), we received this error:"HTTP Error 404.2 - Not FoundThe page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server."This seems as though it is because we upgraded from the trial version to the licensed version (In CF Administrator, New License).The 'Instance Manager' in CF Admin has the 'Name" still set to 'cfusion' and it is the only instance. We changed nothing here, in face, nothing has been ch

I have a page table that includes navigation IDs, catID, subcatID, I use an inner join for the tables.Tables:pagescategoriessubcatI have added subSubID for a third level on the nav menu. How do I add the fourth table to the cfquery?I want to add: inner join subSubcat on pages.subSubID = subSubcat.subSubID to the table below.<cfquery name="getPages" datasource="#application.database#">select *from (pages INNER JOIN catagories ON pages.cat_id = catagories.cat_id)inner join subcat on pages.subID = subcat.subIDWhere catagory = '#title#'order by pages.subID asc, pages.ordID asc</cfquery>

We installed ColdFusion 11 Enterprise Evaluation (Trial) but would like to buy ColdFusion 11 Standard to use on the same Windows Server 2012.Will we need to reinstall ColdFusion 11 Standard or will the license key/serial number work on the currently installed ColdFusion 11 Enterprise?I assume all we'll need do is enter the purchased CF 11 Standard key into the CF Admin"New License" box want to be sure first. Can't seem to reach Adobe to answer this.

Hi All,Arabic charaters are not displaying correct when migrate data to oracle DBit is showing correct when inserted from formplease let me know any settings needed for arabic display????Server info   : ColdFusion 11 entDB            : Oracle*** pls find screen attachedThanks in Advance

　Coludfusion9からColudfusion11へのマイグレーション評価で、OS Redhat 6.5にColudfusion11評価版をインストールしました。　インストールは、特に問題はありませんでしたが、起動すると、下記のログが出力されて正しく起動しません。　何方か原因と対応をご存知でしたら、教えて頂けますと助かります。---------------------------------------------------9 8, 2015 19:24:58 午後 Information [localhost-startStop-1] - logging を開始しています...9 8, 2015 19:24:58 午後 Information [localhost-startStop-1] - license を開始しています...9 8, 2015 19:24:59 午後 Fatal [localhost-startStop-1] - tmiph-web2:tmiph-web2: unknown error9 8, 2015 19:24:59 午後 Error [localhost-startStop-1] - License サービスを初期化できません : coldfusion.server.ServiceException: tmiph-web2:tmiph-web2: unknown error9 8, 2015 19:24:59 午後 Information [localhost-startStop-1] - crypto を開始しています...9 8, 2015 19:24:59 午後 Error [localhost-startStop-1] - Cryptograpicサービスを初期化できません : java.lang.NullPointerException9 8, 2015 19:24:59 午後 Information [localhost-startStop-1] - securityを開始しています...09/08 19:24:59 [localhost-startStop-1] ERROR Unable to set localhost.This prevents creation of a GUID. Cause was: t

I'm currently in the progress of moving from a CF9 server to a CF11 server, but have run into a huge performance difference between the two, when sending e-mails.Our application generates approximately 40,000 e-mails nightly, and spools the messages to disk, for delivery to out mail server.On the CF9 server, it will spool approximately 20,000 messages in an hour to our mail server, but on the CF11 server, the best I can getis approximately 800 messages an hour.  Are they any hidden parameters that I can configure to increase the speed of sending mail onCF11?Thanks,Evan

I have an object that I use to process address information.  Currently I'm instantiating per request, however, I'd like to move that into an application scope. My concern is that somehow this will adversely affect the my request or session level scope or that somehow if multiple requests occur that the request/session will crosswires somehow.

Hello, I have been trying to get websockets working in our CF 11 update 6/IIS8 server to no success.  I would love to use SSL, but as part of my testing I have even tried non-ssl with no luck. The instructions I have followed are these, Using WebSocket with ColdFusion 11 | Adobe Developer Connection.Using Chrome I see that I receive this for standard proxy configuration on a non-SSL connection, "Error during WebSocket handshake: Unexpected response code: 200." This does show as a ws connection. If I configure the builtin server and use SSL the error is WebSocket connection to 'wss://name.of.server:8543/cfusion/cfusion' failed: Error in connection establishment: net::ERR_TIMED_OUT."  The name of server is correct just removed here since I've been testing at times without firewall to eliminate that problem. I don't get where the cfusion/cfusion is derived from however. I am not sure why it isn't using cfws there that the non-ssl ones do. Port 8543 is open (even when the firewal

Good day.  Installed coldfusion10 on suse linux13.1 running apache 2.4.6.  When I created the web server connection using ,/wsconfig everything worked.  However after restarting apache I know get an error with /wsconfig /1/mod_jk.so :undefined sysmbol : ap_log_error.  I am not able to get apache running (rsapache2 start).  Any help would be great. John

Hi,I need to install Coldfusion 10 developer edition for my project, please share the download link.Thanks in advance.Regards,Ankit

Hi,I recently installed Update 17 on our Coldfusion 10 development server.  Since this server is behind a firewall the auto updater won't work and we need to download the jar file and run it manually. Usually we also end up having to temporarily rename coldfusion.exe in the bin folder.  In the past this has worked fine and then when we do the production server the updater works as it should.For Update 17 however, the coldfusion application server service would not start after the update installation. However, if I swap out the newer coldfusion.exe (8/27/2015 8:08am 426k) for the previous version (4/9/2015 6:29AM 533k) then I can start the service and the site seems to run fine.My questions are 1) Why does it not work with the newer coldfusion.exe, 2) is this a valid installation which addresses the issue the update was meant to address if I'm using the older .exe or does it not matter?Anyone else have a similar experience?Thanks!

hi, i have run into an unusual behavior when invoking web services.i am calling a web service that returns an XML like this:<children>     <child>          <firstname>john</firstname>          <lastname>doe</lastname>     </child></children>when invoking this web service from CF10, it works just fine. However, when invoking from CF11, i only get this: <child>      <firstname>john</firstname>      <lastname>doe</lastname> </child>no <children>? for some reason, CF11 ignores/hides the topmost XML level. this doesn't happen on previous versions. why? the server that hosts the web service is CF11 too.

How can I change the adobe logo to my company logo on the login page?

1. In my ColdFusion 11 website (with SQL Server 2008 R2), the following cfquery is throwing the above error:<cfquery name="deleteGrantModificationItems" datasource="#dsource#"> DELETE col_key FROM myTable WHERE col_key = <cfqueryPARAM value = "#appkey#" CFSQLType = "CF_SQL_VARCHAR"> </cfquery>2. When I run the sql profiler to capture the query, I get:eclare @7246612 int et @7246612=NULL exec sp_prepexec @7246612 output,N'@P1 varchar(8000)',N'DELETE col_key FROM myTable WHERE col_key = @7246612 ','000000001644' select @72466123. when I run the above in the Query Analyzer, I get the following error:Msg 208, Level 16, State 1, Line 1Invalid object name 'col_key'.Msg 8180, Level 16, State 1, Procedure sp_prepexec, Line 1Statement(s) could not be prepared.What could be the issue? Please help.

Hi,We have code that is creating an excel workbook with the POI library and then using CFHeader to set the filename with content-disposition as shown in the code below. After setting the content-disposition,we write the Excel workbook to the browser. The code is below. This works wonderfully in CF 9 but when we upgraded to CF 11 we found that this is no longer working. The same code works fine in CF 9 but not in CF 11. The filename is being ignored and the file is now being given the name of the cfm script being called with the correct xls extension.Any suggestions as to what is causing this in CF 11 and not in CF 9 would be appreciated.Code:<cfheader name="Content-Disposition" value='attachment; filename="#arguments.fileName#" ' >  <cfscript>             // Write the workbook to the ByteArrayOutputStream to obtain the ContentLength          local.workBook.write(loc

Currently getting the following error.  The START_DATE argument passed to the insertApplication function is not of type date.If the component name is specified as a type of this argument, it is possible that either a definition file for the component cannot be found or is not accessible.The error occurred in D:/web-sites/Web/poolDischarge/components/poolDischarge.cfc: line 5452 : <cfargument name="Mailing_State" type="string" default="#arguments.discharge_state#">53 : <cfargument name="Mailing_Zip" type="string" default="#arguments.discharge_zip#">54 : <cfargument name="Pro_Discharge" type="boolean" default="0" required="yes">55 : <cfargument name="Maintenance_Company_ID" type="numeric" required="yes">56 : <cfargument name="Start_Date" type="date" required="yes">Resources:Check the ColdFusion documentation to verify that you are using the correct syntax.Search the Knowledge Base to find a solution to your problem.Browser   Mozilla/5.0 (Windo

Anyone use this feature on coldfusion administrator yet? I tried to follow the following link Database-related enhancements in ColdFusion 10 - ColdFusion, English documentation - Adobe Learning Resourcesbut I have no luck getting it to work with Microsoft Sql Server 2008 R2

I couldn't figure out why I got this error.  I have set default var query.  Please help.  If qLocal has records then return fine, but when qLocal records is empty will throw errors.  I've set a default.<cffunction name="getName" access="public" returnType="query" output="false" hint="This method returns a query.">  <cfargument name="id_fk" required="no" default="0">   <cfargument name="id2_fk" required="no" default="0">    <cfset var qQuery = "">       <cfquery name="qLocal" datasource="#db#">         SELECT *         FROM tbl         WHERE id = <cfqueryPARAM value ="#id_fk#" CFSQLType ="CF_SQL_INTEGER"> AND id2 = <cfqueryPARAM value ="#id_fk2#" CFSQLType ="CF_SQL_INTEGER">   </cfquery>  <cfif qLocal.recordcount>   &

Hi,Noticed that there is JQuery modules in the directories with Cold Fusion 11.In the URL "http://stackoverflow.com/questions/15756532/use-jquery-datepicker"  shows using JQuery local for the date picker on the server. But it show a module datepicker.css.I cannot find the module.Does JQuery need to be downloaded in order to obtain all the modules for the datepicker?Thanks,Mike

It was working earlier today and then stopped working after I had to restart the CF service.  It is completely inaccessible.  Running:Server DetailsServer ProductColdFusionVersion10,0,12,286680Error:The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. The error occurred in scheduletasks.cfm: line 188I've searched around and can't figure how to correct the issue.  Any assistance would be greatly appreciated.