
DREAMWEAVER CS3
User Guide
658
Dreamweaver automatically fills in the Callable Text and Variables boxes.
6 Select the Returns Recordset Named option, enter a name for the recordset, if the stored procedure returns a
recordset, and then click the Test button to see the recordset that the stored procedure returns.
Dreamweaver runs the stored procedure and displays the recordset, if any.
Note: If the stored procedure returns a recordset and takes parameters, you must enter a value in the Default Value
column in the Variables box to test the stored procedure.
7 Click OK.
After you close the Callable (Stored Procedure) dialog box, JSP code is inserted in your page. When the code runs
on the server, it calls a stored procedure in the database. The stored procedure in turn performs a database operation,
such as inserting a record.
If the stored procedure takes parameters, you can create a page that gathers the parameter values and submits them
to the page with the stored procedure. For example, you may create a page that uses URL parameters or an HTML
form to gather parameter values from users.
Building a registration page (ColdFusion, ASP, JSP, PHP)
About registration pages
Your web application can contain a page that requires users to register the first time they visit your site.
A registration page is made up of the following building blocks:
• A database table to store login information about the users
• An HTML form that lets users select a user name and password
You can also use the form to obtain other personal information from users.
• An Insert Record server behavior to update the database table of site users
• ACheckNewUsernameserverbehaviortomakesuretheusernameenteredbytheuserisnottakenbyanotheruser
The method you use is identical for ColdFusion, ASP, JSP, and PHP pages. Dreamweaver does not have authenti-
cation server behaviors for ASP.NET pages.
See also
“Add an HTML form for selecting a user name and password (ColdFusion, ASP, JSP, PHP)” on page 659
“Update the database table of users (ColdFusion, ASP, JSP, PHP)” on page 659
“Add a server behavior to ensure a unique user name (ColdFusion, ASP, JSP, PHP)” on page 660
Storing login information about users (ColdFusion, ASP, JSP, PHP)
A registration page requires a database table to store the login information entered by users.
• Make sure your database table contains a user name and a password column. If you want logged-in users to have
different access privileges, include an access privilege column.
Comentarios a estos manuales