I have the above statement in a column in mySQL.
When I edit the grid an the update clears the value.
[code]Log started, 23/10/2014 04:00:48
====================================
DataProcessor object initialized
1_gr_id => 1
1_c0 => 16122
1_c1 =>
1_c2 => CROSS
1_c3 => 2014-10-23
1_c4 => DIC Only
1_c5 => Greenfield
1_c6 => MFE LAC ON
1_c7 => 9087644
1_c8 => C TI DICI Indoor Including Rack Install G444
1_c9 => DARWIN - 1 Day Parallel Install
G222 L111 1800
FCIA & Flexi DIC
FCIA To Be Installed As Per GA
New C63A DC Breaker To Be Installed On The Day By DMN
Final DC Power Connection On The Day By DMN
1_c10 =>
1_c11 => John Lambert
Joe Jackson
Lanford Wilson
1_c12 => 07776127013
07970954901
1_c13 =>
1_c14 =>
1_c15 =>
1_c16 =>
1_c17 =>
1_c18 =>
1_c19 =>
1_c20 =>
1_c21 =>
1_c22 =>
1_c23 =>
1_c24 =>
1_c25 =>
1_c26 => 2
1_c27 => 0
1_!nativeeditor_status => updated
1_version => 80
ids => 1
Row data [1]
ID => 1
CSC => 16122
PANIC =>
SITE_NAME => CROSS
FORECAST_DATE => 2014-10-23
ACTIVITY_TYPE => DIC Only
SITE_TYPE => Greenfield
BSC_ID => MFE LAC ON
WP_ID => 9087644
WP_NAME => C TI DICI Indoor Including Rack Install G444
WP_NOTES => DARWIN - 1 Day Parallel Install
G222 L111 1800
FCIA & Flexi DIC
FCIA To Be Installed As Per GA
New C63A DC Breaker To Be Installed On The Day By DMN
Final DC Power Connection On The Day By DMN
RIGGING_WI_NOTES =>
LEAD_FE_NAME => John Lambert
Joe Jackson
Lanford Wilson
LEAD_FE_PHONE => 07776127013
07970954901
MS1 =>
MS2 =>
MS3 =>
MS4 =>
MS5 =>
MS6 =>
MS7 =>
MS8 =>
MS9 =>
MS10 =>
MS11 =>
COMMENTS =>
OPEN_DEFICIENCIES =>
WP_STATUS => 2
ALERT => 0
!nativeeditor_status => updated
version => 80
SELECT MAX(id) as VERSION FROM actions_table
UPDATE tblDaily SET CSC=‘16122’,PANIC=‘’,SITE_NAME=‘CROSS’,FORECAST_DATE=‘2014-10-23’,ACTIVITY_TYPE=‘DIC Only’,SITE_TYPE=‘Greenfield’,BSC_ID=‘MFE LAC ON’,WP_ID=‘9087644’,WP_NAME=‘C TI DICI Indoor Including Rack Install G444’,WP_NOTES=‘DARWIN - 1 Day Parallel Install\nG222 L111 1800\nFCIA & Flexi DIC\nFCIA To Be Installed As Per GA\nNew C63A DC Breaker To Be Installed On The Day By DMN\nFinal DC Power Connection On The Day By DMN’,RIGGING_WI_NOTES=‘’,LEAD_FE_NAME=‘John Lambert\nJoe Jackson\nLanford Wilson’,LEAD_FE_PHONE=‘07776127013\n07970954901\n’,MS1=‘’,MS2=‘’,MS3=‘’,MS4=‘’,MS5=‘’,MS6=‘’,MS7=‘’,MS8=‘’,MS9=‘’,MS10=‘’,MS11=‘’,COMMENTS=‘’,OPEN_DEFICIENCIES=‘’,WP_STATUS=‘2’,ALERT=‘0’ WHERE ID=‘1’
INSERT INTO actions_table (DATAID, TYPE, USER) VALUES (‘1’, ‘updated’, ‘1414072836733’)
Edit operation finished
0 => action:updated; sid:1; tid:1;
Done in 0.15499997138977s
[/code]