1. Home
  2. Macromedia
  3. Dream Weaver Online Help

Using stored procedures to modify databases (ASP and JSP)

Using stored procedures to modify databases (ASP and JSP)

You can use a stored procedure to modify a database. A stored procedure is a reusable database item that performs some operation on the database.

NOTE

 

mySQL and Microsoft Access databases do not support stored procedures.

Before you use a stored procedure to modify a database, make sure the stored procedure contains SQL that modifies the database in some way. To create and store one in your database, consult your database documentation and a good Transact-SQL manual.

The procedure for using a stored procedure varies depending on your server model.

This section covers the following server models:

  • Running a stored procedure (ASP)
  • Running a stored procedure (JSP)

Related topics

  • Stored procedures


Getting Started with Dreamweaver
Dreamweaver Basics
Working with Dreamweaver Sites
Laying Out Pages
Adding Content to Pages
Working with Page Code
Preparing to Build Dynamic Sites
Making Pages Dynamic
Developing Applications Rapidly
Building ColdFusion Applications Rapidly
Building ASP.NET Applications Rapidly
Building ASP and JSP Applications Rapidly
Building master/detail pages (ASP and JSP)
Building search/results pages (ASP and JSP)
Building a record insert page (ASP and JSP)
Building pages to update a record (ASP and JSP)
Building pages to delete a record (ASP and JSP)
Building pages with advanced data manipulation objects (ASP and JSP)
Using stored procedures to modify databases (ASP and JSP)
Running a stored procedure (ASP)
Running a stored procedure (JSP)
Using ASP commands to modify a database
Using JSP prepared statements to modify a database
Building pages that restrict access to your site (ASP and JSP)
Using JavaBeans (JSP)
Reference
Building PHP Applications Rapidly
Appendixes