Posted by John Bell on 12/27/06 20:18

Hi Ryan

Have you read http://www.sommarskog.se/dyn-search.html ?

John

<EvoEight@gmail.com> wrote in message
news:1167243921.772666.90520@79g2000cws.googlegroups.com...
> 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
>

[Back to original message]