Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

full text search - FullText In Microsoft Sql Server - Returning exactly word -


can tell me how query fulltext table in sql server, , matches? example:

i have records in table named "items":

bath
bathroom
test
testing

i need query bath , 1 record, "bath", excluding word bathroom. same word "test", wich in context different "testing".

have tried

select column1, column2, ... [itens] ft_tbl inner join    containstable([itens], *, 'bath') key_tbl    on ft_tbl.unique_key_column = key_tbl.[key] 

http://msdn.microsoft.com/en-us/library/ms189760.aspx


or

select columnname [itens] contains(somecolumn, 'bath') 

http://msdn.microsoft.com/en-us/library/ms187787.aspx


just noticed updated questions (formatting applied). if column holds keywords (single word) select column = 'keyword'.

select columnname [itens] somecolumn = 'bath' 

Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -