Hi All, I'm trying to edit this piece of code to allow me to edit more than just one field within a multi-record update. However, when I add a second field to the SET, I get this error: "Invalid list index 5. In function ListGetAt(list, index [, delimiters]), the value of index, 5, is not a valid as the first argument (this list has 4 elements). Valid indexes are in the range 1 through the number of elements in the list. The error occurred on line 120." (Line 120 is BESFollowUpStatus) <CFSET Form.totRecords = Val(Form.totRecords) > <CFOUTPUT > <cfloop from="1" to="#form.totRecords#" index="ct">   <cfquery name="Recordset2_UPDATE" datasource="Incident_Reporting">         UPDATE dbo.tbl_P1         SET          AllDocumentsAttached = '#listgetat(form.AllDocumentsAttached,ct)#',         BESFollowUpStatus   = '#listgetat(form.BESFollowUpStatus,ct)#'     WHERE         ID = #listgetat(form.ID,ct)# </cfquery> </cfloop> <!---***************Ends : Multiple Active Reocrds************************---> </CFOUTPUT> Can you help me understand the error in the logic or if I am just going about this all wrong? Thanks, John ... View more

Hi All, What is the difference between #VARIABLES.ID# and #ID#? Thanks! John ... View more

Hi All, I'm not sure what I'm doing wrong. The form that I have has 11 records but my CFloop to CFQUERY is only returning 1 result. I'm expecting to see 11 records in the Recordset2_UPDATE query. The Recordset2_UPDATE query is just a SELECT statement for now, for testing. <cfloop from="1" to="#form.totRecords#" index=ct>   <cfquery name="Recordset2_UPDATE" datasource="Incident_Reporting">     SELECT '#form.ID#' as "UID",         '#listgetat(form.ID,ct)#' as ID,         '#listgetat(form.AllDocumentsAttached,ct)#'  as AllDocumentsAttached          FROM dbo.tbl_P1     WHERE         ID = #listgetat(form.ID,ct)# </cfquery> </cfloop> Thanks for the second set of eyes! John ... View more

Hi All, For the past few weeks, the ColdFusion Server will randomly just hang... where a page request will just keep spinning... restarting the server has cleared it up... but we're having to do that more frequently. Can you give me some insights into this problem or how to debug it on CF11 Server? Version: ColdFusion 11 Update 7 IIS: Windows Server 2012R2 8.5.9600.16384 Database: SQL SERVER 2008 R2 I suspect the problem may be related to the number of workers/processes running at a given time? How do I increase this from the default installation? Thanks, John ... View more

Hi All, For the past few weeks, the ColdFusion Server will randomly just hang... where a page request will just keep spinning... restarting the server has cleared it up... but we're having to do that more frequently. Can you give me some insights into this problem or how to debug it on CF11 Server? Version: ColdFusion 11 Update 7 IIS: Windows Server 2012R2 8.5.9600.16384 Database: SQL SERVER 2008 R2 I suspect the problem may be related to the number of workers/processes running at a given time? How do I increase this from the default installation? Thanks, John ... View more

Hi All, I'm uploading my .xls using cffile and cfspreadsheet (query="data") to parse the .xls into a query object but I cannot figure out how to insert the query result into a table on sqlserver. <!--- Take data from xls and put into Query, drop info into Table on SQLSERVER.ENGOPSMTRLS ---> <cfquery name="GetData" dbtype="query" datasource="ENGOPSMTRLS">    SELECT * FROM data </cfquery> <cfoutput query="data"><P><BR>#Name#,<BR>#Work_Order#, <BR>#Project_Manager#, <BR>#Funding_Source#</cfoutput> <cfdump var="#upload#" /> <cfdump var="#data#" /> <cfquery name="update" datasource="ENGOPSMTRLS"> INSERT INTO ENGOPSMTRLS_UPLOAD (Name, Work_Order) <cfoutput query="data">   VALUES (<cfqueryparam value="#data.Name#" cfsqltype="cf_sql_varchar" />, <cfqueryparam value="#data.Work_Order#" cfsqltype="cf_sql_varchar" />) </cfoutput> </cfquery> Error Details: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'VALUES'. The error occurred on line 228. Thanks for your help. ... View more

Hi All, I'm trying to validate an inputted value from a form to make sure it is a valid currency value: I only want to accept a monetary value with 2 decimal places and I do not want to use any JavaScript validation. CF seems to make this very difficult. Thanks, John ... View more

Hi, I have a Multi-Select Option Box that is correctly listing all values as well as the selected values within the multi select box. However, as you can see, the items are duplicated in the list, with both selected items and the available option values both showing. Instead, I'd like to show the full list of values, with the ones that are selected without any duplicates, like this instead: <cfset lstFinds = Recordset1.OfficeServed>  <cfoutput><SELECT NAME="OfficeServed" size="10" multiple class="VBlack10" ID="OfficeServed" >                         <cfloop list="#lstFinds#" index="k" delimiters=",">             <option value="#k#"             <cfif listfindnocase(ValueList(RS_location.location), k)>             selected="selected"             </cfif>>#k#             </option>             </cfloop>            <CFLOOP QUERY="RS_location">             <OPTION VALUE="<cfoutput>#RS_location.location#</cfoutput>"><CFOUTPUT>#RS_location.location#</CFOUTPUT></OPTION>           </CFLOOP>               </SELECT></cfoutput> Thanks! John ... View more

Hi All, I'm fairly new to AS3 and have been working with some premade code. I am able to get this script and class file attached to my Flash file, and I can add the tooltip to a movie clip on my stage as well as a child movie clip. The problem I'm seeing now is that the script can't initialize if I put the tooltip on a different frame than the first frame of a child movie clip. I have tweening and need these tooltips to only be available at certain points in the .swf, not all from the first frame. /** Font Notes : notes, cannot have embedded and non embedded fonts in 1 field. if using a stylesheet and an embedded font, the font-family:NAME must equal the actual name of the font, not the linkage class.  if using textformat create a new instance of the linkage class: var font:LINKAGE = new LINKAGE(); tf.font = font.fontName; */ package { import assets.com.hybrid.ui.ToolTip; import flash.display.*; import flash.events.*; import flash.utils.*; import flash.text.*; import flash.utils.Timer; import flash.events.TimerEvent; import flash.system.*; import flash.net.URLLoader;     import flash.net.URLRequest; import flash.events.IOErrorEvent; public class Application extends MovieClip {       private var _tf:TextField;    private var _timer:Timer;   private var _reusableTip:ToolTip;   private var _sheet:StyleSheet = new StyleSheet();       public function Application(){      this.loadStyleSheet();    _reusableTip = new ToolTip();    _reusableTip.hook = true;    _reusableTip.cornerRadius = 20;    _reusableTip.tipWidth = 400;    _reusableTip.align = "right";    _reusableTip.border = 0xadd483;    _reusableTip.borderSize = 5;   }     private function loadStyleSheet():void {    var loader:URLLoader = new URLLoader();    loader.addEventListener(IOErrorEvent.IO_ERROR, errorHandler);             loader.addEventListener(Event.COMPLETE, loaderCompleteHandler);    var req:URLRequest = new URLRequest("assets/styles.css");             loader.load(req);   }         public function errorHandler(event:IOErrorEvent):void {    event.currentTarget.removeEventListener(event.type, arguments.callee);             //inputField.htmlText = "Couldn't load the style sheet file.";         }         public function loaderCompleteHandler(event:Event):void {    event.currentTarget.removeEventListener(event.type, arguments.callee);    var loader:URLLoader = URLLoader(event.target);    this._sheet.parseCSS(loader.data);    this.initialize();         }     private function initialize():void {     //level1.level2.buttonMode = true;     main_mc.level1.addEventListener( MouseEvent.MOUSE_OVER, this.onMouseOver );     // level1.level2.addEventListener( MouseEvent.MOUSE_DOWN, this.omd );     main_mc.test2_mc.addEventListener( MouseEvent.MOUSE_OVER, this.onMouseOver_test2_mc );     //this.debug();   }     private function omd( event:MouseEvent ):void {    _reusableTip.setContent( "Set A New Title", "Set Some New Content, A Little Less Than Before." );   }     private function onMouseOver( event:MouseEvent ):void {       /*    _reusableTip = new ToolTip();    _reusableTip.hook = true;    _reusableTip.cornerRadius = 20;    _reusableTip.tipWidth = 260;    _reusableTip.align = "right";    _reusableTip.border = 0xFF0000;    _reusableTip.borderSize = 5;    */    _reusableTip.show( main_mc.level1, "Safety", "We often work in harsh conditions and with potentially dangerous equipment. The first, last, and ongoing focus of all PRECorp activities is the safe work ethic employees." );    //this.traceDisplayList( stage );   }   private function onMouseOver_test2_mc( event:MouseEvent ):void {       _reusableTip.show( main_mc.test2_mc, "Hi", "Some Text" );   }      //  private function debug():void { //    Memory Testing //   _tf = new TextField() //   addChild( _tf ); //   this._timer = new Timer( 25 ); //   this._timer.addEventListener( "timer", onTimer ); //   this._timer.start(); //  } //  //  private function onTimer( event:TimerEvent ):void { //   _tf.text = flash.system.System.totalMemory.toString() //  } //  //  function traceDisplayList(container:DisplayObjectContainer, indentString:String = ""):void{ //   var child:DisplayObject; //   for (var i:uint=0; i < container.numChildren; i++) //   { //    child = container.getChildAt(i); //    trace(indentString, child, child.name); //    if (container.getChildAt(i) is DisplayObjectContainer) //    { //     traceDisplayList(DisplayObjectContainer(child), indentString + "    ") //    } //   } //  } } } The error I get is: TypeError: Error #1009: Cannot access a property or method of a null object reference. at Application/initialize() at Application/loaderCompleteHandler() at flash.events::EventDispatcher/dispatchEventFunction() at flash.events::EventDispatcher/dispatchEvent() at flash.net::URLLoader/onComplete() thanks for your help, John ... View more