Posted by EvoEight@gmail.com on 12/27/06 18:25

I'm writing a search for our site and I'm running into a few problems.
When I run the query like this, it runs just fine:

Declare @Keywords varchar(2000)
Select @Keywords = 'modern trial advocacy canada'
Select product_id, name, count(name) hits
FROM estore_products
INNER JOIN sequence
ON estore_products.name like '%' +
Substring(' ' + @keywords + ' ',seq,
CharIndex(' ' , ' ' + @keywords + ' ' , seq) - seq)
+ '%'
WHERE
seq <= len(' ' + @keywords + ' ') and
Substring(' ' + @keywords + ' ', seq - 1, 1) = ' ' and
CharIndex(' ' , ' ' + @keywords + ' ' , seq) - seq > 0
Group by estore_products.product_id, name
ORDER BY Hits DESC

But when I add another column (for example a column called description)
from the select statement I get this error:

The text, ntext, and image data types cannot be compared or sorted,
except when using IS NULL or LIKE operator.

Long story short, what do I need to do to select more columns for the
final output?

Thanks,
Ryan

• Next in forum: Re: Selecting last date
• Prev in forum: putting names of objects to control-flow loop creating objects
• Thread view: Site Search Code Help

[Reply to this message]