This tutorial is suitable for beginner to intermediate level, and requires SQL Server installed on your machine (free evaluation edition available from www.microsoft.com/sql/evaluation/trial/) and/or your webhosting provider.
Now with interactive Flash movies showing you step by step how to create the application in DreamweaverMX!
Marcellino Bommezijn is one of the managers at dmxzone.com. He is a contributor on the tutorials section.
Owner of Senzes Media (http://www.activecontent.nl) which provides professional services and web applications for mid-sized companies.
ActiveContent CMS is the ASP.NET Content Management solution that is used for building professional and rich-featured websites.
The article is entitled "Using Stored Procedures and Commands in DWMX", and then proceeeds to use an extension to do a very basic SQL Stored Procedure function (@@IDENTITY) via an old Ultradev extension (why use this in article about DW MX?)
I would have preferred to see the use of the builtin capability of SQL Server to return an inserted ID. My goal is to be able to use the Commands dialog to make the recordset, and then use this recordset to do the insert, update, and deletions using the application wizards in DW MX 2004 (which are the same as DW MX) . The main advantage I see in DW MX/2004 is the quick assembly of forms with formatted fields pulled from the database (DW creates all the text boxes, checkboxes, etc. from looking at the data fields in the fields chosen for the recordset).
I will continue to look for a tutorial on using SPs in particular.....
The particular SP that you refer too for retrieving the identity of an inserted record is not covered in this tutorial. For this i recommend everybody to use the excellent extension by http://www.basic-ultradev.com, which is actually updated to use with DMX 2004.
I believe i show some more advanced uses of Stored Procedures, which are normally created as recordsets outside SQL Server, instead of the common @@identity procedure, which can be found on the internet very easy as an tutorial. These more advanced Stored Procedures are retrieved with the Commands dialog of DMX.
Please be more specific what you want to see, using Stored Procedures and maybe i can use this make a future tutorial that suites your needs.
You must me logged in to write a review.