Problems running full-text

[Antonio Maciel]

Hi.

I have a stored procedure that runs a query using full-text. In my code, I
create a string variable with the full-text expression ans pass this
variable to a paramter in my procedure, in order to avoid dynamic sql in my
stored procedure. My variable is created this way:

strSearchParam = "'""" & strSearch & """'" 'Here I concatenate my search
phrase with double quotes and plics

If I cut and paste the variable contents in my query analyzer, the procedure
runs ok. If I call the procedure from VB.NET passing the variable as a
parameter the procedure returns no rows. Is my concatenation wrong?

Thanks,

Antonio Maciel

 

[Mary Chipman]

Probably. Test it in QA against the stored procedure using the T-SQL
debugger. You may be overdoing the delimiters.

-- Mary
MCW Technologies
http://www.mcwtech.com