Operation Manual

To the top
To get the Size value, use the Databases panel in Dreamweaver. Find your database in the Databases panel and expand it.
Next, find the table you’re working with and expand it. The table lists the sizes for your fields. For example, it might say
ADDRESS (WChar 50). In this example, 50 is the size. You can also find the size in your database application.
Note: Numeric, Boolean and date/time data types always use -1 as the size.
To determine the Type value, see the following table:
Type in database Type in Dreamweaver Size
Numeric (MS Access, MS SQL
Server, MySQL)
Double -1
Boolean, Yes/No (MS Access, MS
SQL Server, MySQL)
Double -1
Date/Time (MS Access, MS SQL
Server, MySQL)
DBTimeStamp -1
All other types of text fields,
including the MySQL text data types
char, varchar and longtext
LongVarChar check database table
Text (MS Access) or nvarchar,
nchar (MS SQL Server)
VarWChar check database table
Memo (MS Access), ntext (MS SQL
Server), or fields that support large
amounts of text
LongVarWChar 1073741823
For more information on the type and size of SQL variables, see www.adobe.com/go/4e6b330a.
6. Close the dialog box.
Dreamweaver inserts ASP code in your page that, when run on the server, creates a command that inserts, updates, or
deletes records in the database.
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 command is run. To change this setting, switch to Code view and change
the Prepared property to false.
7. Create a page with an HTML form so users can enter record data. In the HTML form, include three text fields (txtCity,
txtAddress, and txtPhone) and a submit button. The form uses the GET method and submits the text field values to the page
that contains your command.
About stored procedures
Although you can use server behaviors to build pages that modify databases, you can also use database manipulation objects such as stored
procedures or ASP command objects to build the pages.
A stored procedure is a reusable database item that performs some operation on the database. A stored procedure contains SQL code that can,
among other things, insert, update, or delete records. Stored procedures can also alter the structure of the database itself. For example, you can
use a stored procedure to add a table column or even delete a table.
518