Actionscript 3 :: Return ArrayCollection From SELECT Query
Oct 23, 2011
In my AIR app i am trying to get the names from sqlite database as an ArrayCollection . Here is my code.
private function visitorName():void {
var sqlText:String = "SELECT name FROM user";
visitorNames = new SQLStatement;
[Code].....
What should i do to get the results to an ArrayCollection by calling the visitorName() function? Is it possible to get return value from a nested function?I know the visitorName function should be changed to ArrayCollection type and should declare an ArrayCollection variable inside it .. but not so sure how to proceed .
View 1 Replies
Similar Posts:
Feb 18, 2011
i am using Flash CS4 (AS3) + AMFPHP + MySQL to do own flash frontend for Wordpress CMS. Everything is going fine but i`ve got one problem. Problem with properly display of result of query in AS3 by using ArrayCollection.
When i check my service in "amfphp/browser/" in web browser i`ve got this (with all needed data):
...
(mx.collections::ArrayCollection)#0
filterFunction = (null)
length = 2
[Code].....
I know that "result" is an ArrayCollection type but i don`t know how to get rows and columns from this. I know that my data is there but i have no idea how to get it.
how to get to Arrays and simple data variables which are in ArrayCollection.
P.S. I tried also change query type in service.PHP for mysql_fetch_query but in that case i`ve got only one row (not all data).
View 3 Replies
Dec 21, 2009
i have made a very simple application where i have created a ball which follows the mouse.However, seeing that i am new to this, what is the easiest/common way for me to be able to display the value of my "distance" variable without having to make my velFriction of type void? because if i make it void i can trace the distance value between the ball and the mouse but the ball moviclip stays still.
Code:
package
{
[code]....
View 3 Replies
Dec 21, 2009
i have made a very simple application where i have created a ball which follows the mouse. However, seeing that i am new to this, what is the easiest/common way for me to be able to display the value of my "distance" variable without having to make my velFriction of type void? because if i make it void i can trace the distance value between the ball and the mouse but the ball moviclip stays still.[code]
View 1 Replies
Sep 23, 2011
I have flat data in my app which I will need to group, summarize, and count as I normally would with a sql query. For this project though, it must be done in the flex app. I need to figure out how to group my data by day or month using a datatime field in my Arraycollection, then appropriately count or summarize data in other fields. I've used Groupingcollections before, but only when binding to hierarchical controls (like AdvancedDataGrid and Tree), but I need a resulting ArrayCollection with the grouped and summarized data. Basically, I'm trying to access my AC like a sql table (GROUP BY MONTH(datetime), COUNT, COUNT(DISTINCT(), etc.) and I'm unsure how to do it.
View 2 Replies
Dec 21, 2011
My code is:
var dataList:ArrayCollection = new ArrayCollection([{name:"alauddn"}, {name:"ansari"}]);
private function getItemInd(event:MouseEvent):void{
var item:Object = new Object();
item.name = "ansari";
var ias:int = dataList.getItemIndex(item);
Alert.show(ias.toString() + ": " + item.name);
}
But it returns "-1:
View 3 Replies
Feb 22, 2011
I 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?
View 2 Replies
Apr 16, 2010
I'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]....
View 1 Replies
Oct 27, 2009
I'm new to Flex and am using TileList bound to an ArrayCollection. The array collection is empty at load time, and then updates with the results from am HTTPService call. The problem is that the item renderers aren't being rendered as expected, I'm guessing because there was no data when they were first rendered at load time. Here's simplified example:
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" >
<mx:Script>
[code].....
View 2 Replies
Oct 7, 2011
I have a advanced datagrid and populating some data by using arraycollection. And i am filtering the arraycollection, the arraycollection index got changed.
Arraycollection:- [0] - name: abc
[1] - name: hello
[2] - name: hello1
[3] - name:hai
after filtering the arraycollection as 'hell' , the array collection is displaying like the below:
Arraycollection:-
[0] - name: hello1
[1] - name: hello
Can i know the reason why the index got changed after filter it?
* no server side code for filtering. it is only flex side filtering.
View 2 Replies
Jun 23, 2010
I have a comboBox and values like basic and advanced. And viewstack container conatains 2 grids.When i select the base option in Combobox, the first grid has to be selected. select the advanced value in comboBox, the second grid has to be selected.
<mx:ViewStack id="viewstack1" width="95%" height="85%" x="0" y="63" >
<tables:KeyMetricsBasicTable basicArrayDataProvider="{basicArrayResult1}" width="100%" height="100%"/>
<tables:KeyMetricsAdvTable advArrayDataProvider="{advArrayResult1}" width="100%" height="100%"/>
</mx:ViewStack>
View 1 Replies
Dec 6, 2011
Flex 4 Combobox is extended with a Text Input that helps in getting to the item that is searched for.I have created a Check Box as an itemrenderer for this Flex 4 Combobox. I would like to Add a Select All and Select None options in the drop down of the Combobox. I know that i could accomplish by editing the dropdownfactory in case of a Flex 3 Combobox. But in Flex 4 the dropdownfactory doesnt exist.
View 2 Replies
Aug 26, 2010
I 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.
View 4 Replies
Aug 26, 2010
I am successfully Passing HTTP Query String to Flash Query String.Resuming:inside html
HTML Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
[code].....
View 1 Replies
Aug 4, 2009
I'm having some troubles with the use of interface and inheritance in AS3. I've done lots of OOP in the past and what I'm trying to do seems obvious to me, but doesn't work in AS3. The question is : Is it possible to override a function that return an Object of class A, and make it return an Object of Class B which extends A ? It seems not to be possible, since I'm getting a signature error in Flash, when compiling. For example, the following set of class do not compile (the code in function definition doesn't matter):
[Code].....
View 3 Replies
Jan 6, 2010
i am currently reading Learning Actionscript 3.0 A Beginners Guide and i'v stumbled on a code snippet tutorial that i hope you can explain to me, P.139. What i am trying to do is essentially create a particle system and the following code snippet i'm not sure about is the following
[Code]....
View 1 Replies
Feb 11, 2010
how getting data back from a php script which query a DB?
View 1 Replies
Mar 22, 2010
How to get query string from URL? The characters past the ? in IE. [URL]
View 1 Replies
Dec 14, 2011
I have a database which has 2 tables:
CREATE TABLE RecipeDB (
RecipeID INT PRIMARY KEY AUTO_INCREMENT,
Name VARCHAR,[code]........
I also have an actionscript, in which I have ingArr:Array of ingredient strings.Now, I would like to realize the following queries here:
1) Select (all fields) one recipe which has the most of ingredients from the array. If more than one record have the same amount of matches, then divide the number of matches by total number of ingredients in recipe and return the one with the highest ratio. If there are no matches return nothing.
2) As above, but return 10 recipes with the most matches and do not perform check for equal number of matches. Sort the results by the number of matches.
View 2 Replies
May 27, 2009
[code]I am not sure whether i am going correct, i am always getting the return value no though i enter the correct username and password.
View 7 Replies
Aug 24, 2009
How to get the query string in AS2.0.
View 2 Replies
Apr 16, 2009
I'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.
View 6 Replies
Sep 8, 2004
Just a query into the use of the code in the MX tutorial, namely the snow flake effects. Is it OK to use the code for a university assignment which is completely for non-commercial use?
View 2 Replies
Nov 29, 2005
asically in my company we use Flash with XML to create traininig materials. One of the pages we create is full of links to other swf files to load for resources (basically static pages with a picture and linked mp3 files).The main page that houses all these links loads an xml page then we have these "link movies" that call upon a node of the xml. Basically on the movie clip the code is:
Code:
onClipEvent (load) {
//Set the name of the XML document
[code]......
View 2 Replies
Feb 3, 2011
I have the following php file that generates an xml from a sql_query:[code]Is this the right way to generate xml from a sql_query that will be taken into AS3 as I do not want the xml to print to the screen I want it to be taken into AS3?
View 1 Replies
Sep 14, 2011
I am passing array collection from flex to web service, and now that array collection want to use in asp.net web service.
suppose i have passed one array collection, and based on that array collection i want fetch value from database and want to generate report and returning path to flex.
View 2 Replies
Jun 8, 2006
i was mugging on this tutorial :
[Code]...
The return a.attributes.first > b.attributes.first will return what value?
View 1 Replies
Jan 29, 2009
I am designer and working on some Flash Banner design projects.client need it according to Google terms as it is going for google Adwords Program , so i am using this code:[code]but my probem is that i have done all the animation inside a Movie clip and i the button is inside the movie, can i paste the code on the insode button or i should create a button on main stage ?
View 2 Replies
Apr 2, 2010
I have a form that sends data to a results page. I would like the results to manipulate a SWF file through the actionscripts.
EXAMPLE:
Form uses 3 radio button submissions.
Upon SUBMIT it sends data to results page creating a string seen below
Results page receives data (form_record.php?Q1=Q1D&Q2=Q2D&Q3=Q3A)
Results page houses SWF
SWF uses the string to control the action of the Flash.
Can be a simple as if "Q1=Q1D&Q2=Q2D&Q3=Q3A" is recognized it does a gotoAndPlay
View 2 Replies
Sep 2, 2010
Whats the best way to have my movie play only when the homepage loads? I have the movie on every page as it is my navigational bar however I dont want it to play except when somebody loads the homepage, and I dont want to create a static version because then my site will have to load 2 versions.Is there some query code in actionscript to query the current URL of the loaded page? I guess I just set up a conditional statement and if its true, gotoAndPlay.
View 1 Replies
