PrepareFtsJoin Method

In This Topic

Sets up the join statement needed to execute a full text search with ranked sorting

Syntax

public static string PrepareFtsJoin( 
   string tableName,
   string columnList,
   string parameterName,
   string ftsKeyColumn
)

Parameters

tableName: Name of the table being searched
columnList: The column(s) being searched, multiple columns should be comma delimited with no spaces.
parameterName: The name to use for the SQL parameter.
ftsKeyColumn: The key column to use for the free text table join. This must include table prefix if required.

Return Value

Prepared FTS Join

Remarks

It is assumed that the caller knows FTS is supported for the given table, columns, and search pattern

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

KeywordSearchHelper Class
KeywordSearchHelper Members

Send Feedback