×
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
Michaël Brantus
Yeni Üye
Posts: 4
9 yıl 5 ay önce #858
Yazan: Michaël Brantus
Joomla 3.x - About the SQL query field type limits, Michaël Brantus tarafından oluşturuldu
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
Now I need to add an empty value in my list using this query
If someone have an idea to resolve this, I only want to add a blank line in my list
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
This query works fine with my component in Joomla 3.xSELECT name, id FROM myTable ODER BY name
Now I need to add an empty value in my list using this query
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.SELECT name, id FROM myTable UNION '' as name, NULL as id ORDER BY name
If someone have an idea to resolve this, I only want to add a blank line in my list
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Michaël Brantus
Yeni Üye
Posts: 4
9 yıl 5 ay önce - 9 yıl 5 ay önce #860
Yazan: Michaël Brantus
Michaël Brantus tarafından Joomla 3.x - About the SQL query field type limits konusunda yanıtlandı
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
When i modify the SQL query with my code editor it works !
It was just a problem with the quotes converted in html quotes
"e
Son Düzenleme: 9 yıl 5 ay önce Düzenleyen:Michaël Brantus
Şu kullanıcı(lar) Teşekkür etti: Andres Maeso
Lütfen sohbete katılmak için Giriş ya da Hesap açın.
Sayfa oluşturma süresi: 0.050 saniye