hi,
If i understand, there is a project demo, where is it please?
I try to save data from a form :
- Create fn save data but i don't no for provider data, for the moment i put {var:form-edit} where form-edit is the name of the form
- update conditions : id={var:form-edit.id}
reult
Unknown column 'id={var' in 'where clause' SQL=UPDATE `#__mesData` AS `maData` SET `nom` = '', `valeur` = '', `information` = '' WHERE `id={var` = 'form-edit.id}';
😉
thanks
Hi Chris,
The demo projects are under "custom project", or when you click "new" (new versions).
If you want to save the form data then you will need to call a "Save data" function in the event where the form submits, the update conditions can be left empty if you don't need to update.
If you want to supply update condition then this is the correct syntax:
id:{some_var}
Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Thanks Max,
I did it in event and the save process reaveals an error mysql
for WHERE `id={var` = 'form-edit.id}'; ok id:{some_var}
bur you see the fields to be update are empty SET `nom` = '', `valeur` = '', `information` = ''
I forgot something...?
best regards
Hi Chris,
Yes, that var is wrong, in normal cases, you should NOT have an "update condition", the data provider should be set to {data:}
BUT, if you want to capture the form data and the form fields names have a model, e.g: Model[nom], then you need to use {data:Model} instead.
Please try that and let me know.
Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
All right,
Only {data:} for provider and nothing in the other fields and that works fine
It's too simple😉
Thanks Max