ActionScript 3.0 :: Flash Database Query Keeps On Returning Nan?
Aug 18, 2011I'm having a problem with my flash-php-sql integration, my text output in flash keeps on returning NaN even if the data in mysql has a valid number(double).
View 1 Replies
Similar Posts:
PHP :: How To Send String From AS3 For Database Query
Oct 6, 2011Im building this AIR app on Flash CS5, and I have this TileList that loads its data (images and names) from a database. I want to do a query with the name any item of the Tilelist when its clicked, so i need to send the name of that item to a PHP file that will execute the query. I am thinking of a function that loads the item name to a variable when the item is clicked. How can I send it to the PHP file and how would I load it to the query? The query I want on the php file goes something like this: Select lat, lon from mapdata where name=theVariable;
View 3 RepliesActionScript 1/2 :: Query A Sql Database And Echo The Image Into Xml?
Jul 5, 2010I am trying to query a sql database and echo the image into xml so I can view the queried image in flash.
I already know how to query and echo the image url from the database.
This is the code:
//The database is already queried at this point.
echo "<?xml version="1.01"?>
";
echo "<content>
[Code].....
The echoed xml in the first code produces a url link that contains a link to an image in the database. The flash is supposed to display the image on a flash movie clip call movieobject. I am having problem getting the image displayed in flash.
ActionScript 2.0 :: Dynamic Text From Database And Textareas Query
Sep 29, 2004I have text being inserted into a textarea component dynamically from a MySQL database. The problem is getting characters like the ampersand (&) to show. Also the carriage returns are being processed twice (or the carriage return and newline characters are both being processed).
View 3 RepliesActionScript 3.0 :: AMFPHP Design - Database Query Tool?
Mar 4, 2011just for fun I have been messing around with AMFPHP and I have hit a design problem and I was just wondering if anyone had any input?
I have been using AMFPHP to make calls to a PHP script like so:
[Code]...
Database :: Displaying Query Data In A TextInput Field In Flex?
Feb 12, 2010I'm trying to display query data into multiple TextInput Fields in Flex.
<mx:TextInput id="stagInput" text="{acContacts}" width="170" x="120" y="74"/>
This is what I'm trying but all that displays is [object Object]
I think I need to define the database field I'm wanting to display, but I'm unsure how to do this as TextInput fields don't support dataField or labelField properties. Is there another property I don't know about? How do i go about fixing this?
ActionScript 2.0 :: Pass Variables To Php Then The Php Runs A Query From The Mysql Database
Jul 28, 2011I want to pass variables to php, then the php runs a query from the mysql database, and then sends back the new variable... I looked for tutorial, but nothin' seemed to work.
[Code]....
Flex - Security Restriction - Save The Results Of A Database Query To A Local File?
Jan 2, 2012I'm having some trouble getting around a security restriction of flex. Saving a file is apparently an action that can only be invoked upon user interaction. The problem is that after my user clicks on the save button, I need to perform a database query to get the data for the file I want to save.
Because Flex works asynchronous, I have to make the database call and then catch the ResultEvent in a different function. In that function, I no longer have the user's mouseclick event. How am I then supposed to save this file?
[Code]...
ActionScript 3.0 :: Send Search String To Database Query And Return Results To Dynamic Text Fields?
Feb 22, 2011I have a dropdown box that is used to select a Category. I need the Flash Application to send the value of Category plus the search string in my textbox to my Access query and return results for each product meeting selection criteria. The Flash Application is calling an ASP.NET web service which in turn queries an MS Access database.
To start, how do I define the category ID and search value in my Actionscript 3 code?I've placed a series of 12 or so objects that will be populated with the product description, title and price. How do I setup each field to be dynamic text associated with the title description and price from my query results? If there are more than 12 products returned by the query, how do I add an additional page of objects to house more than 12 query results?
Php :: Calling A Page With MySQL Query From Javascript Function Then Returning Results To Another Javascript Function
Jul 8, 2010I am refactoring some code. I have a PHP page that contains a MySQL query and stores the result in a PHP variable $my_result. This result is then echoed to a Flash SWF during embedding with SWFObject. I now want to call this PHP page that makes the query from a javascript function like so - one change I have made to the PHP is that instead of storing the result in a variable $my_result I am echoing the result. Javascript function to call the PHP page and make the database query
[Code]....
ActionScript 3.0 :: Passing HTTP Query String To Flash Query String
Aug 26, 2010I am successfully Passing HTTP Query String to Flash Query String.
Resuming:
inside html
Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
inside as3
[Code].....
Then Film1.swf can't grab no more the userName parameter.
ActionScript 3.0 :: Passing HTTP Query String To Flash Query String?
Aug 26, 2010I am successfully Passing HTTP Query String to Flash Query String.Resuming:inside html
HTML Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
[code].....
Query - Run A Sqlite Query In Flex To Count The Total Number Of Records?
Apr 16, 2010I'm trying to run a sqlite query in flex to count the total number of records I believe its working fine but I just can't figure out how to display the results - all I get back is [object Object].
private function overviewOne():void{
var stmt:SQLStatement = new SQLStatement();
stmt.sqlConnection = sqlConn;
stmt.text = "SELECT COUNT(user_id) FROM tbl_user WHERE status_status ='Away'";
[code]....
So how do I make a reference to the COUNT(user_id)?
(flash.data::SQLResult)#0
complete = true
data = (Array)#1
[code]....
IDE :: Make A Flash Movie Display Text That Is In The Sql Database And A Php Script To Change The Database?
Jul 15, 2009i 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 RepliesDatabase :: Connect Adobe Flash CS To Database Of Any Kind?
Jul 17, 2011Can I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 RepliesDatabase :: Is It Possible To Create A Database Driven Website With Flash?
Oct 26, 2006Is 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 RepliesDatabase :: Flash Database Grid Fill?
Jan 15, 2012I 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 RepliesFlex :: Get Local SQLite Database In Sync With Live Server Database?
Dec 17, 2009I 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.
Php :: FLEX Database Will Not Refresh After Updating Database Unless Browser Is Restarted?
Jun 7, 2010I 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]....
Database :: Save A Form To The Database Without Knowing The Field Type?
Jun 17, 2010I 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].......
Php :: FLEX Database Will Not Refresh After Updating Database Unless Browser Is Restarted
Aug 31, 2011I 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].....
Database :: Approach Local Database Management Via Flex/Air App?
Jan 17, 2011I 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.
Database :: Adobe Flex With Accessing Database For Mobile Web?
Sep 26, 2011Here 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]...
Getting Query String Into Flash CS3
Apr 16, 2009I've looked up quite a few tutorials, how-to's, etc. on how to pass a query string into my SWF, but it isn't working. The page where the SWF resides is an ASPX page, and this is the code I used:
Code:
Select all <object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="[URL]"
width="756" height="433" id="gallery" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="false" />
<param name="movie" value="gallery.swf?ProjID=<%=Request.QueryString["ProjID"]%>" />
<param name="quality" value="high" />
[Code] .....
As you can see, it pulls the "ProjID" querystring and is supposed to pass it into Flash. I have executed the page and viewed the source to make sure it is pulling the querystring appropriately, as shown below:
Code:
Select all<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="[URL]"
width="756" height="433" id="gallery" align="middle">
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="false" />
<param name="movie" value="gallery.swf?ProjID=1" />
[Code] .....
I used "1" for the value, and "1" was what is in the page source, so I know it's at least getting that far. As for what is in the ActionScript, here it is:
Code:
Select allvar myProj = root.loaderInfo.parameters.ProjID;
var myGalleryXML2 = new XML();
myGalleryXML2.ignoreWhite = true;
myGalleryXML2.load("[URL]"+myProj);
myGalleryXML2.onLoad = function(success) {
if(success){
_root.myImages = myGalleryXML2.firstChild.childNodes;
_root.myImagesTotal = myImages.length;
It is supposed to load XML from an ASPX page that builds the XML from a database depending on the project ID (ProjID). If I hardcode the variable to "1" (or whatever other ProjID), it works and the correct images are shown for the respective ID. However, I can not get it to pass the ID from the URL to the Flash file. I've even tried "_root.ProjID", and a QueryString class I found through Google, as well as passing the ProjID through Param tags as FlashVars with no luck.
Database :: Which Database To Use For Flex Standalone Application?
Jan 11, 2010I 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 RepliesAS3 :: Flash Returning Undefined Variables From PHP
Aug 24, 2011Im trying to fetch some data from PHP and use it in a link in flash AS3. flash code:
[Code]...
ActionScript 2.0 :: Saving And Returning In Flash?
Mar 21, 2007know if it is possible to use PHP/mySQL or using just actionscript to save current status of the flash file section that you were currently viewing and returning to the same section at a later stage when you log back onto the website. What I mean is using a log in/log out script. e.g. > I am at a website (flash of course):> I sign in> start at section one of the website (homepage)> Use website> get to section seven of the website> log off> return later and log on to the website with my user id and password again.
View 1 RepliesActionscript 3 :: Flash - Make A SQL Query?
Apr 10, 2012How can i make a SQL query from actionscript? and render all the results
View 3 RepliesActionscript 3 :: Query If Flash Has Focus?
Nov 8, 2009I know I can detect flash gaining and losing focus with these callbacks:
stg.addEventListener( Event.DEACTIVATE, deactivateCb, false, 0, true );
stg.addEventListener( Event.ACTIVATE, activateCb, false, 0, true );
But is there anyway to directly query flash if it has focus or not?
(Trying to figure out if flash has focus when starting up...)
ActionScript 2.0 :: Passing Query From Flash To Php
Aug 25, 2009I normally send vars to php and build my query there, but this time I need to pass a complete query from Flash to PHP, but I'm having a little trouble:
[Code]....
