Forums

How to update a field in a record

peptobismol 27 Aug, 2009
I tried searching the forum but all I found is this
<input type="hidden" name="cf_id" value="44" />


What field/column does '44' go to? cf_id is the key to this record but.....
anyway,

Say I have a table serve_project with e_id*, e_uid, e_pid. e_id is the key.

Now I want to have a form to just update e_pid depending on the e_uid.

this is how I'd write it in sql


UPDATE serve_project SET e_pid=some value WHERE e_uid = some uid


Where do I work this out in chronoform?

thanks.
GreyHead 28 Aug, 2009
Hi peptobismol,

Provided that you have an existing valid key in your form code on submission then the Joomla code that ChronoForm uses will Update the record instead of Inserting a new one. (In effect it acts like Replace.)

You can trigger this by adding the key value in a hidden field - as it is in the example you found.

Bob
devi 02 Sep, 2009
Hi Bob,

I've tried to do this - I guess that's why I am unable to edit an existing record.

BUT...
how do I store the Chronoform's default generated value of cf_id into the hidden field? and where do I place the code - I do not need emails to be enabled.

Please please help - this is the only thing and I do so desperately need this function to complete my project.

thanks
devi
This topic is locked and no more replies can be posted.