Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to use the ASP command to modify the database. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

1. In Dreamweaver, open the ASP page that will run the command.

two。 Open the Server behaviors panel (window > Server behaviors), click the plus (+) button, and then select commands. The Command dialog box appears.

3. Enter a name for the command, select the connection to the database that contains the record you want to edit, and then select the editing operation (insert, update, or delete) that you want the command to perform. Dreamweaver starts the SQL statement for you based on the type of action you choose. For example, if you select insert, the following dialog box is displayed:

4. Complete the SQL statement.

5. Use the variables area to define any SQL variables.

For example, here is an insert statement that contains three SQL variables. The values of these three variables are provided by the URL parameter passed to the page, as defined in the Runtime value column in the variables area. After closing the dialog box, Dreamweaver inserts ASP code into your page, and when the page is run on the server, commands are created to insert, update, or delete records in the database. By default, the code sets the "Prepared" property of the command object to true, which causes the application server to reuse a single compiled version of the object each time the command is run. To change this setting, switch to Code view and change the Prepared property to false.

In the above example, the next step is to create a page with a HTML form so that the user can enter record data. The HTML form will contain three text fields (txtCity, txtAddress, and txtPhone) and a submit button. The form will use the GET method and submit text field values to the page that contains your command.

After reading the above, do you have any further understanding of how to modify the database using the ASP command? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.