Searching with any order - Full Text Search Index

[howardthai]

this will help get more converison if customers can find what they are looking for. The search would go into the title , descritions and find the keywords and populate the search page with it. Its really needed.

howard

[Shopping Cart Admin]

Hello Howard,

Please give us a more detailed explanation of what you want. The better you explain your request, the more likely it can be voted on and added. Thank you!

[nickc]

Code: Select all

exec sp_fulltext_table @tabname=[ac_ProductSearchData], @action='activate'

- aggregate searchable text into a single table and bind it to SQL FTS
- cache the top "n" searches and expire them in time period "t" (global temp tables with GUID names works well for this)
- allow for admin demand-based FTS table rebuild and cache flush

[howardthai]

Is there a way you can explain it step by step on how to get that sp to work on the searching.

howard

[howardthai]

Just so that when customer search without buting the * to find the product info.