2008/10/23 <[EMAIL PROTECTED]>: > > Hello all > > I am doing a simple TO-DO list manager using Coldfusion 8 and the language > and MSSQL as the database.? My Required Functionality is:
I think you may be on the wrong mailing list. The DBI module is a Perl interface to various databases so it requires using Perl as your language. For more general SQL help I'd recommend reading the SQL syntax sections of the MySQL and PostgreSQL documentation websites - most of it will be applicable to MSSQL as well, especially the basics. You might also be able to post more specific general questions to somewhere like stackoverflow.com if you can't find a Coldfusion specific mailing list. Good luck, Edmund. > ??? Add TODO > ??? Remove TODO > ??? Modify TODO > ??? Delete TODO > ??? View ALL TODO's > > I am asking for assistance in doing this program.? It is simple, but I'm new > and not quite sure of what steps to take.? Thank you > > > A Sample Schema: > > > CREATE > TABLE [dbo].[todo]( > [todoid] [int] > IDENTITY(1,10 NOT NULL, > [name] [varchar] > (150) NOT NULL, > [dueDate] [datetime] > NOT NULL, > [status] [bit] > NOT NULL CONSTRAINT [DF_todo_status] DEFAULT ((0)), > > CONSTRAINT [PK_todo] PRIMARY KEY CLUSTERED > ( > [todoId] > ASC > ) > WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,? > ALLOW_ROW_LOCKS > = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80 [PRIMARY] > ) > ON [PRIMARY] > -- [EMAIL PROTECTED] - http://ecclestoad.co.uk
