116 Posts
nycxav
10 years ago
Topic
Hi, 
I am using the Select Dynamic Cascade Plugin with the Free SQL query option. 
Thanks to posts on this forum I figured out how to make it (partially) work and in my form the dynamic lists are populating as I expect. 

However when I save the content II get an SQL error message (see below). Obviously the problem comes from [parent] but this is the way it has to be configured for the lists to work in the form. 

Help appreciated. 

Thanks.
Xav.

0 SQL=SELECT y.job_type_name AS text, y.id AS value FROM fqe_cck_store_form_job_title i , fqe_cck_store_form_job_type y WHERE i.id=[parent] AND y.job_type_category=i.job_title_category
Get a VIP membership
116 Posts
nycxav
10 years ago
0
Level 1
Hi, 

Answering my own question:

I was eventually able to make my query fit as "construction" instead of "free" by putting the two tables and their alias in the table field. I also managed to make it work by removing the "mandatory" values for parent and value in the database if I used the "free" query type. 

I had other queries for which I had issues with the size of the table fields in the Select Dynamic Cascade (too many characters for the series of tables) that I solved by creating an SQL view with a shorter name. 

I had a problem to save the values though with the second option but I solved it by declaring the method as "POST" instead of "GET". (I have another topic for this specific issue).

Regards.
Xav.
Get a VIP membership