it says

Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'default'.

any help?

any help please i got to make decision fast

iam also confused in using mssql full text search feature, do i need to have a column and store the doc files in that column or i will be able...

well thank you for your answer, but you have not read it fully, they are asking me to contact microsoft for a licence.

how about installing MSDE its free?, will it...

thank you gila, but my hosting co. now says there sql server dont support full text search

damn what a waste of time

what is the db are you using, and show me the exact query you tried, you need to use like instead of "="

you need to seperate words in a where clause

where w.word like'<%= sKeyword %> and w.word like'<%= sKeyword %>

for sepeate words

for example vb,asp

can any one tell me atleast 2,3 queries atleast to get started.

iam trying queries , it says you dont have permission to set full text index.

i will need some correct...

it is a search query, generated based on user selection and unselection

input can be number or text

sp_executesql looks more easy , i guess i will use that

but then will it be giving me the benfits of compiled sql query, iam looking for more speed in query...

you may be right, i will have to give more time to it, see it test it again and again,

then i might be able to solve it

prenthesis are correct, still it gives strange results sometimes,

time will solve it automatically i guess,

till then lets see

how can i check whether it is case sensitive or not.

iam using ms-access 2003

the problem still continues

now iam getting the results but they are not what they should be, some...

SELECT candidatesRegistration.CANDIid as CANDIid,candidatesRegistration.firstname as firstname, candidatesRegistration.lastname as lastname, candidatesRegistration.keywords as Skills,candidatesRegistration.lastlogin as lastlogin, candidatesRegistration.education as Edu,candidatesRegistration.university as univ, candidatesRegistration.certification as certification,candidatesRegistration.totalexp as totalexp ,candidatesRegistration.companyname,candidatesRegistration.designation FROM candidatesRegistration where 1=1 and...