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
2 responses
2072 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
2315 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:

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