ColdFusion

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

Microsoft® Windows Server® 2003 with Service Pack 1 or 2 or Windows Server 2003 R2 (Web, Standard, or Enterprise Edition); Windows Server 2008 (Web, Standard, or Enterprise Edition) with Service Pack 2 or Windows Server 2008 R2 (Web, Standard, or Enterprise Edition); Windows XP Professional or Home Edition; Windows Vista® (Business, Ultimate, or Enterprise) with Service Pack 2; or Windows 7 (Professional, Ultimate, or Enterprise) with Service Pack 1http://volumelicensing.adobe.com/store/adbevlus/en_US/DisplayProductDetailsPage/ThemeID.22525600/productID.250075400Above link shows ColdFusion system requirement. It shows Windows XP Home edition, but neither  Windows 7, nor Windows Vista home edition.I would like to know does above link missing both Windows 7 and Vista home edition, or ColdFusion 10 does not support Windows 7 and Vista home edtion.Your information and help is great appreciated,Regards,Iccsi

Hello I am creating a chart that will display two bar for each item colum. I can get one (the t3 bar) to display ok but I do not understand how to layout the second set of bars for the graph.  Thank youHere is what i got so far.<!---master query---><cfquery name="master" datasource="cfpMeasure">   select Region,SUM(t1) as T1,SUM(t1unpaved) as T1Unpaved,SUM(t2) as T2,SUM(t2unpaved) as T2Unpaved,SUM(t3) as T3,SUM(t3unpaved) as T3Unpaved,SUM(t4) as T4, SUM(t4Unpaved) as T4Unpaved,SUM(t5) as T5, SUM(T5Unpaved) as T5Unpavedfrom dbo.vp_MilesByTRCgroup by Region   </cfquery><!---Queries of Queries--->      <cfquery name="ps" dbtype="query">select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTERwhere region ='PS' group by region </cfquery><cfquery name="ne" dbtype="query">select Region,SUM(t3) as T3,SUM(t1unpaved) as T3Unpaved FROM MASTERwhere region ='NE' group by region </cfquery><cfqu

I just installed CF 10 on my computer and would like to create a new web site.I would like to know should I just create a folder at C:\ColdFusion10\cfusion\wwwroot\ or at C:\inetpub\wwwroot or any admim tool to do so.Your help and information is great appreciated,Regards,Iccsi,

Hi , I was wondering if it was possible uploading an mdb file and parsing it to output a pdf file through cf...I know I have therefor need to have a dsn-less connection to that file to start with.I tried : <cfif isdefined("form.fileData")>       <cfscript>              hello = FileUpload("C:\inetpub\wwwroot\cvt\","form.fileData","application/msaccess","MakeUnique");       </cfscript>       <cfdump var="#hello#"> <cfscript>classLoader = createObject("java", "java.lang.Class");classLoader.forName("sun.jdbc.odbc.JdbcOdbcDriver");dm = createObject("java","java.sql.DriverManager");con = dm.getConnection("jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};Dbq=#hello.serverfile#;Uid=Admin;Pwd=somepwd;");st = con.createStatement();rs = st.ExecuteQuery("Select * FROM tblbarcode");q = createObject("java", "coldfusion.sql.QueryTable")

I just installed CF 10 on my Win 7 Home machine and tried to add a MS SQL server data source and got following error.do I need install any driver to add MS SQL Server as a data source?I am able to add MySQL database, but not MS SQL Server.Your help and information is great appreciated,Regards,iccsi,Connection verification failed for data source: MyServerjava.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connectThe root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: MyServer:1433. Reason: Connection refused: connect

Good evening all,I have been running CF Report Builder 9 without any issues with CF 9. I migrated to CF 10 and Report Builder 10 and, Report Builder does not maintain a connection. It's very frustrating that I cannot find any tips on this. Any tips can help.DJ Khalif

I just installed a CF 10 on my machine and want to test a report and would like to know how I can connect RDS server to connect database to build the report .Your help and information is great appreciated,Regards,Iccsi,

This question has been asked in the past but not answered completely, so here is my issue:I am currently working on a site that has two separate sections(one public section and another admin section), but need to share the same Application variables.Basic file structure....Root-- Admin  -- Application.cfc  -- index.cfm  -- Application.cfc  -- index.cfm   The public side will contain the application start and end code and the the admin Application.cfc will include the public application.cfc(<cfinclude template="../Application.cfc" />) and the login logic.   The reason I am trying to do this is that my application scope needs to be accessible by both sides. My understanding is that the CF server will treat this all as one application since they have the same name.During my testing, I set application.cfcroot variable in the public application.cfc.  That variable is not accessible in the admin subfolder.  My understanding is the fact

I have a cfform form for a blood product unit number.  Staff usually scan the bar code into this field, but I want some of the content to be stripped.Embedded in the bar code are start and stop characters.  The start is always =.  Then the next 13 characters are the only ones I want, there is also a chack digit that is embedded at the end, but again, I only want the 13 characters after the =.Also I want to make sure that what is submitted is exactly 13 characters and the first submitted character will always be a W.Is this possible?Thank you

I would like to connect my MS SQL database from ColdFusion server.Can I use connection string to connect database or I need set up ODBC at ColdFusion level and use application paramter to connect database server?Your help and informaiton is great appreciated,Regards,Iccsi,