1 Reply Latest reply on Jun 18, 2008 3:16 AM by anirudhs

    Datagrid and mySQL update

    CBrasfield
      I have a datagrid that is populated by dragging from a tilelist. I would like to pass the info from the datagrid into a mysql database. I've got my HTTP service set up with my mx:request and xml nodes to put into the db. However, there's no info being passed.

      <mx:request>
      <prodId>{prodId}</prodId>
      <price>{price}</price>
      <phoneName>{phoneName}</phoneName>
      <camera>{camera}</camera>
      </mx:request>

      The {} are from the dataField. The fields in the db are added, but it adds [object DataGridColumn] instead of said value. Plus, I'm not quite sure how to add more than one column at a time.

      If there's any tutorials out there directing as to pass datagrid data to a database would be great.

      Thanks for any help.
        • 1. Re: Datagrid and mySQL update
          anirudhs Level 2
          Hi,

          If you haven't specified a dataProvider for your datagrid, the data is available via datagridid.dataProvider. If you want to get data associated with a selected row in datagrid, you can say datagridid.selectedItem. If a column's datafield is prodId, the data can be accessed like datagridid.selectedItem.prodId.

          Check out the example in the end at the livedocs page.