Posted by Ed Murphy on 01/02/07 23:39

Dan wrote:

> When I run this, some of the records concatenate properly but most dont
> with the same text being appended to the end of searchterms. i.e loads
> of results will end up with jkl tagged onto the end. I can't figure out
> when my loop is falliing over!!! Can anyone help?

I don't know /why/ the loop is doing the wrong thing, but adding some
debugging output after the UPDATETEXT line (e.g. SELECT * FROM SEARCH)
should at least reveal /when/ it's doing the wrong thing.

Also, I would seriously avoid columns named "id".

• Next in forum: vb.net/sql proficiency
• Prev in forum: Re: Changing a BIT to an INT where there's a CONSTRAINT and a DEFAULT
• Thread view: Re: Problem with Updatetext in SQL 2000 trying to concatenate multiple text fields

[Reply to this message]