Hello all..
I'm going through the book and I'm at the point where I setup the 01.00.00.SqlDataProvider and when I manually check the script for errors in SSMS by parsing it I get several errors refering to Incorrect syntax near '{'. Which almost completely revlove around {databaseOwner}.
I thought I may have missed something along the way so I downloaded the code from the Wrox site and even that script says the same error. I was wondering is this something that will through an error when I attempt to install the module?
The script details are below please let me know if I've missed something..
Code:
/************************************************************/
/***** SqlDataProvider *****/
/***** *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for {databaseOwner} and {objectQualifier} *****/
/***** *****/
/************************************************************/
/** Create Table **/
if not exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]') and OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
CREATE TABLE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
(
[ModuleId] [int] NOT NULL,
[EntryId] [int] NOT NULL IDENTITY(1, 1),
[SubmitterName] nvarchar(255) NOT NULL,
[SubmitterWebsite] nvarchar(255),
[SubmitterComment] ntext,
[SubmissionDate] DateTime NOT NULL,
[IsApproved] BIT NOT NULL
)
ALTER TABLE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
ADD CONSTRAINT [PK_{objectQualifier}DNNModuleProgramming_CS_Guestbook]
PRIMARY KEY CLUSTERED ([EntryId])
CREATE NONCLUSTERED INDEX [IX_{objectQualifier}DNNModuleProgramming_CS_Guestbook]
ON {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
([ModuleID])
ALTER TABLE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook] WITH NOCHECK
ADD CONSTRAINT [FK_{objectQualifier}DNNModuleProgramming_CS_Guestbook_{objectQualifier}Modules]
FOREIGN KEY ([ModuleID])
REFERENCES {databaseOwner}[{objectQualifier}Modules]
([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION
END
GO
/** Drop Existing Stored Procedures **/
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_InsertGuestbookEntry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_InsertGuestbookEntry]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_ApproveGuestbookEntry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_ApproveGuestbookEntry]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_DeleteGuestbookEntry]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_DeleteGuestbookEntry]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetApprovedEntries]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetApprovedEntries]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetAllEntries]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetAllEntries]
GO
/** Create Stored Procedures **/
CREATE PROCEDURE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_InsertGuestbookEntry]
@ModuleId INT,
@SubmitterName NVARCHAR(255),
@SubmitterWebsite NVARCHAR(255),
@SubmitterComment NTEXT,
@SubmissionDate DATETIME,
@IsApproved BIT
AS
INSERT INTO {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
(ModuleId, SubmitterName, SubmitterWebsite, SubmitterComment, SubmissionDate, IsApproved)
VALUES
(@ModuleId, @SubmitterName, @SubmitterWebsite, @SubmitterComment, @SubmissionDate, @IsApproved)
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_ApproveGuestbookEntry]
@ModuleId INT,
@EntryId INT
AS
UPDATE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
SET IsApproved = 1
WHERE ModuleId = @ModuleId
AND EntryId = @EntryId
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_DeleteGuestbookEntry]
@ModuleId INT,
@EntryId INT
AS
DELETE FROM {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
WHERE ModuleId = @ModuleId
AND EntryId = @EntryId
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetApprovedEntries]
@ModuleId INT
AS
SELECT
ModuleId,
EntryId,
SubmitterName,
SubmitterWebsite,
SubmitterComment,
SubmissionDate,
IsApproved
FROM {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
WHERE ModuleId = @ModuleId
AND IsApproved = 1
ORDER BY SubmissionDate DESC
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_GetAllEntries]
@ModuleId INT
AS
SELECT
ModuleId,
EntryId,
SubmitterName,
SubmitterWebsite,
SubmitterComment,
SubmissionDate,
IsApproved
FROM {databaseOwner}[{objectQualifier}DNNModuleProgramming_CS_Guestbook]
WHERE ModuleId = @ModuleId
ORDER BY SubmissionDate DESC
GO
/************************************************************/
/***** SqlDataProvider *****/
/************************************************************/
Thanks in advance.
Bob
Incorrect syntax near '{'.
