Figured it out -- thanks for the help and a bit of playing on my own:
SELECT *
FROM MAC
WHERE RequestedBy LIKE '%MMColParam%'
I was missing the LIKE and then in the default value for the variable you put %
Thanks for putting me on the right track.
SELECT *
FROM MAC
WHERE RequestedBy = '%MMColParam%'
Alright the SQL Statement looks like this.
Under the box for "variables" in UltraDev it says
Name Default Value Runtime value
MMColParam What do I put here? Request.QueryString("RequestedBy")
Just putting the %...
I'm new to this and never been able to get this to work. I have a text box for a search. Where I want a user to search for their request by their name -- but I want to allow them to put only a partial name or just their last name, not to be a literal string search match.
So using the simple...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.