Adobe Dreamweaver CS3 Bedienungsanleitung Seite 659

  • Herunterladen
  • Zu meinen Handbüchern hinzufügen
  • Drucken
  • Seite
    / 738
  • Inhaltsverzeichnis
  • FEHLERBEHEBUNG
  • LESEZEICHEN
  • Bewertet. / 5. Basierend auf Kundenbewertungen
Seitenansicht 658
DREAMWEAVER CS3
User Guide
652
4 Complete the SQL statement.
For information on writing SQL statements that modify databases, consult a Transact-SQL manual.
5 Use the Variables area to define any SQL variables. Provide the name and run-time value. Specifying the type and
size of each variable prevent injection attacks.
The following example shows an Insert statement that contains three SQL variables. The values of these variables are
provided by URL parameters passed to the page, as defined in the Run-Time Value column of the Variables area.
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 youre 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 appli-
cation.
Note: Numeric, Boolean and date/time data types always use -1 as the size.
To determine the Type value, see the following table:
For more information on the type and size of SQL variables, see www.adobe.com/go/4e6b330a.
6 Close the dialog box.
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
September 4, 2007
Seitenansicht 658
1 2 ... 654 655 656 657 658 659 660 661 662 663 664 ... 737 738

Kommentare zu diesen Handbüchern

Keine Kommentare