Dynamic DHTML Scroller
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
| Field | Description |
| 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 |
| newsDetails | The News |
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".
If you are unfamiliar with this process check out these links:
Setting
Up A DSN In Windows
Connecting
to a Database
Open Dreamweaver. Lets Insert the Scroller
ranjan datta
A Mechanical Engineer by qualification, I took to the internet in 1998. I have been using Dreamweaver since version 3.0
Comments
Tutorial
How does this work in NS6 with Layers?
RE: How does this work in NS6 with Layers?
This works in NS6, NS7 and Opera.
The necessary browser detection scripts and their corresponding actions are well made by the Marja who has written the auto scroller extension
Help on this wonderful tool
Hello, First of all, congratulations on your great scroller!
In advance, let me apologize for my ignorance as I started using dreamweaver last.I have a few questions for you:
Is it possible to have more than one dhtml scoller on a page? If yes how :)
Secondly, is there a way to add working hyperlink from the database I am using (the url appears but is unclickable :(). And last but least, is there a way to show photos as well.
Once again, thank you for this great extension and tutorial!
You must me logged in to write a comment.