Forums
This topic is locked
Nested Repeat Region
Posted 21 years ago
1
has voted
21 years ago Chris Holloway posted:
I am calling multiple phrases from 2 seperate tables and then I want to combine them. For exampleTable 1 : Florida, Georgia, Texas
Table 2 : apples, pears, oranges
Now I want to display the following :
Flordia apples
Florida Pears
Florida Oranges
Georgia apples
Georgia Pears
Georgia Oranges
etc.
etc.
I've got the MX_Looper suite but you need to have another field to link the two together. I don't have that because these terms are being selected dynamically using checkboxes from 150+ phrases in table.
any suggestions ?
Replies
Replied 21 years ago
21 years ago D J replied:
I've got the same problem!!
Replied 21 years ago
21 years ago Vince Baker replied:
You need to do this in the sql rather than on the page.
In order to pull all results as you want I beleive you can use the Union command in your SQL statement (beena few years since I used it) Do a search on google for Union join and you should find the code you need.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
In order to pull all results as you want I beleive you can use the Union command in your SQL statement (beena few years since I used it) Do a search on google for Union join and you should find the code you need.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting