UPDATETEXT Problems

• Dustin Dexter

  SSC Rookie

  Points: 31

  More actions

  December 10, 2004 at 1:52 pm

  #87120

  I am getting this error when I run the following script:

  Server: Msg 7135, Level 16, State 4, Procedure SearchReplace, Line 24

  Deletion length 5 is not in the range of available text, ntext, or image data.

   

  I dont get it.

   

  SET NOCOUNT ON

  DECLARE

  @TextPointer varbinary( 16 )

  DECLARE

  @DeleteLength int

  DECLARE

  @OffSet int

  SELECT

  @TextPointer = textptr( Body)

  FROM

  PageContent

  SET

  @DeleteLength = len( 'dev1/' )

  SET

  @OffSet = 0

  WHILE

  ( SELECT count( * )

  FROM

  PageContent

  WHERE patindex

  ( '%' + 'dev1/' + '%', Body) <> 0

  ) > 0

  BEGIN

  SELECT

  @OffSet = patindex( '%' + 'dev1/' + '%', Body) - 1

  FROM

  PageContent

  WHERE patindex

  ( '%' + 'dev1/' + '%', Body) <> 0

  PRINT

  @TextPointer

  Print

  @OffSet

  Print

  @DeleteLength

  END

  Return

   

   

• john-132685

  SSCertifiable

  Points: 6134

  More actions

  December 10, 2004 at 3:20 pm

  #533403

  You might want to post the full script, this piece doesn't do anything that would generate that error.