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 RepliesIs it possible to connect any database from flex directly?
View 3 RepliesI have a task to make simple game that deployed as a facebook app using Adobe Flex. Like most facebook game, I need to show high score, compare score with friends and some other similar functionalities, which I think need some sort of database thing.
The problem is a had only little experience about database, only have tried simple things with MySQL and I don't know where to start.
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.
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]....
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].....
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.
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]...
[code]...
I got the script to work perfectly, even got to register a few hundred members to the site. However, my old host had a bandwidth limit of 400gb so I had to move to a new provider. I transferred all the files with no problems, and even setup the database properly. My new problem is registering... I can login just fine using an existing account I had made. But I go to try and make a new account and I get an "undefined" error.[code]...
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 RepliesI'm developing a desktop application in Flash, but I can't seem to find any tutorials that aren't based on FLEX to connect my application to a database file.
Do I have to write my application in FLEX to use SQLite or can I create an AIR app in Flash and still use it?
What is the best tool available in flash mx to connect to databases and do we have a tutorial for that.
View 1 RepliesI'm still learning AS3 and am trying to set up validating user (text box) input of 2 items (name and password) by checking with an SQL Server Database on my website.I have the ASP page set up using a standard request/response.write script. It works I've tested the ASP, and it works. The ASP receives the 2 variables, hopefully each in a name-value pair, and checks with the DB, then if the name and password received from the Flash SWF match a name and password in the DB, sends back a "YES" and, if not, sends back a "NO".I'm having difficulty getting the AS3 written and working correctly. Here's what I have so far that displays errors, causes a flickering when previewed and doesn't yet work.
stop()nextBtn.addEventListener(MouseEvent.CLICK, nextBtnClick, false, 0, true);function nextBtnClick(e:MouseEvent):void {var input1:String = T1.text;var input2:String = T2.text;var variables:URLVariables = new
[code].....
I'm working on Flash project for which I have to conenct to Oracle database, retrieve data and display it.Is it possible to connect to Oracle database from Flash?
View 2 RepliesWhat I am after is to be able to connect to a SQL database directly or via a ASP Page (whichever is easier) to pull out some variables and display them as text in a text field. Basically we have a news section on our intranet (stored in an sql) and I want to be able to pull these out and put them into flash. I have looked on the internet for examples, but everything that I do don't seem to work.
View 1 RepliesThis is what we have... a new Actionscript developer (Me) and a seasoned Visual Basic/ASP developer. We've also got some SQL Servers... We need to write a web application (Flash) that checks user authentication (User Name and Password) against a SQL Server database before allowing the user to continue through the program. After the user completes various components of the eLearning program, a brief quiz will follow. At the end of the whole eLearning program, a lengthy quiz will be given and those results will be scored and stored in a database.
I need to know what is required to do this... this being the database connectivity? I've been seeing PHP/MySQL tutorials but is there some way to hook up into ASP/SQL Server? Furthermore, how exactly does this work? I've read that with PHP, flash will write and store variables in PHP which is then used to get results from the database. I'm not exactly sure tho. If any one can point me to a great tutorial that explains everything about ASP/SQL Server..
I am trying to connect to a MySQL database using PHP in Flash CS3 using Actionscript 3.I have written the PHP file and some AS3 code and it displays the information but for some reason it also displays the tags.[code]The picture below shows what happens when I test the movie.I also need to add buttons to move to the next and previous record and to add or edit the database via the Flash interface?
View 7 RepliesI have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event.
The page is for a booking/promotion concert company. They want a "Featured Shows", "Calendar", and flash file that all are interconnected. One page. Does anyone know how to do this, where to find tutorials, or so on? Note, i'm not wanting to WRITE data to the database, I just want to GET data to post on the flash file.
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 RepliesI 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].......
Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 RepliesIs 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 RepliesI 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 RepliesI've started with Flex recently, I've noticed that some plugin for Visual Studio exist, instead of buying a licence for another program (Flex Builder).I was wondering how I could manage to remotely connect to my database with a Flash/Flex application with the help of C#/Asp.Net.
If I've correctly understood what I've read in the last few days, there is basically no way to 'query' to a database with Flex 3. So I suppose there is another way by using a webservice in C# on the database server that would respond to the Http query from Flex.
I have a combo box that is currently getting its information from a database this seems to be working fine.Now I would like to have content from two fields displaying in the combo box at once. Say First Name & Last NameI've added the information to the query fine but the data displayed in the combo box seems to be controlled by the labelField property and it seems to only allow one variable at a time. So it will either display First Name or Last Name but not both at once.here's bit of my code
private function NameData():void { //NAME DATA
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
[code].....
I use flex and php to retrieve information from my sql database. What i have been doing is formatting the result from the database query into xml and then putting the result into an arraycollection. It all works fine except one of my database fields contains a lot of text that website users enter and as xml doesn't like tags like <> so I leave it un formatted but I would like to format it. Would I be better using flashvars or text than xml? Or is there another way?
View 3 RepliesI'm making an application (web based) using flex and i have a requirment to access the SQLite database on the local system. There is no server running and i've decided to give them the link to the html file and see how that works out.
So in the root directory, there will be all required swf, html files, etc and a .db file. Can i access that database thro the flex web application ?
I have been struggling with trying to interface with SQLite and Adobe AIR. I am using the Flex 4 SDK with AIR 2.0. I modified code from a tutorial by David Tucker on InsideRIA ([URL]). I am writing in FlashDevelop (which I suppose could be my problem), and I can compile and run the app. The issue is that when I go to search the db file, I always get some error which results in the 'BREAKER' trace (ie - the 'queryError' function is called). I have tried simply running the SQL command on the db and it works fine, so there is an issue somewhere in the way Flex or AIR is handling my query (or obviously I could have made a mistake in coding).
[Code]....
I'm reading data from an SQL database and send it to my Flex app. My source code in Flex is the follow[code]...
View 1 RepliesI know this question is vague, but I have a school project, which works with HttpServices that call to PHP-files to insert and retrieve data from a database. Now the teacher told me I have to work with valueObjects to work with the database, but I haven't received any further information.
View 2 Replies