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".

[Back to original message]