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
when i have this line active(the red one) it gives me automatic focus, so no clicking to be able to detect key input so i got that going for me which is nice BUT when i have it active(not commented out) i get this big yellow line which goes away when i click it(seeBelow)
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:
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.
I 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:
I am in the middle of designing a 16 x 16 grid sequencer with a row of buttons that light up and sweep across the screen as shown in the attached picture. Basically i was wondering would this be best done in flash cs5 as its hopefully going to be coded with actionScript or should i use other adobe apps like illustrator etc? I was also wondering how to get the lights to trail behind as the lights travel across the buttons?
Just a quick query, i work with Lightwave 10 on the mac and i was wondering it it can be incorporated into flash cs5 at all?
I have followed Kirupa's tutorial for a pop-up window (flash 5) but am applying it to Flash MX. It works ok except that is ignores the height and width settings.(I don't want the centred pop-up by the way).
I have been reading this page about passing a query string to a flash file and I have it all set up using Javascript.URL...My next question that the page doesnt seem to cover is how do you then get flash to manipulate the data from the query string?So say I pass example.swf?testtype=1, I want flash to grab the value of testtype.
I watch shows and videos on web sites Often the web site uses Flash Player to display these videos. I wrote a plug-in for my Firefox web browser to log what I have watched or (if I had to stop) where I left off.
I'm attempting to use mod_rewrite to clean up the URL's to a flash video player. First,here is the original URL that I'm trying to rewrite to:library/player.swf?path=path-to-file.flvhe above URL works perfectly fine when I access it directly. I have coded the swf to automatically grab the path parameter and play the video. No problems there. Now here is my attempted rewrite rule:RewriteRule ^player/(.+)$ library/player.swf?path=$1 [QSA,L]When visiting the url player/path-to-file.flv, I get the swf but no video loads. I set up a popup window in the flash to tell me the path name for debugging purposes, and it looks like the path isn't being passed at all.On the other hand if I use the exact same rule but point it to a test.php instead of player.swf, the test.php file is able to echo out the parameter
In as2 it was very easy to access query string just using _root, but this doesn't seem to work on as3.[code]How do i access value of a? I tried it with _root as well as in flash client tried this userNameTextField.text=root.loaderInfo.parameters.a;But both doesn't seem to work. What can be the problem?
I've made a query in PHP, and I'm trying to send the results back into Flash via AS3, but it's throwing up this error...
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs. at Error$/throwError() at flash.net::URLVariables/decode() at flash.net::URLVariables() at flash.net::URLLoader/onComplete()
Here is the relevant part of the PHP and AS3 code, including the query. The Flash variable rssAdd is passed over to the PHP which is using it in the PHP query accordingly. $url = $_POST['rssAdd']; $query= SELECT title FROM Feed WHERE category = (SELECT category FROM Feed WHERE url =$url) AND url!=$url; $result = mysql_query($query); echo $query;
Here is the AS3 code I've done so far. function recommendation(){ var request:URLRequest = new URLRequest("url"); request.method = URLRequestMethod.POST var recVars:URLVariables = new URLVariables(); [Code] .....
I'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).
Usually when I make a shape I can select it with the selection tool and lots of dots appear on the shape showing that I have selected it. I was playing around with some key commands and I think I accidentally did something now when I select a shape it ha sa thin blue outline. Can someone please describe what this means and how I can change from this to the other option?
then "this" is undefined.I even wrote a little PHP script to dump the contents of $_GET (changed the rewrite target temporarily), and I'm positive that the rewrite rule is working.
mod_rewrite clarification:
To demonstrate the strangeness of the problem, let me temporarily change the rewrite target to "object.php", so the rule now reads:
Then, when I navigate to /object, I get the following output:
Array ( [this] => that )
This demonstrates that the rewrite rule is working as expected.Still, when I change the rewrite target back to the SWF, "this" is not recognized as a flashvar.(I'd definitely check the rewrite log to make sure, but I don't think I have access to it on the Media Temple server I'm using.)
I am trying to create a query from Flash Builder to PHP/mySQL with selectedItems. I have a simple SELECT query set up to populate a datagrid of items I would like to select for main query (two records looks something like this "19 10","20 10"). This is where I get stuck. I don't know if I need to break down the selectedItems in Flash Builder for formatting in SQL or if I can do it in PHP.
I would assume that it should be done in Flash Builder and I would then send the partial SQL statement to PHP. As of right now, Flash Builder is holding the selected values as CustomObjects and I unsure of how to retrieve what is in the objects for formatting.
var arr:Array = dataGrid.SelectedItems
This yields an array of CustomObjets and I lost from there.I will need the resulting SQL statement would need to look something like this.
SELECT * FROM Stats WHERE neu IN ('19 10','20 10');
I've embedded a font in a flash based website. The site loads external swfs which also contain content in that font. Can these external swfs make use of the font without it being embedded in them?
my Problem is that i want to load a external swf in the main swf main by passing Querystring from flash cs4(AS3) and get variables from html page...... but Not working Iam attaching the fla files folder
I am trying to pass the variable myMOV to my flash using the following additions in my object tag:[code]I want flash to gotoandplay the label "music" but it seems I am not passing the variable correctly.
I recently had a flash project that required me to get query string variables and found it cumbersome, however i found a query string class here on the forums originally created by MichaelxxOA over at actionscript.org. [URL] I reqrote it and structured it to act like Request.QueryString() familiar to those that have worked with asp and aspx.