help about cascade dropdown with sql data

More
7 years 11 months ago #65394 by agbandini
at the end, I've found a very unprofessional solution, I've copied ALL the second table data in the raw editor (in the correct format) end disabling "use sql", it works.
This is an horrible solution, but works.
I can only suggest to the flexicontent staff to check this sql problem about the dropdown because I think there is a BUG.

Thank you
Ciao

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

More
7 years 11 months ago #65459 by lomuyeh

agbandini wrote: Yes, I want to put the where statement....but the corrent sitax?

in the second dropdown query I've to write
select tab2_id as value, tab2_name as text, tab2_id_tab1 as valgrp from table2 where valgrp = #TO_WHAT?#

Suggestions?

thank you


You need to add "_valgrp_in_" after "where". It's in the tip of the field. :)

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

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.420 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline