This content has been marked as final. Show 4 replies
Your problem is here:
AND keywords LIKE '#arguments.keywords#'
First, you are using the like keyword without wildcards. Second, if your users can submit more than one keyword in a textbox, your still have a logic problem.
Turn on debugging and submit any two keywords. Then look at the sql that gets generated. It probably doesn't resemble what you had hoped for.
Thanks for the update.
Is there anyplace to find good information on how to create a working search
engine like that I have where a user can enter one or more keywords?
I have heard good things about the book Teach Yourself SQL in 10 Minutes by Ben Forta.
Anything more specific such as a online tutorial or what to look for in
another SQL book?