How to update a field in a record

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.

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

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