618541

Adobe Dreamweaver CC - 2014 Manual

664
Zoom out
Zoom in
Previous page
1/691
Next page
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.
More Help topics
Building a registration page
Note: The user interface has been simplified in Dreamweaver CC and later. As a result, you may not find some of the
options described in this article in Dreamweaver CC and later. For more information, see
this article.
… 664 …


Need help? Post your question in this forum.

Forumrules


Report abuse

Libble takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Product:

For example, Anti-Semitic content, racist content, or material that could result in a violent physical act.

For example, a credit card number, a personal identification number, or an unlisted home address. Note that email addresses and full names are not considered private information.

Forumrules

To achieve meaningful questions, we apply the following rules:

Register

Register getting emails for Adobe Dreamweaver CC - 2014 at:


You will receive an email to register for one or both of the options.


Get your user manual by e-mail

Enter your email address to receive the manual of Adobe Dreamweaver CC - 2014 in the language / languages: English as an attachment in your email.

The manual is 24,32 mb in size.

 

You will receive the manual in your email within minutes. If you have not received an email, then probably have entered the wrong email address or your mailbox is too full. In addition, it may be that your ISP may have a maximum size for emails to receive.

Others manual(s) of Adobe Dreamweaver CC - 2014

Adobe Dreamweaver CC - 2014 User Manual - German - 731 pages

Adobe Dreamweaver CC - 2014 User Manual - Dutch - 718 pages


The manual is sent by email. Check your email

If you have not received an email with the manual within fifteen minutes, it may be that you have a entered a wrong email address or that your ISP has set a maximum size to receive email that is smaller than the size of the manual.

The email address you have provided is not correct.

Please check the email address and correct it.

Your question is posted on this page

Would you like to receive an email when new answers and questions are posted? Please enter your email address.



Info