Flash/Access/ASP???
- Started
- Last post
- 9 Responses
- ********
Anyone have any good info on incorporating an MS Access database into Flash via ASP - ie retrieving info from the database using ASP.
I guess a good Flash/ASP/Access CMS would be good if anyone has any info.
BTW, don't suggest PHP and/or MySQL - not an option at this stage.
- ********0
bumpus gurumpus
- Mick0
If you're not using remoting then you're stuck with either loadVars or creating XML with your ASP.
Some info to get you started here...
http://flash-db.com/Tutorials/lo…Although I would recommend creating some XML from your ASP so you can take advantage of the XML features in flash.
- AMFA0
i would use XML & an interface page.
.swf -> interface.asp ->xml ->swf
thats a loop but linear...
I would send an action var to the interface page, it queries the db, returns xml to the swf
You could send the SQL statement from flash to asp but i think that is poor form.
- ********0
Thanks for that guys. Just one last question.
does anyone know if it is possible to go to a specific frame based on a querystring?
ie if my URL was
page.asp?frame=2
how would I get my actual SWF go to frame 2?
- Mick0
- ********0
Not sure if that is exactly what I am looking for.
Let's say all I type in the browser is
http://www.domain.com/page.asp?I…
does anyone know of any xamples that would tell the SWF embedded on that page to go to Frame 2?
- Mick0
You would output the URL variable into the page as it rendered with a response.write(request.querystri...
- then use JavaScript to communicate that to Flash.You could also use FlashVars in the object/embed tag to send the variable to flash but it would only do this once on pageload.
- AMFA0
actually you could do it a little differently.
although i would recommend asp.net, in asp you could:
dim flashID
flashID=request("ID")in your embed & object tags where your flash src is:
src="myswf.swf?ID="
that will create a variable in the _root of your swf file called flashid
then in your swf:
_root.gotoAndStop(flashid)hopefully newstoday doesnt strip my code
- AMFA0
shit.... ok it screwed up my code....
uh email me and tomorrow ill write you an example...
its pretty easy. in short:
pass the querystring like you do in a page in the flash src....it will creat a var in the _root.... its also more reliable than flashvars....