ActionScript 3.0 :: Reading Mssql Database Records Within Flash CS3
Feb 6, 2009
I've got records being populated into our database from paypal's Instant payment notification methods...great. now i turn to our flash cs3 app to populate a component datagrid with the stored database data and to my surprise I'm unable to identify any examples on how this might even be done.
How do you connect to an mssql database from within flash cs3 to retrieve data for displaying within a flash datagrid?
I can write a cfc from coldfusion to return a dataset, but overall i'm not sure if i 'have' to learn Flex, or AIR or what to get the records 'read'.
My ActionScript 3.0 bible is vague at best and resorts to php. (which i dont know)
I have a flash application that communicates with php to save data to nvarchar(1200) column. However when I change to different language support i.e locale, and type into the flash app the letters are good but in the db they are saved as question marks instead of the reall letters.
I'm creating a flash basketball bracket that I need to submit the picks to a MSSQL database on an ASP.NET server. Every time, I get the #2032 Stream Error, which usually means the URL doesn't exist (which it does). The thing that chaps my behind is that if I trace the url and the variables, then paste that into a browser window, the database updates perfectly, just as I want it to. My code is below. Of course, the tournament is ten days away and I've been stuck here for a week, so if anyone can see what the heck is going wrong, please let me know.
I'm trying to list in flash, several records that come from my database. I'm not talking about a datagrid or anything to fancy. I just want to list the values inside text boxes. (to allow editing). I already have fetch an array of records that come from the database, here:
[Code]...
My question is: How can I display several records, instead of only 1? Should I change the call to, instead of 1, uses a variable? But where would that variable comme from? Then I should loop again the addChild method for each child of form2 that needs to have different records on each of them?
Case1: When a client makes a remoteObject request ie to save some Info... A call is made to Java SAVE_INFO method. If request failed ie came back to FaultHandler ( we save the info in an arrayCollection).Later we call SAVE_INFO again for each item in arrayCollection ie( if arrayCollection has 10 items.. We call 10 times the same method.. I know that's kind of stupid but we have no control over java to write a overloading method). Some times we see there are multiple records of same info in DB. I am not sure if this happens when looping over arraycollection and making calls or during normal one time call. We could not find a pattern to reproduce. Java LOG level is at Error level in production. can't set to INFO in production to monitor all calls. We dont know if this multiple times saved record is, the one in arrayCollection or normal one.
Flex3 RemoteObject --> WAS 6.1 , lCDS 3.0, Java1.5 --> Webservice -- > Java (hibernate) --> Oracle 10gCase2: When application is left open and user leaves for the day and submits info the following morning, we see duplicate records in DB of that info.(No arrayCollection here. Simple straight one call)Flex3 RemoteObject --> OC4J Blazeds Java1.5 (JDBC) --> Oracle 10g.Recently one of our Testers testing case 2 application found this pattern and I am starting to think that may be in the case 1 also.. users might be leaving for lunch/break and resubmitted the arrayCollection after coming back. During lunch java might have killed the sessions for the client and after resubmitting 10 at same time.
How to connect mssql database to flash?I have table tbl_flash in which some information that I want to show in a flash, but only the ones you want to use "where"
I have a created a flash searchable database with xml,following this tutorial url...It seem to be work great but my the xml file seems to be too large so when certain words are search I get a script error and eventually freezing up, my question is Is there a way to tell flash to load the 10 or 20 records at a time? By loading sections of the xml one at a time will this stop the script error?
I have a Wowza Media Server 2 running on Amazon EC2 and I've noticed from time to time a flv is recorded from a webcam using Flash that has audio but no video. It works fine most of the time but from time to time this error occurs
I am getting problem in flash,php,mysql integration .The php page is fetching the data from database .But when i include this php page into flash document ,the data are not showing.
This is the sites.as file. function lv(l, n, t, e, f) { if (l == undefined) {
I have results from my mysql coming to flash mx and I am trying to format it in rows like: VENUENAME ADDRESS PHONENUMBER And I want about 10 records to show in flash at a time....
Here is the actionscript and the PHP code: // Create another LoadVars instance to receive the server's reply replyData = new LoadVars(); // Specify a function to call when this new instance receives the reply. replyData.onLoad = handleReply; // Submit the order data [Code] .....
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...
Im creating a scoreboard within flash, ive got mysql data converted to xml and grabbed into flash, im trying to output the data: user, score, time into dynamic textboxs but can only get one record.If there is a better way, such as creating the textfields on output could someone point me in the right direction!
function outputXML() { for (var i=0; i<xmldata.item.length(); i++)
i have results from my mysql coming to flash mx and im trying to format it in rows like:[code]and i want about 10 records to show in flash at a time.[code]
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?
I can get string data through a web service from MSSQL in AS3. However, I need to create a datagrid in Flash CS3, keep getting a table data and display those data in a datagrid (update per 10 seconds) The web service can return dataset. I am not sure how does AS3 get that datatype and convert to datagrid properly. Here is the AS3 code used to get string data from web service:
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?
I am changing the flashvars variables v1=value&v2=value ect then after the flash movie runs I am changing the variables externally by javascript, so far so good.when flash first loads it reads the vars correctly.when I try to read them ( after the change ) it keeps reading the old values.[code]everything works except I cannot seem to read the changed FlashVars.
could you please point me out good Flash and ASP.NET integration tutorials out there? For example reading values from FLASH text-boxes for performing queries to MSSQL databases, and writing back values to flash.
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 am writing a Flash object which will be an on-line quiz. I got most of it working ok, but it reads the questions sequentially from an xml file. I want it to be random. Each record in the xml file has an 'ID' attribute. This is my code that currently reads the questions in sequential order:
var question = new XML();question.ignoreWhite=true;question.load("Questions.xml"); question.onLoad=function(){ question_txt=this.firstChild.childNodes[_root.record].attributes.ques tion; answer1_txt=this.firstChild.childNodes[_root.record].attributes.answe r1;
[Code]...
There are 300 questions in the xml file. I want to assign a variable with a random number, then look in the xml file for the question which has the ID attribute matching the random number. How do I achieve this?
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
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].......
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.
I am doing an Actionscript 3.0 project which involves introspection. I am wondering if there is a way to get all the classes within a given package structure.
