INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Generator Questions

Generator Questions

(OP)
(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?

RE: Generator Questions

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=jdbc:odbc:DataSourceName&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!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close