Hello,
I created a form that sends an email (no record in the database).
All fields are sent, except the one created with a select dynamic 'free' mode.
If I create the fields in 'construction' mode, it is sent by mail.
What should I put in my select for it to be mailed?
My select :
select #__content.title AS titre from rpe7x_content INNER JOIN #__cck_store_form_agenda ON #__content.id = #__cck_store_form_agenda.id where rpe7x_content.catid='10' and #__content.state='1' and #__cck_store_form_agenda.choix_reservation_possible='Oui'
Could you help me ?
Thanks,
Seb
Your query needs to contain text and value properties, e.g. SELECT #__some_column AS text, #__some_other_column AS value ...
Hello,
Thanks for answer.
My query contains text and value :
SELECT contenu.title AS titre
FROM rpe7x_content AS contenu
INNER JOIN rpe7x_cck_store_form_agenda AS agenda
ON contenu.id = agenda.id
WHERE contenu.catid='10' AND contenu.state='1' AND agenda.choix_reservation_possible='Oui'
But it doesn't work... Any idea ?
Thanks.
It has "titre" and I can't find anything that is used as value - they need to be exactly "text" and "value" so something like contenu.title AS text, contenu.id AS value
It works, thanks !!