ColdFusion

Hi,I have requirement such that on server there some files for example:  text20101231, text20111231, text20121231 and text (Note: Current year file does not have any suffix in its name i.e. text is current year file).Now in UI user can select 2 dates: From Date and To Date.According to the selected date files should read in my code.For ex: if user selects From Date: 6/13/2011 and To Date: 11/31/2012 from the calender then my code should read only  text20111231 and text20121231 two files.I will also check if year in To Date is equal to current year it will read the file in which it does not have any suffix in its name.Kindly suggest how to read the concerned files based upon the date selection.Thank you.

I have a file name as below :2009 Master Calendar  (4.2.09).xlsNow how to use list funtions ie.listfirst or listlast to display the file name alone without the file ext. ie,.2009 Master Calendar  (4.2.09)

Hello;I have a problem with the security issue CVE-2002-0894 and CVE-2000-0681.We use CF 8.01 enterprise under windows server 2003 with IIS 6.0 Webserver.Our internal scans find an issue ServletExec 4.1 / JRUN ISAPI Multiple DoS.Description: By sending an overly long request for a .jsp file, it is possible to crash the remote web server. 

This problem is known as the ServletExec / JRun ISAPI DoS. Download patch #9 from ftp://ftp.newatlanta.com/public/4_1/patches/ See Also
http://www.westpoint.ltd.uk/advisories/wp-02-0006.txt No more infos.-------------------------------------------------------------------------------------------------But I can't find on the Adobe Websites or in in the CVE Database a direct link to Coldfusion or Adobe patches (ApsB xxx). No info, how to fix the finding or install the patch under cold fusion.Has anybody experiences with this topic CVE-2002-0894 and CVE-2000-0681 under coldfusion or could give me an advisory. thank's fran

I want to select "currentrow" as part of my query - I know I can loop over queries and get the "currentRow" variable, but I'm doing a QoQ before I use the rows and I want to keep the original rows, e.g.//Original query 1, Audi 2, BMW 3, Skoda //QoQ 1, Audi 3, SkodaThis is the code I've got:q = new Query( datasource = application.db.comcar ); q.setSQL(' SELECT make, @rownum := @rownum +1 AS  `rownumber` FROM cars, ( SELECT @rownum :=0 ) LIMIT 10 '); r = q.execute().getResult();But it's throwing the following error:Parameter '=' not found in the list of parameters specified  SQL: SELECT make, @rownum := @rownum + 1 AS `rownumber` FROM cars, ( SELECT @rownum    :=0 ) LIMIT 10This will work in "cfquery" but I'd like to use it in CFScript. Is there an alternative to using ":=" or some way of escaping this in the query.- Originally posted on Stack Overlfow: http://stackoverflow.com/questions/17191530/coldfusion-cfscript-query-with-mysql-assignment-operator

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f5c.html

Built-in tomcat to Coldfusion 10 is at version 7.0.23 while the current version of Tomcat is 7.0.41. Is there any current plans on updating the current built-in tomcat or do we need to ditch the built-in for the independent? If I have to switch to independent what exactly breaks?

Hello all!There are an abundance of posts in regards to storing the Client Session data in the Windows Registry.  http://forums.adobe.com/message/4302560 being the most related to my issue.  (http://www.carehart.org/blog/client/index.cfm/2006/10/4/bots_and_spiders_and_poor_CF_performance has been a handy article as well.)  However, none of them seem to behave the way mine does after ColdFusion and the application are told not to store values there.  I updated my configurations,  restarted the Cold Fusion services, delete the old session data via "reg DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Macromedia\ColdFusion\CurrentVersion\Clients", and confirm that everything is deleted.  However, after I restart the server and check that place in my registry, there's still several GB of data in there that references sessions months old.  What repopulates this?  I deleted all of it, why does it come back?  Anyone able to tell me what I'm not doing correctly?T

I have been using Flashbuilder and Coldfusionbuilder for the last few years and it has worked well. Now I am searching for the best software to create simular data centric sites for the iPad. Flashbuilder / Coldfusion Builder have the plumbing built in to attach data to charts, graphs tables etc. So far with all of the Creative Cloud stuff it seems to be for making pretty - no plumbing built in to connnect to backend database (MSSQL).NOW that my blood pressure is coming down from the data plumbing being yanked from Dreamweaver. I am not so sure it was headed for adding data plumbing for Coldfusion Components. Is there any of the Adobe CC software that is designed for database plumbing to MSSQL or should I be updating my Visual Studio????

I added a second CF instance to the CF9 server. It runs fine, but does not 'survive' a server restart. A manual restart via the jRun Launcher does not always work properly; it often takes several attempts to start the 2nd instance/jRun server. A start via the Instance Manager of the primary CFAdmin screen usually works.How do I configure the 2nd instance to automatically restart on server reboot. Is there a way to set the 2nd instance as a Service?THanks...Rick...

Hello,I have the following function:<cffunction name="stripHREFs" access="public" returntype="array" output="no" hint="seperate Links from given HTML string, output as a array"> <cfargument name="html" required="yes">    <cfset local.startpos = 1>    <cfset local.list = ArrayNew(1)>        <cfloop condition="local.startpos GREATER THAN 0">    <cfset local.linkpos = reFindNoCase('<a\b[^>]*>(.*?)</a>',arguments.html,local.startpos,'true')>    <cfif val(local.linkpos.len[1])>              <cfset local.startpos = local.linkpos.len[1]+local.linkpos.pos[1]>              <cfset local.string = mid(arguments.html,local.linkpos.pos[1],local.linkpos.len[1])>        <cfset local.hrefpos

How do I configure my ColdFusion 10 Administrator to use a proxy server to get out to the internet?  I am running Ubuntu 12.04 LTS.Thank you!

Can i downgrade CF10 to CF9

Hi,I need to generate a detached PKCS #7 signature of a file using a private key. How can this be done with ColdFusion?ThanksJürgen

Hi,I created one Directory watcher through admin and I found that it is executing more than once. Is there anything that I am missing?The configuration file is as below  ## DirectoryWatcherGateway configuration file# # The directory you want to watch. If you are entering a Windows path# either use forward slashes (C:/mydir) or escape the back slashes (C:\\mydir).directory=D:\\Balu\\changes\\9786\\Codeset\\OpportunityDirectoryWatcher\\FTPFolder # Should we watch the directory and all subdirectories too# Default is no. Set to 'yes' to do the recursion.recurse=no # The interval between checks, in miliseconds  # Default is 60 seconds# interval=180 # The comma separated list of extensions to match.# Default is * - all filesextensions=* # CFC Function for file Change events# Default is onChange, set to nothing if you don't want to see these eventschangeFunction=onChange # CFC Function for file Add events# Default is onAdd, set to nothing if you don't want to see these eventsaddFunc

I'm using an old version of farcry as a cms. It's been working fine ut now i can't get in to update and i get this message:[Macromedia][SQLServer JDBC Driver][SQLServer]Could not allocate space for object 'DBO.fqAudit' in database 'revelat_reg_farcry3' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. Happy to delete or extend my volume data limit but don't know how...What do i do...i'm desperate...Richard

If I want to count the number of failed login attempts what might be the best course of action?Off the top of my head I figure I could:Have a session variable that counts up to number X Have a cookie variableInsert the users IP address into a database table for each failed attempt and when the form loads I check to make sure there aren't X number of strikes in the last 30 minutes.It seems to me though that each of these can be gotten around. Session can be ended by opening a new browser window, cookies can be dumped and while I don't know how I know users can spoof IP addresses.So I guess this there another way to do it that is more secure? Granted none of my sites have that much traffic but I want to show that I am taking security seriously. Also I guess I should ask do people even care about this anymore? Is lockout after X number of bad attempts just an older security standard that is more inconvinient then it is useful nowadays? Thoughts and opinions are welcome by any.

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7adc.html

We first purchased the Enterprise version of CF 9, and have since purchased Enterprise 10.  Can we still use the CF9 Enterprise on a different server?

I'm building a Live Help Chat for a variety of my sites.I got the chat working on one of my sites with the client end on the site's help page and the agent side on an admin interface on the same domain which the agent has to log in to.Is there a way where I can have this Live Help Chat on my other domains and have the agent log in to one admin interface on one domain and chat with all the clients from there?I'm thinking of something like Olark where chats can be initiated from any domain and the agent can chat/manage them from an admin page.Can this be done with CFWEBSOCKET? If so, any examples or tips are greatly appreciated. If not, what good alternatives are there for CF?

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f5d.html

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec0d04c-7ff8.html

In a test environment using CF 10 Developer Edition and a SQL Server on Windows 7, I get the above error locally every time a CFQUERY specifies a username and password (if I strip those out, the page executes, but they are required on the live server). I have set the MSSQLServer to accept both Windows and SQL Server authentication and verified the DB in CF Admin. I find a few other instances of questions about this problem, but no solutions that work for me. Can anyone help?

I signed up for the REST Support in CF 10 webinar that should have started at 8:00 AM PST  today, June 18, 2013.However when I go to the link for the webinar (http://www.adobe.com/cfusion/event/index.cfm?event=track&id=2227151&loc=en_us) I am getting a message that the session has ended. Was the webinar cancelled? If so, will you be running it again at some future date?Thank you.

Hello,We currently have multiple applications written in Coldfusion 8, using Postgresql 8.4 on a server running Redhat Linux 5, and it all needs to be upgraded.  I am currently building a new server with Redhat Linux 6, and plan to put Posgresql 9 on it, and I will be moving all the Coldfusion code over to this new server.  I received a free copy of Coldfusion 10.  Will my code work on 10, or do I have to go to CF 9 instead?Thanks!Julie

I have recently installed CF10 and found that the local copy of the documentation is nowhere to be found.  It's still an installation option when you install CF, but I cannot find the folder cfdocs anywhere.  I looked in all the usual places, even did a drive search to no avail.  I have since installed ColdFusion 10 in a Mac, Linux and now Windows and none of them have the documenation locally, though all installers showed ColdFusion Documentation as an installable option.Am I missing something?  If it is no longer available, so be it, but why then is there an option during installation to install it?  I would dearly like to get it back as I relied on that on a constant basis.