× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

Joomla 3.x - About the SQL query field type limits

9 năm 5 tháng trước #858 bởi Michaël Brantus
Joomla 3.x - About the SQL query field type limits was created by Michaël Brantus
Hello everyone !
I have a question about the SQL field type in the component creator.

I try to get a list of values and keys from a MySQL table
When I use this query in my SQL field

SELECT name, id FROM myTable ODER BY name

This query works fine with my component in Joomla 3.x


Now I need to add an empty value in my list using this query

SELECT name, id FROM myTable UNION '' as name, NULL as id ORDER BY name

This query works fine when i run it on PHPMyAdmin but now my component in Joomla 3.x does't work i only get a connexion error in my browser.

If someone have an idea to resolve this, I only want to add a blank line in my list

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

9 năm 5 tháng trước - 9 năm 5 tháng trước #860 bởi Michaël Brantus
Replied by Michaël Brantus on topic Joomla 3.x - About the SQL query field type limits
I reply to myself

When i modify the SQL query with my code editor it works !

It was just a problem with the quotes converted in html quotes

&quote

Last edit: 9 năm 5 tháng trước by Michaël Brantus.
Những thành viên sau(s) đã Cảm ơn: Andres Maeso

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

Thời gian tải trang: 0.047 giây
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.