Questions

Questions Filter:
All Unanswered Answered My Questions My Answers
Tag Filter:

Use of Case for dependent dropdown in template

Hi I'm a bit confused on using the case statement and if I should even be using it for this purpose? I have 2 dropdowns in different Template sections being pulled from a database. I want to have the second dropdown only display the cities relating to the countryID in the first dropdown, the country values are 6, 7 and 8. The code below works for only showing item 6 on the second dropdown but when
casedependentdropdownSQL
0 votes
4 responses
2026 views
Harry Allan asked May 20, 2015 active May 20, 2015

Getting Good Answers

How do you get good answers to your questions?   Ask good questions. That means:

  1. Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  2. Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
  3. Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples. 
  4. Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).