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 RepliesI am sending a query string post to saleforce to generate a new lead. It works great when it is used locally. However, from the web server it fails.
[Code]...
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]....
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.
I am successfully Passing HTTP Query String to Flash Query String.Resuming:inside html
HTML Code:
' <EMBED src="Film1.swf'+document.location.search+'"
'+
[code].....
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]....
how getting data back from a php script which query a DB?
View 1 RepliesHow to get query string from URL? The characters past the ? in IE. [URL]
View 1 RepliesI 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.
[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 RepliesHow to get the query string in AS2.0.
View 2 RepliesI'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.
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 Repliesasically 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]......
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 Repliesi 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]....
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
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 Repliesit has been awhile since I've monkeyed with Flash and it seems things have been moved around since then.any chance someone could post a simple action script to add to a button that will upon release randomly send to either frame 53 or frame 69 of my little CS4 project.
View 5 RepliesHow can i make a SQL query from actionscript? and render all the results
View 3 Replies[URL]I have a checkbox renderer i am placing into my Datagrid. The checkbox needs to do a sql query on the sqllite database and see if the show is marked as watched, if it is then make the checkbox as checked and if not mark the checkbox and not checked.
What i would like to do further to this is add the watched items to one XMLList and add the not watched episodes to a different XMLList and have the checkbox on click= move from one to the other list as per watched or not.
[URL]
I 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...)
Im 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 RepliesI have a MySql DB with 2 tables:
1. category - categoryID / category / description
2. photos - photoID / categoryID / photodescription / photo
And i have a service (CategoryService.php) automatically created by Flash Builder, but i cannot get the second table
[Code]...
When we reference a SWF file from our ASP.NET page we append the version number to the SWF url, like App.swf?1.1.0.0. In a recent update, Firefox has continued to use a cached swf even when the version number changed, App.swf?1.2.0.0. We haven't noticed this behavior in other browsers.
Has anyone else seen this behavior? We don't want to disable caching completely. At this point we're probably going to change the name of the swf for each version, like App.1.2.0.0.swf, which seems a bit excessive.
Basically, I have a URL to a SWF, but I need to get some info to the SWF on load. So the FlashVars seemed like a perfect fit. the link+query string -> HTML page using SWFObject 2.x to embed the SWF ->JavaScript to use the "document.location.search" in order to get the query string.
Here's my HTML code:
HTML Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
[code]...
When I leave the alert on in the HTML page, it displays the query string of
"grade=0&workmat=1&manipulative=2"
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:
[Code]....
how I could remove anything after a prefix in this string... [URL] so need to end up with [URL] The query string may change so need a way of telling it to remove anything after .flv
View 5 RepliesDid not know what forum to post this in as it covers different platforms and I am not requesting with specific code, but I have lost my way with a project and cannot get back on track. I am building a booking system (ar'nt we all) and it's turned into a puzzle that I can't piece together.
I have a MySQL DB with some php pages ( sql queries contained in the php to get the data) and I have some AS3 code that draws a illustration to the screen of the booking data. At the moment the illustration is drawn from data that I have put into an array. The bit I cant figure out is how do I get the data from my php sql query into the array in AS3?
I have a Flash movie exported as an exe file, that loads information from an XML file situated on a server, like so:
var urlLoader:URLLoader = new URLLoader();
var urlReq:URLRequest = new URLRequest("http://server.mydomain.co.uk/info.xml");
urlLoader.addEventListener(Event.COMPLETE, loadXML);
urlLoader.load(urlReq);
I'm testing the exe from my desktop and it's working fine, calling the URLs in my default browser. I would like to ask, will the exe work from any machine with internet access? Or are there likely to be problematic security issues? I haven't had to change any security settings for the exe to work on my PC.
I just want to make sure that there are not likely to be any problems in my particular situation (zero margin for error with these clients!).