Questions

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.

0 votes

3 responses

2348 views

Jen Sharp asked Nov 28, 2016 active Dec 2, 2016

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