Did you look for Unicorns? I hear they can run in infinite loops. Judah
On Thu, Apr 19, 2012 at 4:17 PM, Brian Thornton <[email protected]> wrote: > > This is running into an infinite loop... Any ideas? It just runs and runs... > > > USE [UOS1] > GO > > /****** Object: UserDefinedFunction [dbo].[makePictureName] Script > Date: 04/19/2012 14:13:22 ******/ > SET ANSI_NULLS ON > GO > > SET QUOTED_IDENTIFIER ON > GO > > ALTER FUNCTION [dbo].[makePictureName] > (@s varchar(256), > @id int) > RETURNS varchar(50) AS > BEGIN > declare @finalText varchar(256) > declare @origText varchar(256) > declare @i int > declare @j int > declare @k int > > select @s = replace(@s,' - ',' ') > select @i = patindex('%[^a-zA-Z0-9 ]%', @s) > while @i > 0 > begin > select @s = replace(@s, substring(@s, @i, 1), '') > select @i = patindex('%[^a-zA-Z0-9 ]%', @s) > end > set @finalText = lower(replace(@s,' ','-')) > set @finalText = left(@finalText,46) > set @origText = @finalText > set @j = 1 > set @k = 1 > > while @j > 0 > begin > set @j = (select count(*) from item where picturename = @finalText > + '.jpg' AND id <> @id) > if (@j > 0) set @finalText = @origText + cast(@k as varchar(3)) > set @k = @k + 1 > end > > return @finalText + '.jpg' > END > GO > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:350143 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm
