Best Answer

If you are using FT DQL, then you shouldnt need to use database search using LIKE %. The ft_contain_fragment should be able to pick up partial values. Do you have stemming enabled - I dont recall if this is on by default or not?

0

Answers

Maybe I'm not understanding your question, but it sounds like your query is failing if the user does not provide a value for object_name to search against. If that's the case, why dont you just check for the existence of a value before you run your DQL. If the user doesnt provide search value, then either prompt them for a value or run your query without search criterion.

If you are using FT DQL, then you shouldnt need to use database search using LIKE %. The ft_contain_fragment should be able to pick up partial values. Do you have stemming enabled - I dont recall if this is on by default or not?