jquery - SCRIPT5007: Unable to get property 'settings' of undefined or null reference -
create function [dbo].[pmurp_func_parsearray] (@array varchar(1000),@separator char(1)) returns @t table (extractwords varchar(50)) begin --declare @t table (col1 varchar(50)) -- @array array wish parse -- @separator separator charactor such comma declare @separator_position int -- used locate each separator character declare @array_value varchar(1000) -- holds each array value returned -- loop work need separator @ end. -- left of separator character each array value set @array = @array + @separator -- loop through string searching separtor characters while patindex('%' + @separator + '%', @array) <> 0 begin -- patindex matches pattern against string select @separator_position = patindex('%' + @separator + '%',@array) select @array_value = left(@array, @separator_position - 1) -- process values passed. insert @t values (@array_value) -- replace select statement processing -- @array_value holds value of element of array -- replaces processed , empty string select @array = stuff(@array, 1, @separator_position, '') end return end
and
select description bad_names description in (select * dbo.pmurp_func_parsearray('bala',' '))
and
description,name_id pk_badnames nonclustered, unique, primary key located on primary description
in situation, have <form></form>
inside <form></form>
causing error.
Comments
Post a Comment