ActionScript 3.0 :: Write Back Into Database Using FSCOMMAND?
Aug 17, 2010
We are working on a 3rd party application build on Adobe Flash technology to render business dashboards.This application does'nt offer us to generate the whole code rather it's just a drag n drop of charts, text boxes etc components, and then mapping of data. After all of customizing, the application itself generates an SWF file finally.
What our requirement is we need to make our dashboard(a falsh file) to write a chunk of data, eneterd by user, back into our database by a user action, like a button click. (Access, MySQL, Oracle or any). Now our application offers the FSCOMMAND function call wherein we can enter the command name and args.
Now we need to use this FSCOMMAND function to write back to databases because we believe this is the only option with us within our app. What is the command to write back to a database, and then the arguments. Also, do we need to write any JAVA/VB script for that. Please be informed that our application itself generates the whole SWF file code..all HTML coding. {e.g as we include queryparam, "mapped data", using FSCOMMAND, i can see the whole code generated by the app, the HTML code, wherein I could see embedded Java Script with DO_FScommand statament carrying this queryparam command and args..etc.}
Kindly show us the way to acheive this crucial requirement of ours. We are looking for very elaborative answers as we have less expertise with scripts.
View 5 Replies
Similar Posts:
Oct 22, 2009
I want to use fscommand to write a local file.
variable = "1235";
path = "file.txt";
fscommand ("save", path);
textbox1.text = "HI"; //just so i know it is getting to this point.
One, does this work on vista? I am running vista so that may be why its not working.
Two, I also heard rumors about it not working in IE7 or higher, is that true?
Three, I also have read that it only works when running the swf file in flash projector, is that true?
View 1 Replies
Nov 29, 2005
I know, I can send fscommand but can i take in fscommand and process it?
View 6 Replies
Jul 20, 2011
I would like to create a database and read/write data via actionscript3. I'm an absolute beginner in this field, where do I have to start?
View 9 Replies
Feb 6, 2004
I want to write datas to a database (txt or MS Excel) from a flash file that can be stored in my hard disk.
View 14 Replies
Jul 20, 2011
I would like to create a database and read/write data via actionscript3. I'm an absolute beginner in this field, where do I have to start?
View 4 Replies
Feb 4, 2005
I'm working on this flash game right now and I need to implement a simple players database...
It needs to be both read and writable . Meaning, when the player register to save his character information , he needs to key in his email and a password and create an account. The account shall store that player's life amount, ammunition etc . All the infos are stored on an external file and retrieved again when the player logins to the game with the email as his login ID. Security issues are not the biggest concern here because its not exactly meant to be an online game and I don't think hacking would be something I need to worry about ^^'''
I've tried Xml with AS, but I realised that, that alone canot allow me to write the player's info into the xml file.
I'm not exactly an mySQL idiot...but I really have very(x2) rusty and limited knowledge of it. All the server topics confuses me and I've had no experience with Microsoft Access.
View 2 Replies
Apr 6, 2005
I just had a quick stupid question. I'm trying to write a code that switches back and forth between a certain color. If you click it, it turns green, if u click it again, it turns back to its normal color and so forth.
I tried just using a function in the timeline but it doesnt seem to be working:
Code:
function colorSwap() {
switcher = 1;
btnn.onRelease = function() {
[code]...
View 4 Replies
Apr 20, 2010
I have read hundreds of forum and done a tonne of tutorials but i can not get it working.I have a login section with a password and I want to send a userId back from my user database as I use the userId in another section of my website. I was thinking of making $userID GLOBAL and trying to call it from another php file but I think I'm so confused now nothing is working including my brain.
[Code]...
View 3 Replies
Nov 3, 2010
If I have a loop to get information back from the database in PHP, like for example:
PHP Code:
$qry = "Select * from memory";
$result = mysql_query($qry);
while($resultset = mysql_fetch_array($result)){
echo $resultset['name']."<br>";
}
I know that I can send a string back to AS2 and read it but I'm not sure how to work with arrays, do I have to save everything to an array and pass the array to AS2 and then have a function in AS2 to output all the elements of the array to the dynamic text box?
View 1 Replies
Feb 2, 2010
I have a XML-file, which I want to send to a rails server. To do so I use the following code:
<mx:HTTPService id="dataService"
result="resultHandler(event)"
resultFormat="e4x"/>
[code].....
View 1 Replies
Oct 25, 2011
I'm trying to read a XML file and output the values, but i'm getting a 1120: Access of undefined property URLRequest. error.
[Code]...
View 2 Replies
Jul 15, 2009
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
View 1 Replies
Dec 17, 2009
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
View 2 Replies
Jun 7, 2010
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[code]....
View 9 Replies
Jun 17, 2010
I am working on a function to generate a form at runtime in Flex based on a call to the DB. The call to the DB returns the field types, id, tooltips etc as an arraycollection, the arraycollection is then parsed in order to ascertain what control to display based on the type field in the array - this bit works fine.However, i am stuck on trying to save the form fields back to the database using a CFC.my form rendering code is as follows but how do i save values entered back to the database? rendering code..
[Bindable]
public var getglobalprofileb:ArrayCollection;
public function init(event:ResultEvent):void {[code].......
View 1 Replies
Aug 31, 2011
I have updated the mxml code to only show the needed code for the program to run the update.
I am new to Flex and have an issue I hope you all can help me out with.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything.
So, my issue is this. I have a mySQL database hosted on 000webhost.com, I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.
Here is my licenseTracker.mxml
<?xml version="1.0" encoding="utf-8"?>
<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
[Code].....
View 1 Replies
Jan 17, 2011
I am planning on using Flash Builder 4/Flex to write an AIR application which is primarily based around recording, storing and analyzing data.I'll be creating charts etc that need to update in almost real time.It's essential to me that the application be able to function without an internet connection so I need a local database of some variety,but I would also eventually like to build in online synchronization of the data where either database can be update each other based on newer information. Moreover, some type of encryption would definitely be welcome, and speed is a large concern
Synchronization: Primarily updates/additions/deletions will be done on the offline database, but ideally I want to have a web interface that will allow the same updates/additions/deletions and will be synced (beyond that I'm not sure exactly how to do it as I can model that based on what is most achievable).I'm wondering if there's any prebuilt engine that could handle the synchronization of 2 databases. I may end up having the web interface only be for additions, which would be significantly easier to sync.. and I may start that way, but i want to build with technologies that will best allow me to implement full online crud at some point.
View 1 Replies
Jul 17, 2011
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 Replies
Sep 26, 2011
Here is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Database:
mlxx.db.xxxxxxx.hostedresource.com
login: mxxx
[code]...
View 1 Replies
Oct 26, 2006
Is it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
View 1 Replies
Jan 11, 2010
I am planning to develop a standalone application, which infact will be used for personal purposes. So only single user access may be there. I want to develop it in Flex. Just want some opinions from the gurus over here : Whether i should use Flex or AIR (I know only Flex, AIR i need to start learning)Which database i should use? SQLLite or HSQLDB or some other.
View 3 Replies
Jan 15, 2012
I have a database on a server and I transfer the data from it to a web site. So I need to build a flash grid on this site and to load the data on it. But the problem is that I do not know how to do it. So my question is how to build a dynamic flash grid wich is fill with data from a database? Is there a way to do it with action script only or I must do it another way?
View 1 Replies
Oct 8, 2009
I have one swf file in that i used fscommand to get final output when submit button clicked in that swf i am loading that swf in SWFloader in flex3 .i need to get fscommand value as Alert, how to get that value first and display as alert.
View 2 Replies
May 22, 2011
why the below line of code launches notepad.exe twice?
fscommand("execfile", '"C:\Windows\Notepad.exe"'); //opens notepad 2x - path in double quotes
verses this line of code which opens it only once?
fscommand("execfile", "C:\Windows\Notepad.exe"); //opens notepad once
I'm working on a FP10 .exe projector project and noticed this odd behavior.If I had spaces in my file path, I'd want to surround it in double quotes, but that has the undesired effect of opening the app 2x.Since I don't have full control over all the elements in the project, I'm forced to use fscommand in this scenario.
View 1 Replies
Jan 23, 2012
I have a project that opens a pdf using fscommand.
View 2 Replies
Jun 21, 2010
with AS2, we use fscommand to do it, but AS 3 I don't know how to do ..
We can reference from: [URL]
View 1 Replies
Dec 14, 2011
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
View 1 Replies
Jul 21, 2009
I am quite a newbie and want to call another program through fscommand.Flash and the programm I want to call are both running on my hard disk (NOT online)I do not really understand what I have to put into:
1. the line command
2. the line parameters
View 2 Replies
May 8, 2008
When publishing a mac projector (app) from Flash CS3 on PC,in order to use the fscommand("exec", appToLaunch) function, itseems as though the fscommand folder containing appToLaunch must berelative to the "Flash Player" app in the projector package. For example, if I create a mac projector called projector.appwhich calls fscommand("exec", "myOtherProjector"), and I putmyOtherProjector in the fscommand folder in the same directory,sitting next to projector.app - when I fun the projector thefscommand fails.
However, if I move the fscommand folder containingmyOtherProjector to the Contents>MacOS folder in the app folder(on mac right click, go to "show package contents"), next to "FlashPlayer" then run projector.app, the fscommand works and everythingis good.It looks to me like the fscommand folder needs to be relativeto the Flash Player and not to the projector. This means that the contents of the fscommand folder need tobe doubled on cross-platform projects. That's not good when you'repushing the limits of file space on a cd
View 2 Replies