VBAjedi
Posts: 34
|
Posted: 03/03/2004, 1:15 PM |
|
I've created an editable grid where the only "editable" field is a checkbox control (all the other field controls are just labels). The Control Source of this checkbox is set to a database column named V_TransactionID. The Checked Value is set to be a concatenation of the timestamp and UserID. That part works.
However, I only want a new value to be written to the database if the checkbox is checked (i.e. if a row is not checked, I want to preserve the value that is already in the database for V_TransactionID).
Since SOMETHING gets written to the dbase for every checkbox when the grid is submitted, how do I set the Unchecked Value to be whatever is already in the database for that record? Simply setting Unchecked Value to "V_TransactionID" returns that as a literal text string (instead of the value in column V_TransactionID for that row).
What's the syntax for this? (Obviously using PHP)
Thanks!
_________________
VBAjedi
jedi at NOSPAM dot obie dot com |
|
|
|