Back

Flexi Time System

DotNetNuke Search Problem Not Returning Results

The Dot Net Nuke search Engine only finds exact matches of the search word, since the stored procedure for it uses a '=' and not 'like'.

Therefore if you search for "trees" you will not find "tree".

If you change the following line in the stored procedure

AND (sw.Word = @Word) to either

AND (sw.Word like @Word)

or you can use the SQL-Server wildcards within your searchwords as in the example below to return more results.

AND (sw.Word like '%' + @Word + '%')

Back


Make a Comment on this Article

Your Name:
Comment:

 

Net-Aspect Wakefield (West Yorkshire) Web Design Services Call 01924 918 177