02-14-2019, 02:35 PM
Interestingly enough, there is no error.
Plus, I just realized that when we first add an entry the record is created, so the insert works fine.
The record can then be read, but upon editing that record the update does not work.
Even more interesting is, I can update other fields but not the two name fields. I thought maybe it was the privileges but the user has select, insert, update, and reference for privileges.
Based on the UserSpice code how should an db->update be formulated. It seems pretty simple to me:
db->update('A_table', 'An_ID', 'A_Column_to_Update');
Is it perhaps the $fields=array('rtu_name'=>$rtu_name);?
Maybe the update isn't actually seeing new data?
Thanks,
Rob
Plus, I just realized that when we first add an entry the record is created, so the insert works fine.
The record can then be read, but upon editing that record the update does not work.
Even more interesting is, I can update other fields but not the two name fields. I thought maybe it was the privileges but the user has select, insert, update, and reference for privileges.
Based on the UserSpice code how should an db->update be formulated. It seems pretty simple to me:
db->update('A_table', 'An_ID', 'A_Column_to_Update');
Is it perhaps the $fields=array('rtu_name'=>$rtu_name);?
Maybe the update isn't actually seeing new data?
Thanks,
Rob