SQL and Flash

[Richard Hanley]

Is it possible to send sql queries to a db stored on a local shared drive from flash? Or is it a case of alwas having to go through the whole web server-php route?

[tg]

flash can't do it directly... you'll have to use some sort of script/program to make the connection to the db, and retrieve the recordset.

[CyanBlue]

db stored on a local shared driveCan you get data from the database that is residing on the local drive??? :confused:

[tg]

sure you can, i do it daily on my box at work, to get the rough bugs out of my code before i upload it to a server. but not directly with flash (yet).

i've been playing around lately with flash and wsh... can do some fun stuff (like execute dlls) with that, but havnt figured out a way to get rid of the warning from windows to open or save the file i try to open.

[CyanBlue]

Hm... Sounds like fun and headachey stuff... :D

[tg]

no headaches... just play().

[Richard Hanley]

ok, cheers people. Best get my thinking trousers on and come up with something else.

[stealthelephant]

u could use flash remoting to make it appear more like flash is doing the work (amfphp)