Back to Top
The nuts and bolts for
Creative web development
Register or Login 0 Items ($0.00)

Using Stored Procedures and Commands in DWMX

This tutorial builds up a click-through tracking application that you can use to measure the number of clicks on any given link in your site, even external links. It demonstrates how to use SQL Server stored procedures and commands from Dreamweaver, in conjunction with an interactive demo. All the application code is free for download and re-use in your own pages.

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!

Overview

Table of Content:

  • What is a stored procedure?
  • What is a Command ?
  • The advantage of a Stored Procedure and a Command used together.
  • What kind of applications can I build?
  • The Click-Through application
  • Creating the database tables
  • What information do we want to store?
  • The interface of the application
    • First Page
    • Second Page
    • Third Page
  • Additional: completed pages and SQL scripts

Marcellino Bommezijn

Marcellino BommezijnMarcellino 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.

See All Postings From Marcellino Bommezijn >>

Share this Article

Other SQL and Databases

CMS Basics and Advanced HTML Editor 3
Learn why you need a database to work with Advanced HTML Editor 3
Free - Applied MS Reporting Services 101 using Smart Client
Free - Dynamic Data Grouping using MS Reporting Services
Free: Creating a Sortable table Behavior (PHP or ASP)
Free! - Excel Spreadsheet into MySQL
MySQL and Multiple Tables: Part 2
MySQL and Multiple Tables: Part 1
SQL: Strings
SQL: NULL
SQL: Tips
r

Reviews

RE: Disapppointed with this article

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.

 

Disapppointed with this article

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.....