error after post RSS

• • Reply
  

  dkekish

  Member

  125 Points

  25 Posts

  error after post

  Aug 05, 2004 02:41 AM|LINK

  I'm getting this error: Post operation failed. The error message related to this problem was as follows: Invalid object name 'iter_charlist_to_table'. after i try to post an update to a post. Any ideas? Thanks Dave Kekish
• • Reply
  

  ScottW

  Contributor

  3651 Points

  730 Posts

  ASPInsiders

  Re: error after post

  Aug 05, 2004 05:39 AM|LINK

  You are either missing or do not have the correct permissions assigned to the iter_charlist function. -Scott
  Scott Watermasysk
  http://www.scottw.com
• • Reply
  

  dkekish

  Member

  125 Points

  25 Posts

  Re: error after post

  Aug 05, 2004 11:35 AM|LINK

  ok, since this is a single user blog, how do I correct the above. I have no problems running other functions on the site except for Admin-Options-Configure which gives me an object instantiation error. Thanks for the reply. Dave
• • Reply
  

  ScottW

  Contributor

  3651 Points

  730 Posts

  ASPInsiders

  Re: error after post

  Aug 05, 2004 12:30 PM|LINK

  iter_charlist is a function in SQL server. First check to see if it is there, if it is, make sure you assign it the correct permissions. :) -Scott
  Scott Watermasysk
  http://www.scottw.com
• • Reply
  

  dkekish

  Member

  125 Points

  25 Posts

  Re: error after post

  Aug 05, 2004 12:43 PM|LINK

  Thanks for the help. I didn't have the right permissions on it. Thanks once again Dave Kekish www.meandering-blog.com
• • Reply
  

  Uglytruth

  Member

  233 Points

  47 Posts

  Re: error after post

  Jan 24, 2005 05:05 PM|LINK

  How do I create the fuction if it is not there?
• • Reply
  

  dkekish

  Member

  125 Points

  25 Posts

  Re: error after post

  Jan 24, 2005 05:09 PM|LINK

  CREATE FUNCTION iter_charlist_to_table (@list ntext, @delimiter nchar(1) = N',') RETURNS @tbl TABLE (listpos int IDENTITY(1, 1) NOT NULL, str varchar(4000), nstr nvarchar(2000)) AS BEGIN DECLARE @pos int, @textpos int, @chunklen smallint, @tmpstr nvarchar(4000), @leftover nvarchar(4000), @tmpval nvarchar(4000) SET @textpos = 1 SET @leftover = '' WHILE @textpos <= datalength(@list) / 2 BEGIN SET @chunklen = 4000 - datalength(@leftover) / 2 SET @tmpstr = @leftover + substring(@list, @textpos, @chunklen) SET @textpos = @textpos + @chunklen SET @pos = charindex(@delimiter, @tmpstr) WHILE @pos > 0 BEGIN SET @tmpval = ltrim(rtrim(left(@tmpstr, @pos - 1))) INSERT @tbl (str, nstr) VALUES(@tmpval, @tmpval) SET @tmpstr = substring(@tmpstr, @pos + 1, len(@tmpstr)) SET @pos = charindex(@delimiter, @tmpstr) END SET @leftover = @tmpstr END INSERT @tbl(str, nstr) VALUES (ltrim(rtrim(@leftover)), ltrim(rtrim(@leftover))) RETURN END