ActionScript 3.0 :: Send Search String To Database Query And Return Results To Dynamic Text Fields?
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
Similar Posts:
Nov 8, 2006
i am building a little widget that allows a user to type in keyword(s) into one input field and then a zip code into another
when the user clicks submit, it plugs them into the search url
i have it working for one input field, but i am not sure how to append the script for the second field...what would i need to change to the below script to add a second field into that query string?
Code:
btn.onRelease = function(){
getURL("http://www.google.com/search?q="+myInputField,"_blank");
}
View 4 Replies
Oct 6, 2011
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 Replies
Sep 29, 2004
I 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 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
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
Oct 18, 2011
Presently I have created 2 dynamic buttons. When I click on them I want them to return the value of a string into a dynamic text field. I am doing this using only as.....no timeline. Right now they are returning the value of sqaureMC and circleMC. How to I get them to add value of string?
View 7 Replies
Oct 8, 2006
i'm trying to write a function but with no luck. seems my brain capacity's limited the function will take two parameters: a term to search for, and a string to be searched. what i want the function to return is a new string containing the term (the parameter) along with a couple of words before and after it (as found in the search string).
View 2 Replies
Mar 16, 2010
is it possible to send a string to a function and return a object??? here is the code, but it doesn't work
[Code]....
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
Dec 3, 2004
I've just tried senocular's xml tutorials. [URL] The search query seems case sensitive. How to make it accept upper and lower case characters. Actually i'm trying to make a search by myself by using the same code.
View 6 Replies
Feb 18, 2005
I'm trying to port an application created in another language to Flash. I'm trying to implement a boolean function that simply tells me if a word I pass in as an argument is contained in the text field. So I am wondering if Flash includes a built-in function such as "find" or "contain?" which are common in other languages for determining if a word is in a text field?
View 1 Replies
Jan 1, 2011
I am work in Flash Builder 4.Create e-mail validator on Flex.Have this code
public var s:String="";
public function checkSumbols(_s:String=""):Boolean {
s=_s; //e-mail address (input mail@supermail.com)
[code]........
View 2 Replies
Mar 21, 2007
If it's possible to restrict hard returns in text input fields? I've tried something like this:
my_txt.restrict="^u0013", and a bunch of variations thereof, but nothing seems to keep the Enter key from doing it's thing. Second best would be to traverse through a string a user has entered and replace hard returns with a space or dash, but again I've had no luck looking for
or
I've tried entering text and hard returns into a dynamic textfield set to input, but when I try this:
var n:Number = my_txt.indexOf("
")...
trace("n: "+n) //traces "n: -1"
View 4 Replies
Mar 12, 2010
I know that as3 has some powerful new text search capabilities, especially when combined with regex. I don't even know if this is possible, but I would like to somehow, search any block of text, and return all nouns, adjectives and verbs. What would be the best(most efficent) way to do this? Is regex an option? or would I have to load in some sort of open sourced dictionary 9as used in spellcheckers) to compare with or?? After, I've pulled all the nouns, adjectives and verbs, I need to count and prioritize by their frequency.
View 4 Replies
May 20, 2011
I use this code to convert an image to a BitmapData and store a JPG in a ByteArray.
import com.adobe.images.JPGEncoder;
var jpgSource:BitmapData = new BitmapData (img_mc.width, img_mc.height);
jpgSource.draw(img_mc);
[code]....
Now, I want to do the following:
1. send the ByteArray to PHP;
2. PHP must store a physical image_id.jpg on server;
3. then PHP must return the URL of the image to Flash;
The first lines of PHP could be:
if (isset($GLOBALS["HTTP_RAW_POST_DATA"]))
{
// get bytearray
$jpg = $GLOBALS["HTTP_RAW_POST_DATA"];
[code]....
View 1 Replies
Feb 16, 2009
Iam Jennifer, Iam having a doubt in Flash, I hope that you are going to solve my problem, Iam taking 3 Static text fields as Name, Age and Country and besides each and every static text fields i have taken 3 input text fields with different instance names, when i enter my Name, Age and Country details in the input text fields and after entering those details if user clicks the submit button the data should be send to some mail address, is it possible?
View 2 Replies
Feb 16, 2009
I am taking 3 Static text fields as Name, Age and Country and besides each and every static text fields i have taken 3 input text fields with different instance names, when i enter my Name, Age and Country details in the input text fields and after entering those details if user clicks the submit button the data should be send to some mail address, is it possible?[code]...
View 1 Replies
Jul 18, 2010
I am sending a dynamic multi-line textField text to a database. Upon receiving it back, it doesn't display it in multi-line format properly. I am also using htmlText, so it stores it all the font / size /etc in the database perfectly.This code shows you the textField attibutes, both the text I create and send to MYSQL, and the text I get back also calls upon these exact attributes
Code:
TF.type = TextFieldType.INPUT;
TF.autoSize = TextFieldAutoSize.LEFT;
TF.useRichTextClipboard = true;[code]......
when I called upon the text from the database. It at least made it multi-line, but it messed it up a bunch also. My text is only 3 lines, but with wordWrap, it made it 8 and made it look off.Anyway, the text / font / color and everything comes in perfectly, except for the multi-line part.
View 14 Replies
Oct 4, 2010
I was creating a program and now i need to send a bitmap data and ssome text fields information to a php file in my site, how can i do that?
View 2 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
Jan 5, 2012
Currently I have sketched out this small code just to see how it might work. Each text box receives a seperate word one is the game word/the other is a hint. I was hoping to have a new one appear each time I tested the Movie but I cannot seem to get it.
import flash.net.URLLoader;
import flash.events.Event;
var allWords:Array;
[Code]....
View 4 Replies
Jun 7, 2006
I can't get the code to "know" which of the dynamic thumbnails has been clicked (by "know", I mean return an index value, say 0 through 7 if there are 8 projects, that I can use to access that particular project in the array of 8 projects in the rest of the code)... So if the third movieclip thumbnail were clicked, I'd like "2" to come up somehow... I've tried this code, which is kind of lame, I know, based off of the idea of each of the thumbnail movieclips' names ending in their index number:
Code:
//"this" is the button that was pressed; would return a string ending in
//thumberMC_<number of whichever movieclip thumb was clicked>
var: testString:String = this;
[code]....
Lastly, there's a dynamic textfield I'm trying to create that never shows up for some reason. Again, you could see in the FLA (in the "createDrawer" function around line 424).
View 9 Replies
Mar 24, 2010
I need to show the results in my flash program. The results are working great in a trace. I get the text to show, but not the results from high1.lab, high2.lab and high3.lab.
[Code].....
View 3 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
Jan 9, 2008
Basically, I have created a short exercise for an elearning programme that requires the user to drag and drop an object to a number of predetermined places - some of which are correct, some of which are incorrect places. Therefore, on release of the button, the object will either be placed in the correct position, or else return back to its starting place.This is my current code in AS 2.0:
on(press){
startDrag(this,false,0,0,400-this._width/2,450-this._height);
}
[code].....
View 1 Replies
Dec 16, 2005
Im using this xml "data.xml":
HTML Code:
<XML>
<salesreps>[code]...
I want to generate a mc for each rep with 6 text fields containg the 6 values for eash rep.So for this xml there would be 3 mc's with 6 text fields in each. This is one of my first times really diving in to xml parsing in Flash.
View 3 Replies
Dec 15, 2009
I have been looking for a tutorial that shows or explains how to display the contents of a search engine like 'Google' or 'Youtube' inside Flash. No luck so far...
View 1 Replies
