Using the Generator Ticker Object.

[Stephen Pintauro]

Hell all,

I am trying to use the ticker object included in Flash 5.  I have an

Access database set up, in which users can enter information that will

be displayed on the scrolling ticker in a Flash Web page.  The users

enter the information via a Cold Fusion template file.  This part is

working fine.  The database is updated properly.


In Flash, I have inserted the Ticker object and created a datasource

(called "News_R").  In the Generator/Ticker properties, under

datasource, I have entered the following.


fgjdbc:///?driver=sun.jdbc.odbc.JdbcOdbcDriver&url=jdbc:odbc:News_R&userid=&password=&query=SELECT

TOP 3 clip, ID, myName, Today, headline, teaser FROM News ORDER BY ID

DESC;


This should select the most recently added three rows of information

from the database and display this information in the Ticker on the Web

page.  It works great when I test the movie, and when I publish the

movie.  However, when the database is updated with new information, the

Web page is still presenting the information that was in the database at

the time the Flash movie was published.  In other words, the ticker is

not updating itself with the latest database info.  I have tried

clearing the cache and refreshing, but that does not help.  The only way

I have found to have the Flash ticker display the latest database

entries is to re-publish the Flash movie.  Of course, that defeats the

purpose of the whole thing.


I am sure I am missing something obvious here.  Anybody have any idea?

Thanks in advance,


Stephen Pintauro--

*****************************

Stephen J. Pintauro, Ph.D.

Associate Professor

Department of Nutrition and Food Sciences

University of Vermont

Phone: 802-656-0541

http://nutrition.uvm.edu/