ColdFusion

Could anybody tell me if there is a maximum number of sessions that can be active at any time and if so what that is and if it is effected by factors such as memory?This would be on a Windows Server 2008 64bit, with 4gig of RamThanksMark

Can be Cold Fusion Developer Edition used to develop the product and deliver to client?

I applied my Enterprise license key but the server shows Developer on clean install Win 2012RC2 64bit cloud svr with 4 CPUs and it said it was successful. After entering the license on install, I followed the suggestions here and put the key directly in license.properties, restarted CF, but it still shows Developer and watermarks appear.The vendor is trying to help resolve this issue as well and they have had so far no luck.I can send my key if someone an look into it

Hi All,In one of my application I need to generate report in Excel file where data contains huge,more than one lakh. Currently I am querying this from database and looping through a cfoutput tag to write data into an excel sheet. But the problem with this method is Timeout issue or java heapsize is very less.I think this is a drawback of coldfusion to write data in to Excel sheet. Right?? .  In this time we need to depend on Java to write huge data into Excel sheet. Why we cant achieve this in ColdFusion , eventhough CF is built on Java platform.Any one have any suggestions or any thoughts on this.Please share.Your timely help is greatly appreciated.Thanks in advance.

Is it possible to extract a substring in the WHERE clause of either <CFQUERY> or in a Query of Queries?  I am trying to use the following query to find all email addresses with the domain "comcast.net" (i.e. everything after the "@" in the email address).  I am querying an MS-Access database table. <cfquery name="test" datasource="membership">      SELECT email_address      FROM tblMembers      WHERE MID(email_address, INSTR(email_address, '@') + 1) = 'comcast.net' </cfquery>If I attempt this as a query, I get the error message "[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression."If I attempt it as a QoQ, I get the error message 'Encountered "MID ( email1 ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,'.I would be very grateful for any help on finding some

I have a page with multiple CFTrees.  Is there a way to determine via javascript if a targeted CFTREE is done loading content?

Hi CFers,Anyone know how I can block the user to which the same answer the survey satisfaction only one once?IP address or COOKIE, what is the better way to do?P.S. records in the XML file no DB.Tks,Fabiano Magno Pechibella

We need a user definable spreadsheet for use in our web app. We need to be able to allow the client to set up the spreadsheet, create the calculations, formatting, rounding and decimal places, and then save all to a database.Is there something like this out there for ColdFusion?Thanks.-A-

I am trying to connect to SQL Server 2012 with flag MULTISUBNETFAILOVER=TRUEI have created the DSN and it works fine for some time and next day i will get the below erorr. I have verified the DB server and its up and working fine and able to connect to it from management studio. Once I restart the server the issue get fixed. Does any one had any idea on why this issue is happening. I am using the sqljdbc4.jar for this connection.The root cause was that: java.sql.SQLException: Timed out trying to establish connection

I have a CFC that returns (via ajax) an array with a length anywhere from 1 to n. I need to display the contents of that array on a webpage in a table (one row per array element). Since I do not know the length of the array, what would be the best way to render the table? My first thought was to build the table inside a string variable and then use jQuery's html() method. I also considered using ColdFusion to format the table in the CFC and pass that back to the ajax call. Either way seems very tedious. Was wondering if there is a better way.

Hi fellows,I have a survey of satisfaction and desire that the User meets only once. How can I do this? Can I use cfcookie? More like do?Tks,Fabiano Magno Pechibella

Recently I installed ColdFusion 11 Developer version (on Windows 8 & IIS) to test the migration of a CF9 based website that uses Oracle as its underlying DB. 1 of the first problems I encountered are the PLSQL stored procedures that seem to be very slow, like 10-50 times slower than with CF9. So I did a test where I execute the exact same SQL statement, which returns ~11000 rows, with both cfstoredproc and cfquery. The processing time of the stored procedure is 111645ms while the processing time of the cfquery is 362ms. The query doesn't return any (C)LOBs, per row there are 4 columns returned, 3 having a number, 1 having a varchar2 with a max size of 256 characters. I uninstalled CF11 several times but everytime I get the same results, no matter what I try in the CFIDE. Maybe I'm missing something obvious here, but for now I don't see it...

So as the title says, I can't log into the Administrator and changing the password via Coldfusion10\cfusion\bin\passwordreset.bat doesn't seems to be actually changing the password since I still get "invalid username/password" when I try to log in after resetting the password.Even further, I used the old method of altering neo-security.xml and changed "admin.security.enabled" to false. This DID allow me access to the administrator, but even then, when I enable password protection and reset the password from the administrator, I still am unable to log in!!One detail which may be a clue for solving this problem: when CF was installed, it was set to not use the default "admin" username. When I try to log in though, I try with both "admin" and the custom username with no luck.Any ideas on how to fix this? It seems like the password encryption system is broken and storing the reset password hash wrong or something.... EDIT: Forgot to mention that I restart the service after resetting the pa

Is this possible ?Installation of CF9 32 bits on Win7 64bits ?I did it, with CGI and ISAPI for IIS7.IIS 7 is OK, (http://127.0.0.1  is correct)After CF9 install, I ran the WebServer ConfigurationToolhttp://127.0.0.1 gives an error 500 :then I uninstall C F9 , now I have a 404.2 errorI looked in install recommandation on the web (google).I think I did the right way.Then I am wondering if this is a question of 32bits and 64 bits ?Thanks for urgent Help.(I have an other PC with CF9 32bits on Win7 32bits, it is OKand a CF9 64bits on Windows serveur 2008 64bits, it is OK)Pierre.

How do I determine how many CF licenses I need in a virtual server environment?   Is it determined by the main server or is it based on how many cpu's are allocated to each virtual server?

Hi,Can I use ColdFusion 11 Enterprise license on ColdFusion 10? Do Adobe CF have downgrade privilege option from CF11 to CF10? Thank you.

We have a .Net CMS and have been asked if we can integrate a ColdFusion application into it, does anyone know if that is possible.Thanks,Paul

When I click on "File Search" the search box appears, I enter the search criteria and it finds nothing. I have installed a standalone search product in the meantime but it's a real pain to get out of builder, run the search, and then pull up each file to make changes. Any idea what this problem might be?

To debug I want to see what variables are in the attributes.  I can't figure out the instructions for CFDUMP.  Any help appreciated.

Need the steps to enable SharePoint 2010 Secure Store Service to authenticate single sign on with a ColdFusion 11 app and display the ColdFusion app in a SharePoint webpart.On this page Adobe - ColdFusion Support Center : More DownloadsColdFusion 11 SharePoint Integration WebpartsThe ColdFusion 11 SharePoint Webparts allows ColdFusion applications to be displayed as a webpart in SharePoint.Download Sharepoint Integration Webparts (ZIP, 13 KB)The Readme in the zip file only provides the steps for SharePoint 2007 and 2003.  I'm looking for the steps and needed files for SharePoint 2010 with Secure Store Service since Single Sign On is no longer used. This other page Integrating ColdFusion applications with Microsoft SharePoint using ColdFusion 9 | Adobe Developer Connection is for older SharePoint versions not 2010.Thanks in advance.Doug

I have just decided to set up my site using ColdFusion clustering in the staging environment. I need to find out what code adjustments are required when we move to a cluster environment. I have two machines where Coldfusion server is installed. Till now Steps I followed:On CFServer_1 I have created a instance.(cfinstance_1)On CFServer_2 I have created another instance. (cfinstance_2)On CFServer_1 I have created a Cluster using these two instances.Now on CFServer_1 I have created a IIS site(testsite.com) pointing to my codebase.Now On CFServer_1, Using the Web Configuration Tool I have associated testsite.com with the cluster.Now my question is Do I also need to set up the code base on the second server(CFServer_2), Create a site in IIS with same name(testsite.com) and associate the site with the cfinstance_2?

the university where I work just updated their Oracle test database to a new version and now my clob fields don't display in coldfusion.  I have code to add to the query to capture the first 4000 characters, but what do I do about the few records that contain more than 4000 characters? We need to resolve this before we upgrade the production database...   Have  coldfusion developers addressed this issue with the new Oracle upgrade?

Why does this work?<cfset projectList = Application.Projects.getProjects(CompanyID=request.User.CompanyID)>BUT, this throws an error?(Could not find the ColdFusion component or interface Application.Projects)<cfinvoke component="Application.Projects" method="getProjects" returnvariable="projectList"><cfinvokeargument name="companyID" value="#request.User.CompanyID#"></cfinvoke>I understand that cfinvoke is trying to look for an 'Application' directory, correct?  The Projects.cfc is located within a directory names 'sys'.  Would it be a better idea to use:<cfinvoke component="sys.Projects" method="getProjects" returnvariable="projectList"><cfinvokeargument name="companyID" value="#request.User.CompanyID#"></cfinvoke>Basically, is the above the same as:<cfset projectList = Application.Projects.getProjects(CompanyID=request.User.CompanyID)>

We have switched to using CFWindows for our modal dialogs in our application.  While we have debugging turned on for our IP addresses, and the debugging information shows up just fine on normal pages, nothing appears in cfWindows. Today I went about trying to recreate the debugging information and manually write it out to the window HTML. I began by using the following code in onRequestEnd, which worked fine on pages called normally:<cfset tempFactory = createObject("java", "coldfusion.server.ServiceFactory")><cfset tempCfdebugger = tempFactory.getDebuggingService()><cfset qEvents = tempCfdebugger.getDebugger().getData()>After taking the time to format the output as desired, I finally tried this on a cfWindow. However, I received the following error on the third line of code:Detail  Its possible that a method called on a Java object created by CreateObject returned null.ErrNumber 0Message   Value must be initialized before use.This implies that it'

Hi! I have a tag called #PubsPageLink# that contains an href link, but I want the #title# tag to use that same variable, as well. Obviously, using... <a href='http://#PubsPageLink#'>#title#</a> ...is too simplistic an approach. But what would be an effective way to grab that href variable and apply it to separate tag?#PubsPageLink# is currently setup to output a text link that reads "Read More..." <cftry><CFQUERY NAME="Pubs" datasource="Library" maxRows="4">SELECT citation, title, journalName, PubsPageLink, Year(FROM_UNIXTIME(Pubs.datePublishedConfirmed)) AS DateFROM PubsORDER Pubs.DatePublishedConfirmed DESC</cfquery><cfoutput query="Pubs"><cfif #citation# is not "">                    <strong>#title#</strong> | #PubsPageLink# <em>#journalName#</em> #date#<br><br></cfif></cfoutput><cfcatch></cf