invalid length parameter passed to the left or substring function - Databases

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

时尚的胡萝卜 · 全球光模块供应商 TOP10 排行榜变化–电子街· 1 月前 ·

粗眉毛的松鼠 · Improved Sale Badges ...· 1 月前 ·

卖萌的自行车 · 命啊！阿根廷再次魔咒重演 ...· 3 月前 ·

微笑的白开水 · 北京50家综合医院门诊患者自杀意念及自杀未遂 ...· 6 月前 ·

安静的黄豆 · 【全职猎人】卡金帝国第一王子——本杰明·灰郭 ...· 6 月前 ·

Hi,I’, getting the above error when I run the below code

WHEN PATINDEX('/courses/%/pages/%', url) >= 1 AND PATINDEX('%?%', url) >= 1 THEN SUBSTRING(LEFT(url,CHARINDEX('?',url)), CHARINDEX('/pages/',url,0)+7,(CHARINDEX('/', REVERSE(url), 1)-CHARINDEX('?', REVERSE(url), 1))-1) WHEN PATINDEX('/courses/%/pages/%', url) >= 1 AND PATINDEX('%?%', url) = 0 THEN SUBSTRING(url, CHARINDEX('/pages/',url,0)+7,1000) WHEN PATINDEX('/courses/%/pages', url) >= 1 THEN 'pages-list' ELSE '' END AS wiki_url

It looks like some of your input data is causing the problem.

To find out what it is, you may need to change your code to some debug code such as using print statements to see values.

Try something like this:

WHEN PATINDEX('/courses/%/pages/%', url) >= 1 AND PATINDEX('%?%', url) >= 1 --SUBSTRING(LEFT(url,CHARINDEX('?',url)), CHARINDEX('/pages/',url,0)+7,(CHARINDEX('/', REVERSE(url), 1)-CHARINDEX('?', REVERSE(url), 1))-1) begin print '---' print url print LEFT(url,CHARINDEX('?',url)) print CHARINDEX('/pages/',url,0)+7 print (CHARINDEX('/', REVERSE(url), 1)-CHARINDEX('?', REVERSE(url), 1))-1 print '---' WHEN PATINDEX('/courses/%/pages/%', url) >= 1 AND PATINDEX('%?%', url) = 0 --SUBSTRING(url, CHARINDEX('/pages/',url,0)+7,1000) begin print '===' print url print CHARINDEX('/pages/',url,0)+7 print '===' WHEN PATINDEX('/courses/%/pages', url) >= 1 THEN 'pages-list' ELSE '' END AS wiki_url

Looks like it blows up when /courses/%/pages/% comes before the first ‘?’ ?

WHEN PATINDEX('/courses/%/pages/%', @url) >= 1 AND PATINDEX('%?%', @url) < PATINDEX('/courses/%/pages/%', @url) SUBSTRING(LEFT(@url,CHARINDEX('?',@url)), CHARINDEX('/pages/',@url,0)+7 ,(CHARINDEX('/', REVERSE(@url), 1) -CHARINDEX('?', REVERSE(@url), 1))-1) WHEN PATINDEX('/courses/%/pages/%', @url) >= 1 AND PATINDEX('%?%', @url) > PATINDEX('/courses/%/pages/%', @url) 'something else' WHEN PATINDEX('/courses/%/pages/%', @url) >= 1 AND PATINDEX('%?%', @url) = 0 THEN SUBSTRING(@url, CHARINDEX('/pages/',@url,0)+7,1000) WHEN PATINDEX('/courses/%/pages', @url) >= 1 THEN 'pages-list' ELSE '' END AS wiki_url