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 :-/

I'll post post more documentation and and example files here, this is just an initial post, as i promised digitalosphy that i'd post the script by yesterday :pa:

Please post any comments you might have :)

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

Digitalosophy
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