|
||||||||||||||||
Create Web Documents (Table Block) Including Table Contents Connecting Access DatabaseCreates table block that displays multiple records arranged in rows and columns, with field names in the header row. 1. Select [Database > Table Block...] from the Insert menu. 2. Specify the document type, the type of database connection, and the Web server operating system for a database-enabled document created using the Database Wizard. If your Web server runs Windows NT, the default selections are usually appropriate then press Next. 3. In step 2, select a data source for the current document and enter your user name and password to access the database, then press Next. The field information of the table named Contact is shown below.
3. In connected database, select fields from the table and press Add button. The field name is added in the form of "Table name.Field name". Click Next. 4. Enter a SQL statement to select the records that will be displayed in the current block, and to determine their sort order. In this example, we entered the filed name, "Contacts.ID", as the Order to sort by IDs. 5. In Block Elements step, select the fields that will be displayed the table block. Click Next. 6. Set the maximum number of records per page for a table block in this step of the Database Wizard. Click Finish. After the last step of List Form Wizard, table will appear in Edit window. Check the table in Preview window.
This document is created using Namo WebEditor 4 on August 2, 2000.
|
||||||||||||||||
© 2001 Namo Interactive Inc. All rights reserved. |