ActionScript 3.0 :: How To Handle Database Manipulation
Mar 11, 2010
I have a request to create a "flash-like" app that is connected to a MS Access Database (DB). The customer has built up a product configurator in Access and wants to know if I can do anything with it. Is this what Flex is good for? I still really do not understand what Flex is all about.
Anyway, I thought of exporting the DB out to an XML file and importing that to a flash app and then using the data there. The problem with that is that I would have to recreate all of the logic (e.g. if you choose "model A" you can only choose "colors 1, 2, or 3") that manipulates the elements in the DB and also the client would not be able to easily manipulate/edit/update the DB without having to export it to XML, etc...What would be a smart way for me to access/manipulate a MS Access Database through a flash front end?
View 1 Replies
Similar Posts:
Jun 3, 2003
The below script allows for line point adjustment, this works by dragging the yellow handles to new positions as you can see. Now the problem is when you click and drag the circular handle it drags the whole line like its supposed to but the other handles don't reposition on the ends of the lines. Take a look at the script and you will see that the handle coordinates are stored in objs in the form {x: y ,.
View 14 Replies
Feb 6, 2010
I'm creating a scrollbar gallery from a tutorial on this site. Though I've completed the tutorial, and customised the gallery to my own needs, however I'm trying to make a very small change to it - and no matter what I do, keep running into problems. I'm trying to replace the rectangular handle with my own customised handle - a (20 x 20) 'circular' png image that I've imported into Flash, made a graphic and stored in the library (though I understand it can be imported using actionscript, like the other images in the gallery).
[Code]....
View 7 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 3, 2006
Using AS2 or 3, is there a way to create my own file format? I would like to create a game.And when users play the game, they can create a GAME-SAVE-FILE.So, let's say that player 1 is playing... He get's to level 22 and has to sign off.He clicks save my GAME-SAVE-FILE to my computer.He names the file MyGame and saves it to his desktop.So now on his desktop he has MyGame.gsf. Next time he visits, he can click on UpLoad My Saved Game.He selects his previously saved MyGame.gsf And bammo... all the information was stored in his file and now he can play on.
I need to know how I would put together the format for my own file-type / extension.I need to know how I would access, write, and edit my own file-type / extension.Since Flash can do this type of File Manipulation with PNG's and JPG's.So surely it can be done with any desired custom format.
View 2 Replies
Dec 7, 2011
Using javascript or flash, is it possible to log into websites and than pull content from that page?
I am trying to make a phone app that displays content from a site that requires log in.
View 2 Replies
Jan 17, 2010
I am curious if anyone knows how to code a button so that when you click it an object resizes, but shows the animation of it resizing. For example I know that
ActionScript Code:
btn1.addEventListener(MouseEvent.onRelease, resize);
function resize(): void {
[code]......
View 4 Replies
Jul 20, 2006
I want to search and replace specific text in a HTML file (about 10k - so quite a lot of text). I was thinking of trying to get Flash to do this for me. I wasn't sure how good Actionscripts text manipulation was! The only reason why I was think of doing this in Flash was because I don't know VB. I would otherwise do it in Perl if Actionscript is no good.
View 1 Replies
Aug 22, 2006
I'm using a function to call multiple button actions, so I don't have to rewrite code for each button... here's the script:
[Code]...
This is all part of a clip which loads pictures externally... each of the buttons (which are mc's) are named btn0, btn1, etc.
View 14 Replies
Oct 14, 2009
I'm currently trying to create an advent calendar I would like the flash movie to somehow recognise the date on the users computer and then gotoAndStop at that particular Frame Label (eg. If it's the 20th December then it jumps to Frame Label 20 in the main timeline.
View 4 Replies
Apr 24, 2012
I have a project which is about creating interactive videos for users..The main idea is that user will open the app and a predefined video will show-up.Video will show couple of billboards, signs etc. while moving through a highway.. Like from a perspective of a driver..I need to insert users photos to these billboards and some text to signs..
The problem is, these objects which I'll be filling are changing their shapes constantly because of the car movement. I can get all the x,y coordinates and timings of the video from my partners. But I don't know how to use them in this situation.I think about continious tweens with these x,y values but I'm not sure..
View 5 Replies
Jan 30, 2010
I have a MovieClip in the library exported for actionscript. How do i convert or attachMovie it to a BitmapData class so that i can manipulate its pixel data? I will need that so that i can distort the MovieClip.
View 3 Replies
Sep 4, 2010
I'm creating a Flex application that enables users to communicate in a kind of video chat room. I only allow to live streams at any given moment. I'm using FMS to record the videos in FLVs. What I need to do is post process those videos and create a single video with all that happened in the video room. That means that I need to combine 2 videos, reduce the size of one of them so it appears over the other one. In other words one video will use the whole space an the other will appear at the upper left corner (over the other video,).
I need a server side solution for this. I created another post here and someone suggest a screen capture solution. That would work perfectly, but since this appliction will be used for several people and any time, I want the process to be automaticaly not manual. So, I'm thinking I can do it with FFMPEG, but I need a way to identify in which order I need to compose the videos. Something like adding a time stamp to each FLV in FMS (when they are recorded). How can I add custom metadata to the FLV?
View 1 Replies
Feb 6, 2011
I've been messing around a bit with some low-level bitmap manipulation and having been creating some various color matrices to apply to bitmap data to add "filters" (for lack of a better term).I have seen a number of tutorials online in C# and AS3 about applying various color matrices to bitmaps, but was curious if anyone simply had a collection of these color matrices that map to specific filter styles (black and white, sepia, etc.).
View 1 Replies
Jul 20, 2009
I'm not familiar with XML text handling yet, but have to create one quiz quickly.I've decided to put feedback into different variables. e.g. fb1_1 for right anwer of question 1, fb1_2 for wrong answer of question 1.I thought to change a string to variable and put the text into a dynamic text "fb" would be something like this:[code]Also is it possible to put all text in one text field and extract a different line of text and put it to a dynamic text field? I tried to put the text into a variable, but it only shows level (level0) and instance name not the text itself. Anyway to get this way to work?
View 0 Replies
Jul 26, 2011
I need to do file manipulation such as create,write and delete in flex4 webapplication.
View 0 Replies
Aug 24, 2004
i have a problem manipulating multiple sound objects in MX. i have a main background loop object and a button rollover object (which plays on specific buttons). i then have a volume slider which will set the volume of only the main bg loop object. but when i tested it, it seems that the volume of the button rollover object is also the same with the main bg loop object's volume. meaning, if my main bg loop's volume is down to 50, the button rollover sound volume is also 50.
here're my codes:
//code on 1st frame
mainLoop = new Sound();
mainLoop.attachSound("mainLoop");
mainLoop.start();
mainLoop.onSoundComplete = function(){
mainLoop.start();
}
hoverSound = new Sound();
hoverSound.attachSound("hoverSound");
//code on slider MC
onClipEvent(enterFrame){
if(drag){
_root.mainLoop.setVolume(this._x); //this._x is between 0-100
}
}
//code on sample button
on(rollOver){
hoverSound.start();
}
thanks!
View 3 Replies
Sep 3, 2004
I have a site where as you click links, you move forwards through a city. I want to fade sound files in and out, overlapping, depending on where you are in the city.As yet, I can't have two sounds playing at once.I have found a site with the effect I want, it's atI have two sound loops at the moment, one of cicadas, one of a city at night, both saved as separate .swf files, which I have loaded onto the main timeline on layers 14 and 15.
The code for the two loops is:cicadas.swf, FRAME 1
var volPercent = 20;
cicadas = new Sound(cicadas);
cicadas.setVolume(volPercent*2);
[code]......
View 4 Replies
May 29, 2009
I really like the string.Format() method and the StringBuilder class in C# quite a bit.
I sucks AS3 isn't as robust (yet, hopefully) with regard to string manipulation.[code]...
So, are there any open source libraries for AS3 that include this kind of functionality (and more, hopefully)?
Currently, in order to have the same result in AS3 would take a lot more code.
I hate relying on C# and other languages to do more formatting and such than they really should when generating XML files and stuff like that.
View 5 Replies
Aug 24, 2004
i have a problem manipulating multiple sound objects in MX. i have a main background loop object and a button rollover object (which plays on specific buttons). i then have a volume slider which will set the volume of only the main bg loop object. but when i tested it, it seems that the volume of the button rollover object is also the same with the main bg loop object's volume. meaning, if my main bg loop's volume is down to 50, the button rollover sound volume is also 50.
here're my codes:
//code on 1st frame
mainLoop = new Sound();
mainLoop.attachSound("mainLoop");
[code]...
View 3 Replies