116 Posts
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.
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
116 Posts
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.
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.