sqldatasource
-
i'm using sqldatasource in order to search a table item with the column name. I want to search Name column for any word containing any letter found in the text box control. I tried to write the following: SELECT Name, Email FROM Item WHERE CONTAINS (Name , @Name) The following error appears: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Item' because it is not full-text indexed. could you please help me. thanks
-
i'm using sqldatasource in order to search a table item with the column name. I want to search Name column for any word containing any letter found in the text box control. I tried to write the following: SELECT Name, Email FROM Item WHERE CONTAINS (Name , @Name) The following error appears: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Item' because it is not full-text indexed. could you please help me. thanks
-
i'm using sqldatasource in order to search a table item with the column name. I want to search Name column for any word containing any letter found in the text box control. I tried to write the following: SELECT Name, Email FROM Item WHERE CONTAINS (Name , @Name) The following error appears: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Item' because it is not full-text indexed. could you please help me. thanks
Are you using OLEDB or SQL, there are Some SQL Functions that are not Available in OLEDB like you cant substring in OLEDB instead you MID.
SELECT Name, Email FROM Item
WHERE Name like '%@Name%'Hope this Helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-