Questions

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

Select Case - Multiple Expressions

Hello.. Was curious if there's a way to specify multiple expressions in a select/case setup. My code example is below. Districts 04 and 06 are technically the same, as is 11 and 12 and the information contained in the case statements will display the same information. But I can't specify multiple expressions so there's multiple case statements. Thanks.. http://dnndev.com/fiddle/fid/789
caseexpressionselect
0 votes
3 responses
1699 views
Jeff M. asked Mar 3, 2020 active Mar 3, 2020

Clear SearchSort FilterExpression

I am using the SearchSort functionality to find records in my table. If the user searches for something that doesn't exist I was hoping to use the "NoItemsTemplate" to show a simple message "No records found" and a CommandButton that would reset the select statement to my initial SELECT * FROM.... However, I can't seem to get the select statement to work. The command button works (I think) but the
FilterfilterexpressionsearchSearchsortselect
0 votes
1 responses
2312 views
Bryan Lynn asked May 2, 2018 active May 3, 2018

Select Case question - evaluate zero

I have as stored procedure that returns an integer output parameter (count of existing records matching criteria) In a template I am evaluating the output parameter and if it is less than or equal to 3 an Add button is displayed. Else, nothing is displayed. How do I evaluate the zero (0) that is returned by the sproc when no records meet the criteria? I'm basically looking for an OR using Select C
caseORreturn parameterselect
0 votes
1 responses
2236 views
Mark Guercio asked Jul 31, 2017 active Jul 31, 2017

When is SQL evaluated when contained in xmod:select?

Hi Xmod gurus, I think I suspect the answer to this question, but you guys have often surprised me with solutions outside the box! I've been trying to use the <xmod:select> statement as a type of input validation, and have not been having too much luck. We have an xmod template that returns training course information based on a courseID in the query string parameters, e.g. "?courseID=232050".
selectSQLvalidation
0 votes
1 responses
2333 views
Fenske asked Jul 6, 2016 active Jul 6, 2016

Imbeded Case in Template whilst evaluating a Case

Hi There I have a situation, where I wish to include a case within a case <Xmod:select> <Case 1> </Case 1> <Case 2 > <Case 2.1> Only show where both Case 2 and Case 2.1 is true </Case 2.1> </Case 2> </xmod:select> Do I need to include the embedded one with it's own select? Will this actually work? Is there another way to achieve the result?
caseselecttemplate
0 votes
1 responses
2541 views
Steven Lawer asked May 25, 2016 active May 25, 2016

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).