Questions

The web site you are accessing has experienced an unexpected error. Please contact the website administrator.    The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request               Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-00913: too many values    Resources: Enable Robust Exception Information to provide greater detail about the source of errors.  In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.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 (Windows NT 6.1; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0Remote Address  172.27.1.11Referrer  http://emanifest.dagangnet.com.my/ems/cuscarCa

Hi,I am going to implement the directory watcher in my application. The web server is using standard edition of coldfusion. When I checked about the description of Standard edition features, I found that DirectoryWatcher is enabled in Standard edition. But it is mentioned as 'Restricted'. I didnt understand about this 'restricted'. Somebody know about this? Please advice.Thanks

Hello.Versions:CF8, MySQL 5.5.27Database record fields:, FirstAttemptByCertNumber <-- same certification number, SecondAttemptByCertNumber, ThirdAttemptByCertNumber <-- same certification number, FourthAttemptByCertNumberScenario:Web based airway management report. Four attempts are allowed per patient. An individual attempts an airway insertion and is not successful. This would be recorded in the first attempt section of the report. A different person does a second and attempt and is not successful. The first person attempts a third time and this time around is successful. So the FirstAttemptByCertNumber and ThirdAttemptByCertNumber DB fields would contain the same certification number. After the information is inserted into the DB and e-mail is generated and sent out. Client would like to have all information in a single DB recordThe goal (if possible) is to only send out one e-mail for each Certification Number in the DB record. I am able to get the last record id inserted, bu

CF9 has been installed on  Windows server 2008.Successfull.I can see CF9 files on disk C:\ColdFusion9I have the CFIDE structure installed on disk D:\wwwroot\CFIDEAnd when launching :http://127.0.0.1/CFIDE/administrator/index.cfmcan't find the fileI tried the Sever IP adress :http://85.14.138.81/CFIDE/administrator/index.cfmsame, can't find the file.Can someone help/explain where could be the problem ?It seems to be a problem of  IP pointing ?Thanks for any help.I do not have the hand on the IP.Pierre.

Using MYsql How do you find out who did not contribute to a particular fund raiser that we all just did. There are many titles to the different charities that is under the othpaytitle of the Otherpay table,  I however just want to extract the non-contributors for a particular charity title. Is there anyway to do this? When I do the the syntax below it comes up as an "empty set". The search is done by way of the table Id matching and left joins. Please see below. SELECT  moiid, trim(concat(name.fname,' ' ,name.mname,' ',name.lname)) as Brother, name.moiid as Members_ID, sum(otherpay.othpayamt) as NO_Contribution, quadlt.ltfname as quadFROM name  LEFT JOIN OTHERPAY  ON name.moiid = otherpay.othpaymoiidLEFT JOIN quadlt  ON name.quadlt = quadlt.ltidWHERE  Otherpay.othpaytitle like '%food drive%'AND otherpay.othpaymoiid IS NULL AND name.type = 'BOI'AND name.type <> 'jrboi'AND name.city = 'SUFFOLK'GROUP BY brotherORDER BY name.quadlt, brother

I am having trouble getting the coldfusion service to start after a server reboot.  The service was working prior to the reboot and the only thing that changed was an update to the application hosted on the server.The server setup:Windows Server 2008 R2Coldfusion 9.0.1 (multiserver)Java 7 update 13Jrun 4The error message I am seeing in all the log files is 'Error loading: C:/Program Files/Java/jre7\bin\server\jvm.dll'.Nothing has changed with Java or Jrun since the reboot, so I can't quite put my finger on the actual issue.We have tried rebooting the server, updating Java with no success.Any thoughts on what it might be?

I have an application that has been stable for a couple of years now and today  a couple of our ajax calls are redirecting to  cf administrator log in?any have this happen??running CF10 u10  on win server 2k8 r2 as a virtual machinehave reviewed the code and there have been no change to this production code since the beginning of the year.

I can login to Administrator just fine but when I try to submit anything I get an error and it makes me login again... a vicious circle.  This was working, not sure what changed. Today I tried to do the download and install and received the following error:Additional info: -1 : Unable to display error's location in a CFML template.I have ColdFusion 10 with patch 8 installed.  Any help would be greatly appreciated.  Being new at this not sure what I messed up, but don't want to reload because I have a lot of changes that were entered through Administrator when it was working properly.Bob

Hi allDoes anybody use the ESAPI validator in CF9.How to use the customized the validation.properties file for the my own application?Thanks

In theese days i receive a intrusion trought this directory. my antivirus says the a virus is present in this dir and remove it.i try to lock and disable CFIDE from external ip and domain.how i can lock this type of attack ?all patch are inserted until 8/03 on CF 9.0.1thanks a lot

Hi!  I'm new at this, so forgive me if this is a silly question.I have installed ColdFusion 10 and ColdFusion Builder 2 Update 1.  I have a whole lot of files residing in various folders that I have copied onto our development server where ColdFusion resides, and need to import them to a project or create a new project with them so I can edit them in the ColdFusion Builder (did I say that right?)The problem is, when I import or start a new project, all the files do not come over.  When I add it using a linked folder, and try to run the index.cfm page, I get "Selected file is not in the document root of the server.  If the project is not in the document root, created a linked folder to the document root (selecting Project Properties > ColdFusion Project).I believe I have already created a linked folder by going to linked folders for the project.  I can see all my files and folders on the left.  When I go to this dialog area, I see my linked folder, but I

I need to update my SQL database at the end of each day for certain records.The time needs to be 9:00 PM each day (dont worry about time differences)So for today  I need to insert '2013-06-21 21:00:00' into the db.So I wantd to set the time before I inserted it.How do I do that?<CFSET mytime = ?>How do I get 9:00 PM each day?

Hi,I have the query results and try to dump it into csv or txt file but have troubled with data because lot of stuffs from description field.  Excel is the only solution but when i click on the excel link and click OK button,  i got this message below"the file you are trying to open, excelReport.xls  is in a different format than specified by the file extension ......"After clicking on Yes the file opens properly, but i don't want this msg to appear.i have MX Excel 10 and coldusion 7, is there the way to get rid of message?<cfcontent type="application/msexcel"><cfheader name="Content-Disposition" value="filename=BrightIdea.xls"><cfloop query="variables.qReport">....</cfloop>Thanks

Hi All,I am trying to install either ColdFusion 9 (which is where company is using) or 10 (if I can't have 9) on my Mac 10.8.6. When I click on the dmg file, it shows a running bar and once it's completed, i see a standard installation box (the one you click "agree" "nect" etc...) except there is nothing showing on the box. There is a blue "next" button but I can't click on it. This happens to both ColdFusion 9 and 10 installation. With 9 though, I get a centaur_err file. This is very urgent as I cannot work without ColdFusion. I would really appreciate your suggestions.Thank you,Jennfer   

Windows workflow foundation is a technology that provides an in-process workflow engine, and a rehostable designer to implement long-running processes as workflows within .NET applications. If there an answer to this in Coldfusion?

I 'm running CF 9.0.2 on a Win 2008 R2 server. I recently installed the hotfix for APSB13-13, which seemed to go fine. The next day I can no longer get into the CF Admin site, though the other pages continue to work. The error message reads:HTTP Error 500.0 - coldfusion.server.SecurityService.removeAuthenticated()VThe page cannot be displayed because an internal server error has occurred.I have tried to back out the hotfix and even recover from backed up CFIDE and CF9 diretories but the error remains. Aside from a full re-install, anyone got any ideas what I shoudl try next?Thanks.

Hi, we are looking to upgrade to ColdFusion 10 soon and would like to know if serving JSP pages is still an Enterprise-only feature or if the Standard edition does so now as well. Thanks!

I'm working on Cold Fusion 8 which is located on local network(Ms Windows Server 2003 R2) on my work place. I am using Dreamweaver CS6 for creating "cfm" files and connected to the local server by creating a new site and mentioning local IP and all other details.My cold fusion files are running fine. I tested it. I have another IP where MS Windows Server 2003 is installed and MySQL 5.5 is installed there. What I'm trying to do ?I'm trying to run some SQL queries using "cfquery" tag of cold fusion. For this I will need to see the list of "datasources" which are present in the "Adobe 8 Coldfusion Administrator". But I'm unale to figure it out how would I be able to see the list of all the data sources in the Database panel of Dreamweaver? I need to have this list otherwise I think I won't be able to retrieve data from the database and run SQL queries. Please let me know if someone knows any way out.Thanks

If I upgrade from 8 to 10, do I need to make the upgrade install of can I just plug in the license key on top of the trial version we are testing?

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?