Passing pictures to generator from mysql

[sdfa]

Hi, I am trying to use a jpg generator object linked to a field in mysql which contains various filenames for jpg image files. The files are in the same directory as the flash movie. I have been looking all over for flash generator support but i cant seem to find much on mysql conectivity, im just trying to make a simple connection here. Well if anyone can tell me how to make a conection between the generator and mysql that would be awesome! or possibly tell me where to look with for generator/mysql help? Thanks!

[flashswami]

If you're talking about MM Generator, then you need to be aware that MM are not supporting it from 15th of this month. It will be replaced by ColdFusion Server, which, if you can prove your ownership of Generator, you will get free.

Besides, for relativley simple things like image links, you don't need Generator any more. You can use code in Flash 5 or MX that, as long as your viewers have the v6 player, will work fine. Basically, you can use loadMovie("myImage.jpg"); to bring in images.

Remember you'll need to detect for v6 player. Also, if you are bringing in the images from a script reading in variables then you'd be better using some MX native code like this-

lets say you had a textfile that, as one of the variables, listed a jpg.
lets call this text file 'my_image_list.txt' and lets say that one of the
name value pairs is-

var1=some_image.jpg

If you use the new LoadVars object then you can ensure that the textfile
and the image references are all in Flash before any actual script is
executed e.g.-

i= new LoadVars();
i.onLoad=function(){
image_mc.loadMovie(var1,1);
}
i.load("my_image_list.txt");

which loads the correct image into a movie clip called 'image_mc'