ColdFusion

I am new to Cold fusion in fact this is the first time I have ever heard of it.  I have a customer with an old NT machine running Cold Fusion Workshop 3.1 and Microsoft Access 97.  They querry the data from another machine with some forms in the .cfm format.  I need to duplicate this on a new Windows 7 platform using the latest version of Cold Fusion and a newer version of Access but using the old .cfm forms.  How do I find the tech support I need to make this happen?

I have a char that has Students Class Scores in each class.  So in this example, we have 50 kids in each class.  I want to create this Chart and show each student the report for them.Meaning using this same Chart for each student, but Place an Arrow Above each series that the Students Score is within.  So it will look like 6 classes with Honors, Pass Fail Bar chart side by side for each class but is Joe is a Pass then place an arrow each bar the Joe's grade fell into.<cfchart format="html" showLegend="false" chartwidth="800" chartheight="300">          <cfchartseries type="bar" seriesColor="red" query="honor" valueColumn="count" itemColumn="class" serieslabel="Honors">          </cfchartseries>          <cfchartseries type="bar" query="pass" valueColumn="count" itemColumn="class" serieslabel="Pass">  &nbs

Hello, everyone.I recently returned to a job I previously had after several months at a different job.  Upon my return, I inherited someone else's dev system (my previous dev system, apparently, had been reimaged and given to someone else, after I left.)This system originally had CF9 server on it (the ColdFusion9 folder is still here) and now has CF10.  Using the built-in web server (no IIS, no Apache.)Every time I boot/reboot the system, I can see in Computer Manage System that CF10 Application Server is, indeed, running.  But if I try to open any of the pages that I am working on, I get an error message that the site can't be found.I go into Computer Manage System, go to Services, right-click the CF10 Application Server, choose "Restart", wait for it to finish, and voila!, I can get a working page.Does anyone know why this is happening, and/or how to remedy it so that CF will work immediately after boot/reboot without going to restart the service?Thank you,

Hi all,My firm recently upgraded to all new CF 10 servers (clean install no upgrade), and we are going through testing before we launch them in production.I have come across an issue where the sessions are not being maintained across requests.The application login functionality no longer works at all... testing the same code on CF9 yields expected and desired results.----------------------------------To test, I created a folder with an Application.cfc and an index.cfm.I placed a copy of the folder on the root of both the CF9 and CF10 servers.Loaded the index.cfm page on each and then just hit the refresh button on the browser.All the index.cfm page does is dump the session & cookie scopes.RESULTSCF9:- SESSIONID stays the same upon each requestion- CFID stays the same- CFTOKEN stays the same...as expected resultsInitial Page Load:structsessionid8430fefbf6988bab4bbc3724627d6a323351urltokenCFID=64848&CFTOKEN=25813868&jsessionid=8430fefbf6988bab4bbc3724627d6a323351usernameBills

Hi,I am have an issue with trying to verify the database connections from Cold Fusion administration to the MS SQL Server 2008.The two servers were fully backed up from a production environment and placed on two VM servers. The SQL Server had a DC connected to it but it was removed and the services were reassigned to another account by the DBA.All SQL Server services are up and running.The Cold Fusion services are up and running.The port from the Cold Fusion server to the SQL Server has been opened.I have stopped and restarted the Cold Fusion Services.Below is the information about the environment and error received:EnvironmentSQL Server:SQL Server 2008 R2 EnterpriseCold Fusion Server:Cold Fusion 9 EnterpriseWhen trying to verify the database connections from the Cold Fusion administration to the SQL Server the following message appeared:Connection verification failed for data source: BUS_ULTC_TRAININGjava.sql.SQLException: Timed out trying to establish connectionThe root cause was tha

I have a form that captures date and time in 2 separate fields data and time. I need to combine these fileds and UPDATE a SQL database (datetime field)The date field is passed like this  DSDATE={ts '2013-11-18 00:00:00'}The time field is passed like this   TIME_IN1=14:05How do I concatenate DSDATE AND TIME_IN1 so that I can insert like this 2013-11-18 14:05:00.000 ?

I have urls that have been changed and I need to relocate users to the new url.I have been using this code.  <cfif PATH_TRANSLATED CONTAINS "C:\inetpub\websites\mywebsite\abc\"><cflocation url="http://www.mywebsite.com/newsite/abc/#pagename#"> </cfif>This code works but anytime I add a new page to newsite I also need to add a copy of the page to the old site or a get a 404 error. Is there a way I can say if a user comes to my site to this url  http://www.mysite.com/abc/thispage.cfm that they can be automatically redirected to http://www.mysite.com/newsite/abc/thispage.cfm?Basically redirect to the pagename in the new directory without having the page at the old location also.

I have a scheduled task that performs a data transfer. It's setup to run daily at 10:00PM. It hits a public CFC method, runs the task, and sends a success/fail status message via email. Everything works great except the fact that it runs at random times. It always runs on schedule at 10:00PM, however it usually will run a few times randomly through-out the day.It's really confusing me. I tried to delete the task and create it again, but I still have the same issue. I've attached a screenshot of my settings for this task.Anyone have an idea what would cause this? I want to try booting the cf service, but its a live server so I want to rule out other possibilities first.

Sql 2012 and Coldfusion 10We have read through the following guideshttps://wikidocs.adobe.com/wiki/display/coldfusionen/Data+Source+Management+for+ColdFusionhttp://helpx.adobe.com/coldfusion/kb/import-certificates-certificate-stores-coldfusion.htmlUpon enabling SSL encryption on the SQL server, we are able to connect to the datasource with this connection string:EncryptionMethod=SSL; ValidateServerCertificate=false;**some of the information below has been anonymized for security purposes**When enabling server validation, the connection begins timing out. We have imported the SQL certificate into the keystore using this commandC:\Program Files\Java\jre7\bin>keytool.exe -importcert -alias cstvnetsql9 xxx.xxx.ucf.edu -trustcacerts -file cstvnetsql9xxx.xxx.ucf.edu.cer -keystore cacerts -storepass changeitHere is the ConnectionString we are using now:EncryptionMethod=SSL; ValidateServerCertificate=true;TrustStore="C:\Program Files\Java\jre7\lib\security\cacerts";TrustStorePassword=change

I've got Coldfusion 10 with all of the updates applied and I'm having problems sending email with the CFMAIL tag.  It seems as though the spooler just won't send any emails that have a single quote in the address.  Any thoughts on how this could be solved?

michalsarl@aol.com impossible to connect to 127.0.0.1 after installing coldfusion 10 on windows 7 pro 64 bitsColdFusion 10 Net service runningColdFusion 10 Application server runningColdFusion10JettyService running

OK, so, I know it's Beta, and there just may be a bug to this, but ever since I installed it, no matter whether I was running HTML or CFML without an application.cfc (and even with one where my application/session timeouts were set to 2 hours), I have this issue where if I do not perform any activity for about 5 minutes, the next time I reload the page, I have to wait what seems like the initial 10+ seconds you do the first time you fire off making a request to the CF server when you boot the PC (ie, it acts as if the service is stopped).  My services are currently:ColdFusion Splendor Beta .NET Service (Stopped / Manual)ColdFusion Splendor Beta Add-on Service (Stopped / Manual)ColdFusion Splendor Beta Application Server (Started / Automatic)ColdFusion Splendor Beta ODBC Agent (Stopped / Automatic)ColdFusion Splendor BEta ODBC Server (Stopped / Automatic)If anyone has some suggestions, I'm glad to try them out. I've been going over a refresher course on jQuery, and reading some, wr

I just applied CHF4 to CF9.0.1 and I get a blank web page when I get to the CF admin site, http://localhost/CFIDE/administrator/index.cfm after I started CF server service.It is multi-instance server, and this is the second time, I applied the patches.  I had to back out last time, and it was working fine without the patches.  So, how do I go about getting the admin page back WITHOUT backing out.  I still have two security patches to apply after this hot fix.

I'm using the following:ColdFusion: 8,0,1,195765Edition: StandardOperating System: Windows 2003Java Version: 1.6.0_20I have a batch process that queues file upload requests by sending messages to a CFML (asynchronous CFC) gateway.I get the following messages repeatedly in my eventgateway.log:Problem adding event for gateway Amazon S3 Gateway Service: Queue size of 10 exceeded when attempting to add more assignments into the threadpool task queue.I have the same batch process and gateway cfc on multiple servers.  During the batch process, I will queue up many requests, somewhere between 1000 and 5000.  Only one request processes at a time, which exactly how I want it to work. I was able to succesfully run the process on 10 different servers all of which are using ColdFusion Standard Edition 8,0,0,176276 and did not receive any of the errors in the eventgateway.log.  On the four servers where I get these errors, three are ColdFusion 8,0,1,195765 and one is 9,0,0,,251028.

Hiya,I installed CF 10 yesterday and all went OK. Ran the updates, added a few datasources and then found out that CF files only got parsed when called as ./ (rather than ./index.cfm or ./anything-else.cfm). Googled the issue, tried to run the Web Server Configuratin Tool, but that failed to work, soin the end I decided to reinstall CF10. That appeared to have been a very stupid decision.The installation fails now. I tried several times, rebooted the server, etc. but every time, at the end of the installation process (when it tries to install the Web Server Connectors) an error pops up 'ExecutiveAppCmd.exe has stopped working'. I have no other option than to kill that process. The installation finishes, but calling any .cfm file results into a HTTP Error 404.3 - Not found.I ran out of options. Anybody around here have any idea how I can tackle this?TIA!pete

Okay, so I've been tinkering with this for the past few days and have made little to no ground.My scenario:I've got a multiple-instance server within my network, but on a different machine.I'm trying to use ColdFusion Builder 2My ColdFusion version is 9.0.2My ColdFusion install type is Multiple Instance with RDS enabledI'm using IIS 6My Problem: I cannot get debugging to work in ColdFusion Builder.What I'm trying to do: Configure the server to pause on breakpoints from my IDE, to allow me to step through the code and see how it's working. Extras:All of my virtual sites share the same IP, but use different host headers for browser access.In the RDS configuration screen, I'm able to "Test Connection" successfully, but "Test Debugger" return the following error.Test debugger failed.The debugger server is currently listening on port 2,059.This port is not the debugger port set in the ColdFusion Administrator. This port is selected randomly each time the debugger server starts.

I am using http://forums.adobe.com/message/5991203 to apply security patch for CF 9.0.1 and ran into the following error when I tried to select 'chf9010004.jar located under CF901/lib/updates directory:Server Error - IO error on server communicationPlease advise,Sang

Adding a password to cfspreadsheet and saving the file has no effect.  I can still open the file without dialogs and edit anything.  This is true even if I use spreadsheetformatcell to change the lock status.  Does this actually work?  Anybody have an example that works?

Installing CF10 64-bit Dev edition on Win 7-64 and Apache 64 bit. When I get to the Add Web Server Configuration and click on the Configuration Directory button to open the directory tree, the install freezes. I have to stop the install using the task manager. Any ideas what is causing the problem. It's like the java app for the directory tree is not initializing and just freezing up everything. Java 7 update 25 is installed.I was running CF9 with no problem on this machine. It was uninstalled before doing the CF10 install. I had no problems installing CF10 on my other machinethanks,Doug

I am getting "Executing the SQL statement is not allowed" for an INSERT cfquery that I'm running.  I checked the usual suspects:- DSN allows INSERT- I've seen reports online where certain field names or values are considered key words, so for protection CF blocks the query in this way (it would be nice if there was a different error message when it gets blocked this way vs. the DSN doesn't allow INSERT error message).  The field names and values were all benign strings, so it didn't seem like that.I took the same string for the query and ran it on another page and it ran fine (same DSN, too).

I have a list of courses that clients have signed up for. When I click on the view button, it lists all attendees for the course, shows a remove button and once they have completed a survey, it will show the survey button for perusal.The surveys that are showing up on the right are not the surveys for this particular course. My dilemma is that each student may have taken more than one course, thus completing more than one survey. So, an earlier survey is showing instead of the current survey.I have two tables that I have joined by a left out join, but I am still trying to wrap my head around this concept. SignupsCourse Evalsignup_id – Primary Keyrid – courseIDuserIDcourseTitlepropertycalendardatecompanyfirstname,lastname,emailphone eval_id, - primary keyrid - courseIDuserIDThe signups table is left outer joined to the course_eval table by the query below:The #rid#, which is the courseID is sent from the previous page.<cfquery name="getsignups" datasource="#application.dsn#">selec

Hi all,I've been using ColdFusion 10 Standard for some time and recently noticed that there is Failover support for databases on CF10 StandardCF10 Enterprise edition can enable Cluster for load balancing and fail over for application and sessionsWhat is this failover support for database on CF10 Standard edition all about?Can't seem to find any documents or discussion about this

I MUST HAVE HOMESITE OR I WILL DIE! MY VERSION OF HOMESITE 5.5 FAILS ON WINDOWS 8.1.  MY CHILDREN WILL STARVE IF I CAN'T GET THIS TO WORK!!!I ALREADY HAVE THE BLOATED FULL VERSION OF DREAMWEAVER BUT I HATE IT!PLEAESE, ADOBE OR SOMEBODY HELP ME!  I AM CONSIDERING DOING SOMETHING STUPID!

I have been hacked by blackhat seo (type 1703) on 2 separate (and different providers) cold fusion instances.I am wondering if my form inputs are being hijacked with indection code and somehow the hackers are gaining access to my files.My files ultimately have a dozen or so links added to the bottom of the pages and I don't know how they are getting in. I have heard of vulnerabilities in the CFIDE folder on the server but my provider believes its in my code.Any insights are greatly appreciated.

Good day everyone,We had an older version of Cold Fusion running but needed to deal with the problems brought forward with Java 7 update 51.We have the most current version with all the patches installed - Server 10 patch 13We keep getting the message noted above when we launch a grid - the same problems as before on the older release of Cold Fusion.This leads me to believe that these issues are still outstanding in the current release.I tried to sign the jar file i"cfapplets.jar" but when I looked at the manifest it said "do not touch it - you will break it" - i tried and I broke it so I put it back.Any help would be very much appreciated - this is a time sensitive matter.Thank you and,Cheers, JK