dnndev.com

Questions

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

Using wildcard with parameter in CommandText

Answer Accepted
The SELECT statement I have in my CommandText includes a parameter with a value of [[Url:parametername]] and default value of "%" so it will show all records if the querystring isn't present. This all works great actually, save for one exception that I ran across. I can't figure out the syntax to put the wildcard % in the statement along with the parameter name. I tried these ways which failed: 1.
CommandTextparameterwildcard
0 votes
3 responses
2346 views
Jen Sharp asked Nov 28, 2016 active Dec 2, 2016

ListDataSource CommandText as a variable?

Hi is it possible to use a variable for theCommandText? My issue is that I want to filter items based on price high/low or duration high/low. My example is here: http://realrussia.co.uk/test/test-excursions/City?... I intend on adding 2 radio buttons or tick boxes that allow the options mentioned above. I would reload the page so that's not an issue but I need to be able to change the "duration" a
CommandTextListDatasourceSQL
0 votes
6 responses
2527 views
Harry Allan asked Jun 25, 2015 active Jun 25, 2015

Getting Good Answers

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

  • Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  • 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.
  • 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. 
  • 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).