ColdFusion

Anyone out there using JasperReports with Coldfusion 8? cfdocument and cfReport have such a performance hit on our box when we try to run certain reports. IE - Report Cards We need something that would be able to run 100+ pages of dynamic data quickly and efficiently. If anyone has any suggestions of what we could look into or how to get Jasper up and running I would appreciate any help. Thanks. Becky

Hello,We have been installing CF 9.0 to IIS 7 on a new server for the first time. The installation was working fine until we tried to install add-ons such as the CF 9.01 installer or a Java JDK. After one of these was installed, the CF 9 application server would not start. We got a message saying "Windows could not start the ColdFusion 9 Application Server on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 2."We reviewed the System Event logs and found error logs saying "The ColdFusion 9 Application Server service terminated with service-specific error They system cannot find the file specified." The error did not state what file that is.We tried uninstalling and re-installing CF 9.0 a handful of times and then applied either the 9.01 installer or JDK. We continued to get above error message when trying to start services.Has anybody experienced this issue before?

Hi,I have couple table with join query and they are from the diffrent database server.  How can I do this? look at the example below.<cfquery name="getall"> select *    from tbl1 inner join tbl2    on tbl1.saleID = tbl2.saleID</cfquery>tbl1 is from server1/Database1 and tbl2 is from server2/Database2Thanks

Hi,Is there a cold fusion function that checks the complete date (mm/dd/yyyy) against another compelete date (mm/dd/yyyy)?I have used the DateCompare but it only checks the month, day or year depending on the precision being used.Thanks,Mike

Hello, everyone.Quick question.  In CF9 Server Admin, if I use the Admin to create a collection, is there a way for someone else to see the details for that collection (ie, what folder(s), filetypes, etc.)?I have not yet found how to do this.  We have a collection, but it was created so long ago that no one remembers which directory(ies) or what file extensions it is indexing.  We may need to rebuild it.Thank you,^_^

I would like to know do I need enable IIS on Windows to install CF 10.IIS is diabled by default on Windows system.I see that C:\ColdFusion10\cfusion\wwwroot folder exists after install CF10.I just wonder can I just use cfusion\wwwroot folder without enable IIS on Windows.Your help and informtion is great appreciated,regards,Iccsi,

We are migrating some websites onto a cloud infrastructure running Windows 2008 virtual machines.  These websites all run on ColdFusion with MySQL databases.  They currently are running in our CoLo with no problems.  Additionally, they are running on our development network in our offices with no problems.We are setting up our cloud to match as closely as possible the configuration we currently use which is, essentially, CF10 + IIS on one server and MySQL on a separate machine.  We are 99% finished and most things are running great.  However....We have run into a couple, as in 2, places where we click a link/button and are greeted with:Error Executing Database Query. Communications link failure The last packet successfully received from the server was 0 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. Scanning the stack-trace I also find: `Caused by: java.net.SocketException: Connection reset`The communications link erro

HiWhen I log into my CF Admin (CF10) the little alert says I have 2 updates to apply, so I run the updater, get the confirmation messages that it's updating and when CF restarts and I log back into CF Admin the same alert says I have 2 updates to apply. I've not gotten any error messages and only confirmation messages that the updates were succssful, any ideas?Thanks in advance,Rich

I have coldfusion 10 running on IIS 7.5. The websites are protected by SiteMinder web agent. When a user makes a request, IIS sends the request to Siteminder which adds custom value (e.g., sm_user) to the header. I can see the values in IIS but when this request is redirected to the application via the coldfusion 10 isapi_redirect.dll file, the user is denied access and the user value is missing. Looks like isapi_redirect.dll is stripping off the user information due to which the user is getting access denied messages. I have checked the version of isapi_redirect.dll file which is 1.2.32.Any help is greatly appreciated.

Hello!  I am using Coldfusion 9 as well as the current version of MySQL.  My current query is throwing an error:<CFQUERY NAME="getmemgal" DATASOURCE="#ds#">SELECT usrid, usrmem, usrlogin, usrastro, memid, memlast, memfirst, memend, memlifeFROM usr, memWHERE usrmem LIKE memidAND usrastro LIKE 1AND ( memlife LIKE 1 OR CreateODBCDate(CreateDate(memend+1,1,15)) > CreateODBCDate(Now()) )ORDER BY memlast, memfirst</CFQUERY>Right now, the database stores the most recent year for which dues are paid as an integer, in "memend".  This query gives the members a 15-day grace period before their member photo gallery stops showing up on the site.  This means that a member who last paid for 2012 will have until January 15, 2013 to pay their dues.  Hence this part of the query:AND ( memlife LIKE 1 OR CreateODBCDate(CreateDate(memend+1,1,15)) > CreateODBCDate(Now()) )So you can see that their membership expires on January 15 of the year following the end of th

Hi, hope somebody can help!I'm running an evaluation on the new Coldfusion 9 and  trying to use the <CFFTP> tag to connect to a remote SFTP server. The server version is:-SSH-2.0-OpenSSH_4.7p1 Debian-8ubuntu1.2My Code is:-<cfftp action = "open"username = "myusername"connection = "MyConnection"password = "mypassword"server = "myserver.com"secure = "yes"><p>Successful: <cfoutput>#cfftp.succeeded#</cfoutput><cfdump var ="#MyConnection#" label="connection">This is what is returned:-An error occurred while establishing an sFTP connection.Verify your connection attributes: username, password, server, fingerprint, port, key, connection, proxyServer, and secure (as applicable). Error: Session.connect: java.io.IOException: invalid data.The error occurred in /Applications/ColdFusion9/wwwroot/test/sftp.cfm: line 1210 : 11 : server = "10.1.3.43" 12 : secure = "yes"> 13 : 14 : <p>Successful: <cfoutput>#cfftp.succeeded#</cfoutput> Resou

I am a newbie, limited Coldfusion.I have a very large form with 33 dateField entries.I am working towards being more modular and trying to have only one place to edit items.I have a new patient form that post to a new patient PARSER page.(our server is now using Coldfusion 10)I edit in Dreamweaver CS6I was wanting to use something like this:        <!--- this controls all date output --->        <cfparam name="#form.*Date# = dateModOutput">        <cfparam name="dateModOutput = DateFormat(form.*Date,"mmm/dd/yyyy")">The form.*Date would effect ALL DATEFIELD entries in the formsuch as...#CTScanDate##MRIScanDate##BoneScanDate#and so on...Any code that would effectively do this is fine.My boss said it can't be done... but I believe anything is possible and that this is probably very simple and easy.Thank you for any and all help!I am really starting to enjoy Coldfusion

Our developement server is not connected to the internet.  We cannot upgrade our production server until we are sure everything works on the new version.  Where are the CF10 updates posted for off-line updates?  The only one I can find for downloading is the CF10 Mandatory Update.

I am trying to get the following union query to process on my coldfusion site:<cfquery name="committee_record"         datasource="AS400a CMTLIB"         maxrows=100         dbtype="ODBC">SELECT MBRESMPF.MBMID,     MBRESMPF.MBCYR,     MBRESMPF.MBCCD,     MBRESMPF.MBDCD,     UCase(COMITEPF.CMNAM) AS COM,     MBRESMPF.MBMRC,     UCase(RANKSPF.RKDSC) AS Rank,     MBRESMPF.MBRPT,     MBRESMPF.MBESC,     MBRESMPF.MBERP,     UCase(DIVISNPF.DVNAM) AS DIVFROM MBRESMPF INNER JOIN RANKSPF ON MBRESMPF.MBMRC = RANKSPF.RKCDE LEFT JOIN COMITEPF ON MBRESMPF.MBCYR = COMITEPF.CMCYR AND MBRESMPF.MBCCD = COMITEPF.CMCCD AND MBRESMPF.MBDCD = COMITEPF.CMDCD LEFT JOIN DIVISNPF ON MBRESMPF.MBDYR = DIVISNPF.DVDYR AND MBRESMPF.MBDCD = DIVIS

I'm currently running CF 7.0.0 server. Can I still get it updated to CF 7.0.2? I could not find the update anywhere in this site. Please help me with this.

CF10 64bit  Apache connector (mod_jk.so) does not work for Apache2.4.3 (win64), where can I get a module that works?I get this error from Apache :C:\www\Apache2.4\bin>httpd -thttpd: Syntax error on line 741 of C:/www/Apache2.4/conf/httpd.conf: Syntax error on line 2 of C:/www/Apache2.4/conf/mod_jk.conf: Cannot load C:\\ColdFusion10\\config\\wsconfig\\1\\mod_jk.so into server: The specified procedure could not be found.I have already tried manually extracting the pre-built mod_jk22.so from the wsconfig.jar with same results.If I switch to Apache 2.2.22 64bit, it does work.  what I need is to be able to run on Apache 2.4.

I'm currently running CF 7.0.0 server. Can I still get it updated to CF 7.0.2? I could not find the update anywhere in this site. Please help me with this.

Hi,I posted this on the bottom of a different discussion I posted (Passing two URL variables) where my problem was solved.  But now that I know how to pass two URL variables, I'm having trouble putting one of those variables to use. I'm working on a page like this:     http://mymindsnotright.com/discussionGenReplies.cfm?post_id=22and i'm trying to set it up so, when I click a 'post reply' link, an email is sent to the original poster and the person whose reply you clicked 'post reply' on.  The idea was to use URL variables, so (as you  can see on the page i linked above) when I click a post reply link, the user_id of the person who posted the reply that i'm replying to shows up in the URL like this:     http://mymindsnotright.com/discussionGenReplies.cfm?post_id=22&user_id =4#replytestbut for some reason the user_id in the URL isn't being used and instead it's just using the information from the first row in the table--even tho

I have a form with simple IF (field not blank) output field ELSE output   structures.  In the middle of processing them, ColdFusion starts skipping the CFELSE parts of these structures.ColdFusion 10.I don't see anything wrong with the code.Anybody know what's going on?Nathan Manning

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSd8001ae4abdbd911-5c900a4e1350d8b2511-8000.html

I would like to know does ColdFusion has data aware control like data grid view, data details view controls to show many records on the same control.Your information and help is great appreciated,Regards,Iccsi

I am incorporating CFWindow and coldfusion.window functions into my site and have them working very well except for one issue.  I would like to execute some javascript after the cfwindow fully opens but everything I am doing appears to execute after the popup appears but before the coldfusion page loads into the new popup.I have tried ajaxonload(), javascript onload, $('#docload').ready(function(), ColdFusion.Window.onShow('mywin'); etc.They all seem to execute before the actual end of the loading process.Is there a way to execute javascript after the page is completely done?  Any help on this would be greatly appreciated.

I have an Insert Form like so:with <form method="post" id="form2" action="<cfoutput>#Request.KT_escapeAttribute(Request.KT_getFullUri())#</cfoutput>">        <input type="submit" data-mini="true" name="Insert1" id="Insert1" value="OK" />I also need to run the following Update Query if the User clicks on OK..---------------------------------------------------------------------<!--- Update the Status to Rejected in the tbltickets table --->      <cfquery datasource="care">       UPDATE tblticketsSET ttstatus=<cfqueryparam value="Rejected" cfsqltype="cf_sql_varchar">WHERE ttNum=<cfqueryparam cfsqltype="cf_sql_varchar" value="#url.id#">  </cfquery>- If I add this second query in the head of the page, it runs fine..- But I need it to only run when the OK button is clicked, not when the page loads..

So I discovered the synchronize option in my file explorer today (CF Builder 2), and I accidentally set up a synchronized connection that I don't really want.  How do I remove this connection?  I can't seem to find the remove option anywhere.Thanks,Eric Cobbhttp://www.cfgears.comhttp://www.ncfug.com

Coldfusion is automatically restarting, a lot. It comes in waves, everything seems fine for a while then the server struggles for a few minutes, restarts a lot then settles down again.I have Fusion Reactor installed, but when CF goes down FR stops logging so it's not really helping. Looking through the archived logs just shows gaps in the logs.These are all the occourances of the phrase "Coldfusion started" today.    [root@server2 logs]# grep -i "Coldfusion started" server.log | grep "11/27/12"    "Information","main","11/27/12","01:49:35",,"ColdFusion started"    "Information","main","11/27/12","01:50:46",,"ColdFusion started"    "Information","main","11/27/12","01:52:39",,"ColdFusion started"    "Information","main","11/27/12","01:54:08",,"ColdFusion started"    "Information","main","11/27/12","01:55:12",,"ColdFusion started"    "Information","main","11/27/12","01:56:29",,"ColdFus