ColdFusion

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,

I am attempting to get the dotNET integration working properly in ColdFusion 10 64 bit, running on Windows Server 2008 R2.I have a sample bit of code which works fine in CF8 and CF9 (both 32 bit) but it doesn't seem to work in CF10:<!--- This function pings the specified host. ---><cffunction name="CFPing" returntype="string" output="false">    <cfargument name="host" type="string" required="yes">    <!--- Local vars --->    <cfset var pingClass="">    <cfset var pingReply="">    <!--- Get Ping class --->    <cfobject type=".NET" name="pingClass"    class="System.Net.NetworkInformation.Ping">    <!--- Perform synchronous ping (using defaults) --->     <cfset pingReply=pingClass.Send(Arguments.host)>    <!--- Return result --->    <cfreturn pingReply.Get_St

I need only the 9.0.0 version and not 9.0.1 or 9.0.2.I don't know where to download it.Please help me. I really need itThanks in advance

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

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

Synopsis:I need to access the calendar events for a user that has delegated their calendar access to me on the company Exchange Server. The delegation is in place and I'm able to view/modify the other users calendar using the Outlook 2007 client, so I know the delegation rights are correct, however I'm not able to query the events using the ColdFusion cfexchange* tags.  According to the ColdFusion documentation this is possible, see http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec14f31-7ff6.htmlSystems:ColdFusion 10 Enterprise x64 Update 0 running on Ubuntu Server 12.04 x64 LTSExchange Server Standard 2010 SP 1 running on Windows Server 2008 R2Outlook 2007 running on Windows XP Professional SP3  DetailsThe following code is what I'm using, with the specific and sensitive bits removed. If I remove the mailboxName attribute, or if I use the same username value, then I'm able to successfully see 25 of my calendar events. However when I use t

I am using ColdFusion 9 standard on a 32-bit version Windows Server 2008 virtual machine with 6 GB of RAM.Since migrating an application from a physical server running CF 8 to this new virtual machine running CF 9, I have experienced a very strange behavior.I am using the CFINVOKE tag (as a web service) to pull down data.  When the web service code is wrapped in a CFLOCK, the request eventually times out with no response.  It appears that the request is stuck waiting to receive the exclusive lock and the ten second window passes.  If I call the web service directly, bypassing the CFLOCK, the request goes through with no problems.Why would the combination of these thwo tags cause this problem?Here is what the code looks like in Application.cfm:<CFLOCK Name="DataPullIntranet" Type="exclusive" TimeOut="10">  <CFTRY>    <CFIF IsDefined("URL.ResetData") or          Len(Application.MediaTrackerCach

Hi,I have cf 10 installed on a vm running ms 2008R2, using IIS 7 as my webserver.  In the last couple of days I have been recieveing the following error:Element ID is undefined in a Java object of type class coldfusion.util.FastHashtable.It is appearing when trying to log in to some apps but not all, even though they use the same base authentication code.  When the error occurs, it is before any authentication takes place and ID is not used as a fieldname in any of the applications. Empl_ID is used.I am stumped.I've checked: mappingsdata sourcescookiesetc..Has anyone encountered this before?  How did you rectify it?thanks in advanceJBird

HelloI'm downloading a csv file daily. I need to extract a value that is in row 30 and 11th column.I'f you open the csv in Excel it has headers for the columns and the specificisRight now im using <cfftp action = "getFile"    server = "#remoteFileLocation#"    port="21"    username="anonymous"    password=""    connection = "MyConn"    passive = "Yes"    localFile="D:\Inetpub\localFile.csv"    remoteFile="Future.csv"    failifexists="no">Did it succeed? <cfoutput>#cfftp.succeeded#</cfoutput><cfftp action="close" connection="MyConn"><h1>Populate cpr table - future.csv</h1><cfhttp url="http://www.website.com/future.csv"method="GET"name="qStockItems"delimiter=","""firstrowasheaders="yes"columns="PRODUCT,CONTRACT_MONTH,CONTRACT_YEAR,CONTRACT_DAY,CONTRACT,PRODUCT_DESCRIPTION,OPEN,HIGH,HIGH_AB_INDICATOR,LOW,LOW_AB_INDICA

I am trying to use a CFTOOLTIP and what comes up in the tooltip is not the info that I am rolling over. The tooltip displays info just not the right info.  Does anyone see anything wrong with this code?CODE:<CFSET endcalendar = DateAdd("d", 30, Now())>                  <CFOUTPUT query="getcalendar" >                  <CFIF #event_date#  IS NOT "">            <cfif DateCompare(#event_date#, Now()) IS +1 AND DateCompare(#event_date#, #endcalendar# ) is -1>            <cftooltip autoDismissDelay="10000" hideDelay="250" preventOverlap="true" sourceForTooltip="tooltipcontent.cfm?proj_key=#getcalendar.proj_key#&ID=#getcalendar.ID#">       

Hi!I have a simple CFC which gets records from a database.I have then created a ColdFusion page and used <cfobject> to make an instance of the CFC. I then use this instance to populate a <cfselect> form element.The problem is that the field has too many spaces in it so I need to Trim it.Here is my code:<cfobject component = "globalFilters" name="globalFilters"><cfinvoke component="#globalFilters#" method="filters_Status" returnvariable="rsStatus"><cfselect name="Status"query="rsStatus"value="#Trim(Status)#"display="Status"></cfselect>Unfortunately it CF says "Status" is not defined and fails. But if I remove the Trim method then it works fine.How do I trim the value in the select list?

Hey guys, I was trying to use Scala in place of Java with my ColdFusion app.Since Scala converts down to java byte code and runs on the JVM, I thought it would be able to be dropped in there like a java class. It actually becomes a java class. I called the class using the createObject("java", "HelloWorld") function but it doesn't work.Has anyone else tried to do this or heard of anyone accomplishing this before?Thanks,Chris