Recordsets to Stored Procedures

[TheRook]

I have created a website using DWMX & SQL2K with all recordsets. I would like to my recordsets to stored procedures. Are there any written procedures, rules, or advice for doing so?

Help

[CMBergin]

Yep.
Go visit [url]www.4guysfromrolla.com[/url] to get started.

"TheRook" <webforumsuser@macromedia.com> wrote in message
news:cv2smi$4j0$1@forums.macromedia.com...

> I have created a website using DWMX &amp; SQL2K with all recordsets. I

would like to my recordsets to stored procedures. Are there any written
procedures, rules, or advice for doing so?

>
> Help

[j289243]

Hi

I use Enterprise manager to administer and create the databases including
stored procedures.

The following is a very simple list from a table:

CREATE PROCEDURE userPermission.procedure_name
AS

SET NOCOUNT ON

SELECT *

FROM databasetable
GO

NOTE: userPermission. can be removed if you set your permissions by giving
permissions within the procedure properties.

Using the MM binding in Dreamweaver to retrieve the data is quite straight
forward once you are aware of the parameter settings. I work with ASP.NET and
these settings are presented differently across server technologies.

The following book is good:

Code Centric: T-SQL Programming with Stored Procedures and Triggers
Garth Wells

I hope this is of some help

J