Revision: 1911
http://svn.sourceforge.net/subtext/?rev=1911&view=rev
Author: simo
Date: 2006-10-30 07:35:39 -0800 (Mon, 30 Oct 2006)
Log Message:
-----------
Fixed an error in one SP
Modified Paths:
--------------
trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
Modified: trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql
===================================================================
--- trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql 2006-10-29 22:18:33 UTC (rev 1910)
+++ trunk/SubtextSolution/Subtext.Installation/Scripts/StoredProcedures.sql 2006-10-30 15:35:39 UTC (rev 1911)
@@ -4520,11 +4520,40 @@
GO
+
+
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
+CREATE PROC [<dbUser,varchar,dbo>].[subtext_UpdatePluginData]
+(
+ @PluginID uniqueidentifier,
+ @BlogID int,
+ @EntryID int,
+ @Key nvarchar(256),
+ @Value ntext
+)
+AS
+
+UPDATE [<dbUser,varchar,dbo>].[subtext_PluginData]
+SET
+ [Value]=@Value
+FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
+WHERE [<dbUser,varchar,dbo>].[subtext_PluginBlog].PluginID=@PluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].BlogID=@BlogID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].[Id]=[<dbUser,varchar,dbo>].[subtext_PluginData].BlogPluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].Enabled=1 AND [Key]=@Key AND EntryID=@EntryID
+GO
+SET QUOTED_IDENTIFIER OFF
+GO
+SET ANSI_NULLS ON
+GO
+
+SET QUOTED_IDENTIFIER OFF
+GO
+SET ANSI_NULLS OFF
+GO
+
+
CREATE PROC [<dbUser,varchar,dbo>].[subtext_InsertPluginData]
(
@PluginID uniqueidentifier,
@@ -4537,7 +4566,7 @@
DECLARE @BlogPluginID int
-SELECT Id FROM [<dbUser,varchar,dbo>].[subtext_PluginData]
+SELECT @BlogPluginID=[Id] FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
WHERE PluginID=@PluginID AND BlogID=@BlogID
INSERT INTO [<dbUser,varchar,dbo>].[subtext_PluginData]
@@ -4562,32 +4591,7 @@
SET ANSI_NULLS ON
GO
-SET QUOTED_IDENTIFIER OFF
-GO
-SET ANSI_NULLS OFF
-GO
-CREATE PROC [<dbUser,varchar,dbo>].[subtext_UpdatePluginData]
-(
- @PluginID uniqueidentifier,
- @BlogID int,
- @EntryID int,
- @Key nvarchar(256),
- @Value ntext
-)
-AS
-
-UPDATE [<dbUser,varchar,dbo>].[subtext_PluginData]
-SET
- [Value]=@Value
-FROM [<dbUser,varchar,dbo>].[subtext_PluginBlog]
-WHERE [<dbUser,varchar,dbo>].[subtext_PluginBlog].PluginID=@PluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].BlogID=@BlogID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].[Id]=[<dbUser,varchar,dbo>].[subtext_PluginData].BlogPluginID AND [<dbUser,varchar,dbo>].[subtext_PluginBlog].Enabled=1 AND [Key]=@Key AND EntryID=@EntryID
-GO
-SET QUOTED_IDENTIFIER OFF
-GO
-SET ANSI_NULLS ON
-GO
-
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|