hello all,

i am suing mysql database and self servicing

i have following code :

JobdetailsCollection jobSearch = new JobdetailsCollection();
        PredicateExpression JobFilter = new PredicateExpression();
JobFilter.Add(new FieldFullTextSearchPredicate(JobdetailsFields.SearchDescription, null, FullTextSearchOperator.Contains, txtKeyword.Text));

jobSearch.GetMulti(JobFilter);

it gives error like this : Object reference not set to an instance of an object. on This line :jobSearch.GetMulti(JobFilter);

can you please help me.

Hello all,

sorry again, i have modify the following code :

JobFilter.Add(new FieldFullTextSearchPredicate(JobdetailsFields.SearchDescription, FullTextSearchOperator.Contains, txtKeyword.Text));

so now it is not throw error and not getting result.

in my database i have following string :

"Software Engineer with 2 year ex. in Microsoft technology"

now i am entering keyword in my textbox(txtKeyword.Text) : Microsoft and click on search button.

so it is not giving me any result.

please help me

Is your full text index up to date?

Would you please examine the generated SQL query and run it manually against the database and see if it returns any records.

Walaa wrote:

Is your full text index up to date?

Would you please examine the generated SQL query and run it manually against the database and see if it returns any records.

still not getting output. so i have implement like but it is not working 100%

The FullTextSearchOperator is SQL Server specific, unfortunalty it will not work against your MySQL database.

Matt