okay you might need to run this sql - if someone could help me on my dnn file with why its not reading and executing this right please contact me
/*
'**************************************************************************
'Codegalaxy FreeForm (c) 2005
'A simple module to allow site admins to set up a form that submits to
'another URL.
'Codegalaxy.com
'Programmer Dylan Barber
'Version 1.00.00 - First release
'Known Issues
' Submit only works on IE - only tested on a pc not a MAC
'**************************************************************************
*/
/************************************************************/
/***** SQLDataProvider *****/
/***** FreeForm *****/
/***** *****/
/***** Note: To manually execute this script you must *****/
/***** perform a search and replace operation *****/
/***** for {databaseOwner} and {objectQualifier} *****/
/***** *****/
/************************************************************/
/* Insert here the code to create tables and stored procs */
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}CodegalaxyFreeForm_AddAForm') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}CodegalaxyFreeForm_AddAForm
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}CodegalaxyFreeForm_GetAForm') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}CodegalaxyFreeForm_GetAForm
GO
if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}CodegalaxyFreeForm_UpdateAForm') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}CodegalaxyFreeForm_UpdateAForm
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}CodegalaxyFreeForm') and OBJECTPROPERTY(id, N'IsTable') = 1)
CREATE TABLE {databaseOwner}{objectQualifier}CodegalaxyFreeForm (
[ModuleID] [int] NOT NULL ,
[FormHTML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Method] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[FormAction] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CreatedByUser] [int] NOT NULL ,
[CreatedByDate] [datetime] NOT NULL ,
[ChangedByUser] [int] NOT NULL ,
[ChangedByDate] [datetime] NOT NULL
) ON [PRIMARY]
GO
if not exists (select * from dbo.sysobjects where id = object_id(N'PK_{objectQualifier}CodegalaxyFreeForm') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1)
ALTER TABLE {databaseOwner}{objectQualifier}CodegalaxyFreeForm ADD CONSTRAINT
PK_{objectQualifier}CodegalaxyFreeForm PRIMARY KEY CLUSTERED (ModuleID) ON [PRIMARY]
GO
ALTER TABLE {databaseOwner}{objectQualifier}CodegalaxyFreeForm WITH NOCHECK ADD
CONSTRAINT DF_{objectQualifier}CodegalaxyFreeForm_CreatedByDate DEFAULT (getdate()) FOR {objectQualifier}CreatedByDate,
CONSTRAINT DF_{objectQualifier}CodegalaxyFreeForm_ChangedByDate DEFAULT (getdate()) FOR {objectQualifier}ChangedByDate
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}CodegalaxyFreeForm_AddAForm
@ModuleID int,
@FormHTML ntext,
@Method varchar(10),
@FormAction varchar(2000),
@CreatedUser int
AS
INSERT INTO {objectQualifier}CodegalaxyFreeForm
(
ModuleID,
FormHTML,
Method,
FormAction,
CreatedByUSer,
ChangedByUser
)
VALUES
(
@ModuleID,
@FormHTML,
@Method,
@FormAction,
@CreatedUser,
@CreatedUser
)
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}CodegalaxyFreeForm_GetAForm
@ModuleID int
AS
SELECT *
FROM {objectQualifier}CodegalaxyFreeForm
WHERE ModuleID = @ModuleID
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}CodegalaxyFreeForm_UpdateAForm
@ModuleID int,
@FormHTML ntext,
@Method varchar(10),
@FormAction varchar(2000),
@ChangedUser int
AS
UPDATE {objectQualifier}CodegalaxyFreeForm
SET FormHTML = @FormHTML,
Method = @Method,
FormAction = @FormAction,
ChangedByUser = @ChangedUser,
ChangedByDate = getdate()
GO
Dylan Barber
