ASP.NET

Brady Kelly wrote:

I have a grid form that uses our internal framework to open a popup for a detail form. I can't yet modify our framework to allow me to pass a callback function for the popup form

Brady Kelly wrote:

like to hard-code the callback into the popup.

DECLARE @String nvarchar (4000)<br />
DECLARE @Delimiter nvarchar (10)<br />
<br />
SET @String = '12,13,14'<br />
SET @Delimiter = ','<br />
<br />
declare @NextString nvarchar(4000)<br />
declare @Pos int<br />
declare @NextPos int<br />
declare @CommaCheck nvarchar(1)<br />
 <br />
 --Initialize<br />
 set @NextString = ''<br />
 set @CommaCheck = right(@String,1) <br />
 <br />
 --Check for trailing Comma, if not exists, INSERT<br />
 --if (@CommaCheck <> @Delimiter )<br />
 set @String = @String + @Delimiter<br />
 <br />
 --Get position of first Comma<br />
 set @Pos = charindex(@Delimiter,@String)<br />
 set @NextPos = 1<br />
 <br />
 --Loop while there is still a comma in the String of levels<br />
 while (@pos <>  0)  <br />
 begin<br />
  set @NextString = substring(@String,1,@Pos - 1)<br />
 <br />
  PRINT @NextString<br />
 <br />
  set @String = substring(@String,@pos +1,len(@String))<br />
  <br />
  set @NextPos = @Pos<br />
  set @pos  = charindex(@Delimiter,@String)<br />
 end<br />
 <br />

InsDev wrote:

if(@start = 0)
Begin
select substring(@exp,@start+1,2)
return
end