[dbo].[Forum_FilterWordGetByWord]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_FilterWordGetByWord

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@FilteredWord	nvarchar(50)	100
@PortalID	int	4

SQL Script

/* Users */
CREATE PROCEDURE dbo.[Forum_FilterWordGetByWord]
@FilteredWord nvarchar(50),
@PortalID int
AS
DECLARE @@WordCount int

SET @@WordCount = (
SELECT
    Count(ItemID)
FROM
    dbo.Forum_FilterWords
WHERE
    PortalID = @PortalID
AND
    BadWord = @FilteredWord
)

IF @@WordCount > 0
BEGIN
SELECT (1)
END
ELSE
BEGIN
SELECT (0)
END

GO

Uses

[dbo].[Forum_FilterWords]
dbo