PDA

View Full Version : Flash / Access intergration using simple class



glkngs
May 19th, 2005, 04:33 PM
Hey Kirupians :kommie:
This is my first contribution to the boards :)

Here goes:
Attached is a zipfile containing:

An access database
- the db has three rows for testing purposes - feel free to delete them as you go along.
- it also contains 4 columns: FlashKey, Firstname, Lastname and Age. DO NOT DELETE the FlashKey column, as it is essential. Do delete the other columns...

An ASP document
- Before you upload the files to your server, you shold open the asp doc "extract.asp", and change the refference to the database in line 4 to whatever it will be on your server.

Flashfiles
use.fla. a very little flashfile i whipped up, so you quikly can test to see if your setup works.
DataSet.as is the DataSet class, where all the goodies are ;)

So what is this?
Basicly, this helps you extract and input data into a MS Access database, whitout having to get your fingers dirty with sever side coding.
I havn't had the time to write any documentation for the class, but i'll post some later on.
Until then, you can look at the functions in the class, the names should give you an idea of what they do. You'll notice that the delete function is empty - i'm having some problems with it, so you wan't be able to delete data from the base just yet.
This is really quite beta-ish, and its not tested alot, but all the basics should work.

To load the data, you'll have to parse an SQL String. If you need help on that, i suggest you take a look here: http://exchange.manifold.net/manifold/manuals/manifold/queries/simple_queries.htm
Important!
Untill i get it fixed, you'll HAVE to always load the FlashKey column, if you dont nothing will work :-/

Please post any comments you might have :)

Last update of attachment: 05-21-05 - fixed som bugs

abcdefg
May 19th, 2005, 04:41 PM
Can't test it from here but looks like you did a very good job on this one.

simplistik
May 19th, 2005, 06:04 PM
Oh... this sounds really kewl man. I haven't tested it either... but I'll be interested to see when someone gets a working version online. There are many uses for this... LOVELY. :D

hl
May 19th, 2005, 08:11 PM
sounds cool, but i don't think many people use access

if i did i'd be delighted about this though. good job.

glkngs
May 20th, 2005, 03:56 AM
i don't think many people use access
D'oh!
Well rewriting it for mysql or whatever should be a breeze.. hopefully i'll get that done someday :worried:

tommythewolfboy
May 20th, 2005, 10:07 AM
good stuff ... looking forward to playing around with it.

mysql version would certainly be cool ...

tom

glkngs
May 20th, 2005, 07:34 PM
hello again..
i've made a little example here for you to see:
http://www.frip.dk/gulekings/flash/example.html
http://www.frip.dk/gulekings/flash/example.fla
http://www.frip.dk/gulekings/database/database.mdb

it's pretty basic, but enjoy!

stringy
May 20th, 2005, 07:38 PM
hello again..
i've made a little example here for you to see:
http://www.frip.dk/gulekings/flash/example.html
http://www.frip.dk/gulekings/flash/example.fla
http://www.frip.dk/gulekings/database/database.mdb

it's pretty basic, but enjoy!
nice work

glkngs
May 20th, 2005, 07:42 PM
nice work
Thanks!
I know you must be talking about the design of that messageboard - i mean.. you can't beat that :P

glkngs
May 24th, 2005, 09:51 AM
ohh well.. some lamer hacked the messagebard example :hat:

Krilnon
May 24th, 2005, 12:20 PM
ohh well.. some lamer hacked the messagebard example :hat:
I was wondering why it didn't show what I posted...

glkngs
May 24th, 2005, 12:40 PM
hey, what the.. it's back up again?
it's a crazy world :puzzled:

Kizzy
May 24th, 2005, 03:01 PM
Can anyone help me integrate an Access db into flash without using ASP? I want to use Flash as a user interface locally on my computer and send and retrieve information from a db also on my local machine. Is there a way to accomplish this?

glkngs
May 24th, 2005, 05:00 PM
No. It's not possible without using asp or another server side script. Why don't you wanna use asp?

Timmee_3styler
May 24th, 2005, 05:20 PM
you might want to try a third party software :)