ActionScript 2.0 :: Flash8 Pull Information From Database
Jan 7, 2010
Let me see if I can explain this clearly. What I am trying to do is pull information from a seperate file into Flash to be used as variables. I have read several places that Flash cannot pull info from Excel, so that is problem number 1: How can I store the information in a spreadsheet-like file so that Flash can access it. Then I would like the program to use combo boxes to access that information. Say I am going to draw a shape, the first box would choose the shape (ie Square, Circle, Rectangle, ect); this would then determine what would be in the next box.
So if my squares could only be red, purple, or green and my circles could only be blue, pink, or orange and my rectangles could only be black, white, or yellow. If I choose rectangle in the first box, I need the second box to list the three colors available for that shape.
What should I be using to pull information from either DataGrid or DataProvider Cells. I guess itemToLabel(), or getEditingData() doesnt work any more.
my normal work day involves screen sharing with a programmer while we engineer the software.We are currently working on a site that involves flash .as3(created with flash CS3) talking with an .asmx web service (created in Visual Web Developer 2005) that talks to a sql (2008)database.When can push or pull data from the database successfully, but we are experiencing a 15 second delay if more than one request from the database is made at the same time. i.e. two customers login at the same time, or one customer logs in and another submits changes to their account.
The second request will not be instant until 15 seconds have elapsed In other words, if someone sends logs in and another person logs in 10 seconds later, the wait will be 5 seconds.Of course, the delay is cumulative...so if 3 people log in simultaneously, there is a 30 second wait. Gross.This only occurs when we are trying to access the database...flash and the web service seem to talk great together otherwise.
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?
I am reletively familiar with XML and how to load them in flash, but I have a new kind of file, XMP, and I was wondering if it could be loaded and used in flash similar to XML. My XMP's are automaticly generated by the new Adobe Lightroom software and look similar to XML's - a copy of a file below
All the XMP's are created the same with just the information changed and have the same name as the image the information is about. So can flash phase this kind of file? I want to use some of the information in an XML gallery with details of the pic shown from the AutoGenerated XMP file (current relevent info highlighed). Has anyone attemped to use XMP metadata in flash?
To simplify what I said above Every pic has an xmp file of the same name in the same folder as the pic. I want to use the generated information to display details about the image in an information box I am yet to create . The highlighted information is what I need to load at the moment but other information may come in handy when i get the page developed.
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?
I've been looking around the internet now and haven?t been able to find anything referencing my problem so I thought I'm looking to create a series of adverts for our website. I say adverts, there more like a ?what?s on? synopsis of our website on a area specific homepage. We have 22 area homepages that need to display certain adverts.
What I?d like to be able to do is setup an admin system for my boss to use so he can control via the admin system the adverts to be displayed on each area homepage. I?ve seen that you can import database information via text fields on the movie itself but I?d like to be able to set the movies up so they pull the relevant information into the action script (basically referencing which file name to load and in what order.
I want to create a slideshow banner that will showcase our products. The slideshow will contain the image of the product, the name, the price, the item code and the link when someone clicks on it. Each week we update the best sellers and it can be from 5 to 15 different products. Similar to what we have now in our website www.deiequipment.com which now is static, we want to animate it and rotate the products like a slideshow.The problem we are encountering is that we have to manually update the slideshow content.
We would like to know if there is a way through scripting or catalyst to connect to a database and simply update all these fields automatically. So for example if the database has 5 items, automatically will pre-fill each field listed above and the slideshow will have 5 products.
If we update the database now with 10 products, to update automatically. That way we can create 1 slide show, the time it takes to rotate to the next product, and add simple button controls to the slide show for next and back that will simply go through the loaded items.I tried to do a research on how to do it online but some takes me to scripting, others to catalyst dabases, but none are specific to what I need.As a note, the image will just be an image holder that will be updated with the image field in the database that points to the URL location of the image.
I have an input text field, with only one character and aligned to left, where i put information dynamically. If i put the character from actionscript, it doesn't align as it should. If i manually enter a character then it aligns well. After i manually added the character, if i try to add it from actionscript too, it aligns correctly. The font i use is created by me, and all the letters are aligned the same way. I embedded the font.
I need a DataBase Software that collects E-Mail and personal information from subscribers in a Flash/HTML Website i'm building. I would like this program to be compatible with languages like: AS 3.0, HTML and CSS. This program must also have good marketing features like sending batch E-Mails, images and many things.
Got a client that says that Flash ( a panel that is pulling information from a database and simply displaying it in text field.) is not working in IE7. I told them that this is impossible as Flash is completely crossbrowser compatible. Am I missing something?? Is it a possibility?
I need to create a login page in my flash site that relates to information input to a mysql database. after the submit their information we want to send them a link to a differnt flash page with a login screen they will use their first name and a password (already in our database) to gain access to this "new" page. on that page there will be a welcome message that says "Welcome, User First Name" so I guess i have two questions
1: how do i set up a login page?
2: how do i pull that login info to a welcome page?
How I can send some text in a dynamic flash textfield to a mySQL database and vice versa? Basically I've created a text field - assuming it has to be dynamic (with an instance name of "tUserdata"), it's going to be multiline text, and upto 255 characters. As the user clicks the submit button, the data held in the flash text field is sent to the mySQL database and stored there. I understand that i have to use PHP as well - and heard i need to use the loadVars function. Need Coding in PHP and connecting to a MySQL database, and what actionscript I need to insert.
im trying to output my database information in a text input field in flex by using remoteObject(cfc). The information is being provided by a database using a query and an array collection. I'm just unsure how i go about taking the queried array collection information and display it into TextInput Fields.
I have a wordpress based site that stores information about an image in a database field called "background" in a table called "wp_postmeta".The 'loader' gets an url such as "/thisImage/background.swf"The "background.swf" should somehow display "background.jpg" instead but since I've changed the field name in the database (from background to temp_background) it doesn't work.I pass variables to the "loader" swf and they are correct based on the new field name but it still isn't working.I need to know if there is anything in the .fla's (and therefore the .swfs) that is pointing to somewhere in the database hard-coded. Basically I need someone to look at them and tell me how they are working.
I'm kinda noobish when it comes to getting information from XML information sent to my flash file from the socket server. OK so for example the server sends me this:
[Code]...
I want to get the name of the user and the X and Y position! Is there a way I can get this information without a load of fuss from functions and other junk remember im kinda noobish.
I want to build a program built around my pc specs. Is there a way to access such information as how much ram I have or how much cpu usage is being consumed, etc.?
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...
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
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 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:
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 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.
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 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?
