1 Reply Latest reply on Oct 12, 2010 10:37 AM by SunilAdobe

    Assigned bindable variable change changing MySQL Data !?

    Daniel Pride Level 1

      One way Data Binding of an ArrayCollection to a last result is altering MySql Record through Coldfusion?

      The following if you click on it increments all the dates once, for each time you click,...

      like a counter, it changes the value in MySQL, but as I understand what I wrote

      I am assigning the last result value to a bindable variable.

      So why is the value stored way back in MySQL (after you pass through cold fusion) changed, and how?

       

      This is  contrary to my understanding of how the software should work. Comments?

      [Bindable]
      public var theResults:ArrayCollection = new ArrayCollection();
      protected function showAllButton_clickHandler(event:MouseEvent):void
      {
      getAllLineItemsResult.token = lineItemsService.getAllLineItems();
      lineItemsService.commit();
      }
      protected function getAllLineItemsResult_resultHandler(event:ResultEvent):void
      {
      theResults = getAllLineItemsResult.lastResult
      for each(var item:Object in theResults)
      {     
      item.AptDate = new Date(item.AptDate.getTime() + (1 *  millisecondsPerDay));
      }

      }
      and of course theResults is bound to the dataGrid dataProvider property.
      FlashBuilder 4, CF9 and MYSQL

      Thanks
      Dan Pride