Generator Questions

[csiwa28]

(1) I have and MS Access Database called test.mdb. The database has a table called products and fields id and name. I want to create a srolling list in Generator and I want it to display all the information from the database. I've seen examples of connecting to text files but no examples to databases. Is it possible to connect to the database? If so, then how?

(2) Secondly, would Generator work if I integrated Flash with ASP?

 

[pixl8r]

answer is yes to both. To connect G2 to your access database use the following as your datasource:

fgjdbc:///?driver=sun.jdbc.odbc.JdbcOdbcDriver&url=jdbcdbcataSourceName&userid=UserID&password=Password&query=SELECT%20*%20FROM%20TableName;

Of course replace the "DataSourceName" with your table name and pretty much right the SQL query from there.

NOTE: the first field in your database must be "clip". This is what tells G2 which library item to use for displaying the info.

On the second question it is a matter of passing the variables into the Flash movie, and then using actionscript to evaluate or act on them within the Flash movie.

I hope that helps you!
Wow JT that almost looked like you knew what you were doing!