Data Integration :: Run A Query And Convert The Results To An XML String?
May 30, 2007
I need to run a query and convert the results to an XML string. I *think* I need to do all of this in PHP but I wanted to get some guidance as sometimes I make things more difficult than necessary.
Do I have 2 scripts... one to query and one to process the results to XML? Or can I put them both in the same script. To do the latter is not proper OOP practice, correct?
Once that is done, I can get the data into Flash. I need it to be XML though because the same data is being used elsewhere outside of Flash.
Is this the proper, most efficient way of handling this task?
View 4 Replies
Similar Posts:
Sep 5, 2006
We have implemented a Flash photo slideshow on our site and it works just fine for most of our users. Whenever the xml.load(success) returns false I have the Flash email me a debug report. For the life of me I can not find a common thread between all of these people having problems with the Flash. I don't think it's a cross-domain issue because it works for most people, and I have the crossdomain.xml files where they should be.
[Code]...
View 1 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
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
Apr 27, 2010
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.
View 2 Replies
Aug 11, 2010
I'm working on a movie that needs to get the query string data, but I can't just pass it in, as I don't have access to the embedding page, and can't get the author to edit the embedding options. I need to do it all within the movie.
I've seen examples of as 2 using ExternalInterface.call("window.location.href.toStr ing"); but I can't get it to work. Is there another way in as3?
View 1 Replies
May 15, 2006
I've made an animation where the user has to draw something,from there i want the user to save his/her animation to a jpeg file...
View 2 Replies
Jul 4, 2010
I have a Facebook application that has a picture gallery. It's build in Flex 4. I want to allow users to link to a specific image. How can that be done?
The only way I see this being done is adding a GET var like &my_picture=asd.jpg in the Facebook page URL, but I don't know how to read that from the iFrame.
View 2 Replies
Oct 27, 2006
I need to open a text file, parse it and convert it into XML using Flash. Is this possible with Flash 8 Pro?
View 3 Replies
Jul 3, 2006
I have an Array retrived from XML via xPath. I then compare one bucket with a string and dont get the result i want. It seems that the XML string isn't really a string.
[Code]....
View 1 Replies
Oct 15, 2006
ok so when i need to connect a swf to some sort of data source on the server be it XML, a .NET DLL, a CFC or what ever so that i can load data from a database or what ever, everyone is always saying that i shouldn't hard code the connection string into my actionscript as anyone can get it and do malicious things with it. So how should i load the connection string into flash. if i put them on the server in an XML file or somthing like that then i still need to put a connection string into the actionscript in order to load in my main connection strings into the actionscript.
Basically i need to know how to load an external string into a swf without anyone else being able to get hold of that string for them selves. i am developing an app for somone and i need it to connect to a database and i need it to be secure. i have everything sorted except making the connection string to the database unstealable.
View 1 Replies
Apr 23, 2010
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] .....
View 2 Replies
Feb 23, 2011
I located a code example to reference my ASP.NET web service and have saved it as MainDocument.as. I have a combo box cbRentalType that has entries of Party (value=3), Sale (value=1) and All (value = All). I have a combo box cbCatSelect that allows the user to select Product Categories. I have a text input field txtSearch where the user enters their search string.
What I need to do:
1. Submit a query with RentalType=1 or 3 or Blank, Category = dbCatSelect.selectedvalue and Product Keyword = txtSearch to my web service.
2. The ASP.NET web service returns all database entries from MS Access query named ProductDetailsAll. These query results need to be populated in individual rectangle objects with dynamic text fields for Product Name, Image, Description and Price. How do I set these dynamic fields to populate data from my query?
3. The Flash movie clip contains 16 rectangles, or can house up to 16 product results from the web service. If more than 16 results are returned, how do I populate a new page of product details in my movie clip?
4. How do I reference the outgoing variables in Actionscript 3.0 pertaining to CategoryID, RentalType and search string? How/where do I store the incoming variables for Product Name, Description, Image and Price?
View 1 Replies
Jun 22, 2009
i have a string which contains all binary data. the binary data represents a custom object in my application.
i want to convert all the data inside the string into binary format and store it in a ByteArray. then I want to read the object from the ByteArray using readObject.
View 2 Replies
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
Oct 11, 2011
I have a string that searches the Twitter API, for keywords, for example :
var url:String = "http://search.twitter.com/search.json?q=Robin%20&lang=en&rpp=100";
I also have a input textfield dynamically created:
var inputField:TextField = new TextField();
addChild(inputField);
inputField.border = true;
inputField.width = 200;
[Code]....
But how do i take the data from the input text field and add it to the string, keep in mind the input data has to go in the keyword part for the string.
View 5 Replies
May 13, 2011
I am querying to server through flex,first time its show the result but when I insert a new record and query next time,its shows previous results only(problem facing in IE but not in chrome).
View 2 Replies
Jan 2, 2012
I'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]...
View 1 Replies
Dec 27, 2006
I found the following XML - Flash quiz template on the net and I was wondering how can I adapt the XML doc to pass CDATA instead of "Value". The code is currently sending the "answers" values into Flash as value, instead of values I will like to type the answers inside of CDATA tags. I don't know how and what to change in the XML as well as in the AS file.
View 1 Replies
Oct 3, 2007
I really don't understand why this won't work? I've made a test which sends some POST data to a script on my page which works fine.[code]
View 14 Replies
Jul 9, 2011
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()
[Code]...
View 1 Replies
Aug 15, 2010
I get following Error when trying to pass variables via URLRequestMethod.POST;
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
Is there a method for string URL Encoding?
View 4 Replies
Jun 21, 2009
I am trying to make a contact form. When I test the form, I get the following error message in the Output:
[Code]....
View 9 Replies
Jul 10, 2011
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() _____________________________________________________________________ ________________________________ stop(); var DepartVars:URLVariables = new URLVariables(); var DepartURL:URLRequest = new
[code]....
View 9 Replies
May 4, 2010
Error: Error #2101: The String passed to URLVariables.decode() must be a URL-encoded query string containing name/value pairs.
[Code]...
I'm not where error exactly the error happen so I post the whole thing. As far I know bottom code that relate to send_loc.php works fine, get_loc.php is having a problem. The output from get_loc.php is
[Code]...
View 2 Replies
May 4, 2010
I need to be able to pass some variables FROM flash and append it to the end of my address. I assumed that if I used LoadVars, I can append the vars to the end of the string like this:
ActionScript Code:
send_btn.onRelease = function ()
{
var my_lv:LoadVars = new LoadVars();
[Code].....
View 4 Replies
Mar 21, 2007
I'm trying to write a function that'll take a set of results, assign a probability to each result, and then pick one result at random, according to its probability.I thought I'd calculate the area under sections of a basic parabolic function (y = x^2) to generate the skewed probabilities.
Because of the nature of this curve, the amount of skew is determined by the range of the parabola used, as x tends to zero, the gradient tends to zero, so using 0 - 0.001 would be only slightly skewed. As x tends to infinity, the gradient tends to inifinity, so using values 0 - 100 the probabilities would be heavily skewed.to recap then, my function would be passed a skew factor, essentially the upper limit of the parabolic graph to use. All I need do is divide the whole range into equal sections according to the number of values and determine the definite integral for each range of the parabola assigned to each of the possible values. Make sense? Good.
integrating y = x^2 gave me y = x^3 / 3
from this I developed the following code:
PHP Code:
vals = ["dog", "cat", "monkey", "horse", "marmotte", "hampster", "yetti", "ant", "mouse", "duck"];
skewfactor = 9;
trace(getProbabilities(vals, skewfactor));
[code]....
and it kinda worked. It produced a set of probabilities which looked like they fell in line with a simple parabola.My problem is that no matter what skew value (i.e. max range) I pass in, it produces exactly the same results and I'm not sure if my maths is wrong, my theory on the nature of the curve is wrong or if my code is wrong.
View 5 Replies
Jan 1, 2010
I have a video player that is currently using XML for its video library which is all fine and dandy. Now I have some developers working on a CMS type page in PHP that is going to hopefully pass some sort of information to my player that will let it know where the video is stored on our server. Is there a way to do this without using FMS? If so does anyone have ideas where I can find the information for it.
View 2 Replies
Mar 22, 2010
How to get query string from URL? The characters past the ? in IE. [URL]
View 1 Replies
