Flash to CF Database and back again...

[Lupos]

ok, so heres the deal, i'm a flash animator, i do a weeee bit of action script and html. I now have a job making a rather large website, they hired me cause they wanted it to look fancy. the guy who owns the company is much more the developer type, hand coding big long coldfusion programs and such... but the prob is, i cant seem to get the two things to talk, i've been out of the web biz for like 3 years and am painfully rusty... I.E. no AS2.0 :/
so i have spent a good week reading every bloody tutorial i can find and they are all assuming i know cold fusion and flash... so here is what i am hoping for:
simple flash movie that loads info from a data base as links... like
Title:
movie1
movie2
etc..

and then when links are clicked they will open a pop-up window that is all html with the apropriate info included as per the variable. now i know how to use the geturl with the "get" methode to send out the correct variable but its gettign flash to load info off of the DB to begin with that is killing me.

Sorry for the long post but i have become rather desperate, any and all help is GREATLY apreaciated.

Thanks
P.S. love the site tons of usefull stuff, help me with a few other issues i was having.

[tg]

so are you writing the coldfusion code or is the other guy?

[tg]

look thru some of the posts here on using the LoadVars object to get data... whether you get info from php, asp or coldfusion, it all works the same way on the flash side....

[Lupos]

the other guide will do alot of the cold fusion stuff, although i have learned a good bit of it. I'll check ont he load vars thing, thanks.

[Lupos]

ok, i suck. i seriously cant make heads or tails right now. could some one please just give the most basic of eamples of this... like what the cf file shoudl look like and what the flash script is.... i know it sjust a bit of text and this info is probably somwhere on here but every thread i look at is about some thing more complicated and advanced than where i am right now. all i want to do is load a list off a DB... its so bloody easy in dream weaver (click and drag) is there not somethign comparable? i know the pro version of flash and 8 have componenets for it but im runnign mx04 basic :(
i just need a jumping point.

PS love the BF quote in your sig, i have a t-shirt with that on it!

[tg]

well, coldfusion will actually do the read from the database, then you need to have coldfusion format the data in the way you want to use it.... i would say use remoting, but that will be more complicated to understand for someone who is new to the whole flash/serverside script connection.

so, one way to do it is to have coldfusion format everything into a delimeted textfile, then in flash, parse the file into an array, and process the array the way you want.

take a look at this thread: http://www.actionscript.org/forums/showthread.php3?t=75414&highlight=coldfusion its got some info about using loadvars with coldfusion, and how to set up cf files etc.... its all pretty basic. its a three pager, but read thru it all, and it may give you a general direction to run at.

[stephenwightman]

tg,

I'm having a bit of trouble myself. I'm using Flash 8, Flash Remoting and Coldfusion and can read the database with no problem. However, I can't seem to update, add or delete anything from the database (MSAccess). Any suggestions you might have would be greatly appreciated!

BTW, Shouldn't Benjamin Franklin's quote read: 'They, who would give up essential liberty for temporary security, deserve neither liberty NOR security'?

[tg]

Shouldn't Benjamin Franklin's quote read: 'They, who would give up essential liberty for temporary security, deserve neither liberty NOR security'?


probably... cut and paste from the internet.... probably totally mis-quoted.

i think it went something like... 'no matter what you jokers do, your gonna get hosed.'

[tg]

I'm having a bit of trouble myself. I'm using Flash 8, Flash Remoting and Coldfusion and can read the database with no problem. However, I can't seem to update, add or delete anything from the database (MSAccess). Any suggestions you might have would be greatly appreciated!


so what does your cfc look like? specifically the method/(s) used to insert or update your data?