Bedienungsanleitung Adobe Dreamweaver CC - 2014 (Seite 664 von 691) (Englisch)

618541

664

Zoom out

Zoom in

Vorherige Seite

1/691

Nächste Seite

657

Building applications visually

Last updated 2/19/2015

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.

Run a stored procedure (ASP) (CS6)

With ASP pages, you must add a command object to a page to run a stored procedure. For more information on

command objects, see

About ASP command objects.

1 In Dreamweaver, open the page that will run the stored procedure.

2 In the Bindings panel (Window > Bindings), click the Plus (+) button, and then select Command (Stored

Procedure).

The Command dialog box appears.

3 Enter a name for the command, select a connection to the database containing the stored procedure, and then select

Stored Procedure from the Type pop-up menu.

4 Select your stored procedure by expanding the Stored Procedures branch in the Database Items box, selecting the

stored procedure from the list, and clicking the Procedure button.

5 Enter any required parameters in the Variables table.

You don’t need to enter any parameters for any RETURN_VALUE variable.

6 Click OK.

After you close the dialog box, ASP code is inserted in your page. When the code runs on the server, the code creates

a command object that runs a stored procedure in the database. The stored procedure in turn performs a database

operation, such as inserting a record.

By default, the code sets the Prepared property of the Command object to true, which makes the application server

reuse a single compiled version of the object every time the stored procedure is run. If you know the command will

be executed more than a few times, having a single compiled version of the object can improve the efficiency of

database operations. However, if the command will only be executed one or two times, using one might actually slow

down your web application because the system has to pause to compile the command. To change the setting, switch

to Code view and change the Prepared property to false.

Note: Not all database providers support prepared commands. If your database does not support it, you might get an

error message when you run the page. Switch to Code view and change the Prepared property to false.

If the stored procedure takes parameters, you might 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.

Missbrauch melden von Frage und/oder Antwort

Libble nimmt den Missbrauch seiner Dienste sehr ernst. Wir setzen uns dafür ein, derartige Missbrauchsfälle gemäß den Gesetzen Ihres Heimatlandes zu behandeln. Wenn Sie eine Meldung übermitteln, überprüfen wir Ihre Informationen und ergreifen entsprechende Maßnahmen. Wir melden uns nur dann wieder bei Ihnen, wenn wir weitere Einzelheiten wissen müssen oder weitere Informationen für Sie haben.

Adobe Dreamweaver CC - 2014 Seite 664

Brauchen Sie Hilfe? Stellen Sie Ihre Frage.

Missbrauch melden von Frage und/oder Antwort

Art des Missbrauchs:

Forenregeln

Neu registrieren

Andere Handbücher von Adobe Dreamweaver CC - 2014

Das Handbuch wird per E-Mail gesendet. Überprüfen Sie ihre E-Mail.

Ihre Frage wurde zu diesem Forum hinzugefügt

Info