Login   Register  
PHP Classes
elePHPant
Icontem

update a column not displayed in the grid

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

      DrasticTools  >  All threads  >  update a column not displayed in the grid  >  (Un) Subscribe thread alerts  
Subject:update a column not displayed in the grid
Summary:updating a column that is not displayed in the grip
Messages:2
Author:bill
Date:2010-06-27 14:45:53
Update:2010-06-28 15:10:13
 

  1. update a column not displayed in the grid   Reply  
Picture of bill
bill
2010-06-27 14:45:53
I have a column CustomerId that I do not show in my grid. It is passed as a paramater to the php file that i use to display the grid. when i add a row in the grid, how do i update the CustomerId when the grid row is inserted?

  2. Re: update a column not displayed in the grid   Reply  
Picture of dd
dd
2010-06-28 15:10:13 - In reply to message 1 from bill
Hi Bill,

If the CustomerID field has a default value in the MySQl table, the add operation will use that. Alternatively you can give the customerID field an auto_increment property in MySQL and there will be an ID for you generated.

If that you want to assign a special customerID to the non-displaying field, you have to use the addparams option to pass the ID from javascript to the SQL backend (see exampleGrid9 on Drasticdata.nl). Of course, this only works if you have this id or you add a mechanism for the user (extra field) to specify the customerID as you specified it not to be displayed in the grid.

Hope this helps,

regards,

dd