Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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))
AS 
BEGIN
--DECLARE @T Table (col1 varchar(50))
-- @Array is the array we wish to parse
-- @Separator is the separator charactor such as a comma
DECLARE @separator_position INT -- This is used to locate each separator character
DECLARE @array_value VARCHAR(1000) -- this holds each array value as it is returned
-- For my loop to work I need an extra separator at the end. I always look to the
-- left of the separator character for each array value

SET @array = @array + @separator

-- Loop through the string searching for separtor characters
WHILE PATINDEX('%' + @separator + '%', @array) <> 0 
BEGIN
-- patindex matches the a pattern against a string
SELECT @separator_position = PATINDEX('%' + @separator + '%',@array)
SELECT @array_value = LEFT(@array, @separator_position - 1)
-- This is where you process the values passed.
INSERT into @T VALUES (@array_value) 
-- Replace this select statement with your processing
-- @array_value holds the value of this element of the array
-- This replaces what we just processed with and empty string
SELECT @array = STUFF(@array, 1, @separator_position, '')
END
RETURN 
END

and

Select Description from Bad_Names WHERE Description in (Select * from dbo.PMURP_Func_ParseArray('bala',' '))

and

Description,Name_ID
PK_BadNames nonclustered, unique, primary key located on PRIMARY    Description
like image 636
Rooney Avatar asked Dec 20 '22 02:12

Rooney


2 Answers

In my situation, I have a <form></form> inside a <form></form> which causing this error.

like image 75
Tuyen Nguyen Avatar answered Jan 31 '23 09:01

Tuyen Nguyen


My issue with this error was related to Tuyen Nguyen answer --one form tag inside another form tag.

While using a Bootstrap modal dialog div-- a container for a partial view for a form--

<div id="modal-container" class="modal fade" tabindex="-1" role="dialog">

I incorrectly placed the modal-container div in a @using Html.BeginForm statements tags which was causing the Script 5007 error.

Placing it outside the braces of Html.BeginForm makes the error go away

@using (Html.BeginForm("Edit", "Home", FormMethod.Post))
{

 }
like image 27
jfbouz23 Avatar answered Jan 31 '23 11:01

jfbouz23