Form insert two records

edurichard 13 Jan, 2010
Hi,
When I send a new record from my form in the database are inserted 2 records. The only difference is that one has value 0 in the ordering field and the other is an incremental value.

Furthermore the ordering I do not need, but do not know how to remove it without getting sql error.

Thank you.
GreyHead 13 Jan, 2010
Hi edurichard,

Please tell us a bit more about the form. ChronoForms will not normally save two records unless extra code has been deliberately added.

Bob
edurichard 13 Jan, 2010
Hi, I have a form with ChronoForms, and a page made with ChronoConnectivity.
If I send a record from the form, insert a single record. But if I insert through the new record button ChronoConnectivity, I insert two records with different field ordering.
If I remove the field ordering of the database, to send the data I get an sql error: Unknown column ordering.

Thanks!
edurichard 13 Jan, 2010
Now, I have eliminated the parameter 'ordering' of the fields 'paramsall' i 'ClassCode' in record ChronoConnectivity's table. So do not give me sql error but the form still sends 2 entries equal.
I don't understand!
GreyHead 13 Jan, 2010
Hi edurichard,

You forgot to mention that this was a ChronoConnectivity problem :-(

There was another thread about this recently. I think the answer was to disable the DB Connection in the form - but do look at the other thread to be sure.

Bob
edurichard 13 Jan, 2010
Yes! I have disabled the connection to the DB of the form and now it works!
Thank you very much.

Just one question. Now the register does not add the 'recordtime', how can I do to add the current date?
GreyHead 13 Jan, 2010
Hi edurichard,

Add a hidden field to the form with a name of recordtime and a value of <?php echo date('yyyy-mm-dd h:i:s'); ?>- from memory, may not be exactly correct.

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