Dynamic DHTML Scroller (Page 1/4)
Creating the Database
The tutorial will explain the process of creating a Dynamic DHTML scroller with data drawn from a database. The tutorial is easy to follow and you will not need to code either ASP or DHTML. Dreamweaver and it's extensions will do the job for us. We will use ASP, VBScript with Access2000 database for behind the scenes jobs and use Cross Browser Autoscroller to achieve the DHTML effect.
|Creating the Database||Inserting the Scroller|
|Inserting Data from Database||After Thoughts|
Open a new database in Access and name it as newsdb.mdb
Use "Create table in Design view" to generate a table called tblNews with the following fields
|newsID||Counts the number of News Items|
|newsDate||Date news was inserted to the database, set its default value to Date()|
|newsTopic||Heading of News Item|
Set newsID field as Primary Key and save the table as tblNews. Open the table and add some dummy data for testing. Close Access.
Having created the database, we now have to create a DSN connection in DWMX so that we can utilize the DB contents. Title your DSN "myNews" and your MX Connection "newsConn".
Open Dreamweaver. Lets Insert the Scroller