Forums

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

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

All right,
Only {data:} for provider and nothing in the other fields and that works fine
It's too simple😉
Thanks Max