Support Forum

Every time that you post a problem, PLEASE add the Joomla and the extension's versions and revisions (for example: Joomla 3.3.6, Contact Enhanced 3.3.5), PHP version and Server's Operating System. If you only manage only one site it is easier if you edit your profile and just add that information to your signature. Don't forget to add a detailed description of the problem. If possible, write down all steps to simulate the problem.

Before submitting a new post, PLEASE make sure you are running the latest version, test in different browsers (IE, FF, Chrome,..) and clear Joomla and browser's cache after every change you make.

Also, most questions are already answered in our FAQ and in iFAQ and Contact Enhanced documentation pages.

× Contact Enhanced is a contact component manager created to replace Joomla! core contacts component and add lots of advantages and new features (see Features ) and it offers many plugins and modules for several different purposes,
Product page | Documentation Page

Problem with the format of {form_fields}

6 years 1 week ago #24033 by Locatelli
Hi,

I have a problem when i use in the {form_fields} tag in a mail template.

All the form fields are printed, but the form fields that are populated with an SQL query with ID and Value are are printed with the ID. I need to get the value instead. Can I have a fix for this?

This is the Sql:

SELECT DISTINCT country AS text, id AS value
FROM #__x
WHERE 1
ORDER BY country ASC

Thank You for your support,

Please Log in or Create an account to join the conversation.

6 years 1 week ago #24034 by support
Dear Locatelli,

That's how the SQL Field was designed. Can you use use concat_ws(' - ',id,country) AS value instead of id AS value?

Best regards,

Please Log in or Create an account to join the conversation.

6 years 1 week ago #24035 by Locatelli
Hi, thanks for the tip, but the mail will go to a customer that has no interest in seeing an ID, especially if there are many.

There is some other workaround to see only the text?

Please Log in or Create an account to join the conversation.

6 years 1 week ago #24036 by support
Dear Locatelli,

Do you need the ID at all?
If you don't, please replace id AS value with country AS value.

Best regards,

Please Log in or Create an account to join the conversation.

Powered by Kunena Forum

Copyright © 2018 IdealExtensions.com. All Rights Reserved.

This site is not affiliated with or endorsed by the Joomla!™ Project. It is not supported or warranted by the Joomla!™ Project or Open Source Matters™. The Joomla!™ logo is used under a limited license granted by Open Source Matters™, the trademark holder in the United States and other countries.
We may collect your IP address and your browser's User Agent string while using our site for security reasons and deriving aggregate information (analytics). This information is retained for a minimum of 1 and a maximum of 24 months.
Feedback