First of all I am using Flash MX 2004 and have Office 2003.
I am trying to use my flash form to insert data into a ms access database but it is not going too well.
I have 4 input fields on the flash form and a submit button, ActionScript on the Submit button is as follows.[code]...
I am completely new to Flash and actionscript.I have a small project which requires me to submit details into a MS Access Database. I have created an asp scrip to do the same but it doesnt seem to be working. I am posting the code.
my fla code
********
import flash.events.Event;
[code]........
I have a quiz game that i have finish. in this game have a finish button. if the finish button clicked the score from the quiz want to insert into mysql database.
View 1 Repliesvar variable:URLVariables = new URLVariables();
var myRequest:URLRequest = new URLRequest();
myRequest.data = variable;
[code]....
I am running CS3. I want to access and update a MS SQL database through ASP but I could not find data components to download for CS3. I found Phil Heinz's tutorial[URL] but it is for MX Pro 2004. Should I be using Flex to do this or will the Flash 8 data components work on CS3?
View 2 RepliesSo, here is the question. I have a small flash application that sends some variables to a php script (via POST), and that php script sends them to a mySQL database.
This works fine when I'm testing my flash offline, I go to phpmyadmin, and the registry is done. When I upload the swf to a online html, this stops working. It no longer creates another registry in the database. I have no ideia why this happens.
I read a bit about it and found out about cross domain policy, and thought it might be the problem. Thus I made a small .xml file and uploaded it to both servers (the one the swf is on, and the one that has the database), and its still not working.
[Code]...
Is it possible for Flash or possibly Adobe AIR to have access to a local Access database?
I will have either a Flash EXE or AIR application running on a local PC (WinXP). The PC will also have a local Access database. I need my Flash application to get the data from this Access database. How would I do this?
I doubt it can be done with Flash or AIR alone (someone prove me wrong or right), but is there an option for some middle-man application to access the data base and send it on to Flash? How would this work?
Or could I read the MDB file into Flash and parse it myself? is there a library for this?
I'm using flex to develop my first desktop app and I'm working with sqlite for the first time as well. I'm creating my database and all the tables and I would also like to add a few rows of data into a couple of the tables so that the users have some data to work with on first install.
The only problem I'm having is every time I run the program it keeps inserting the same data over and over again. I'm just wondering if its possible to do a - INSERT INTO IF NOT EXISTS. or some other kind of work around.
I have a function that inserts data into a SQLite database. I can manually add data using
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES ('John', 'Doe')";
This works perfectly. Now I am trying to insert the data from a variable instead. I can trace my variable from this function- trace(Main._firstName); //returns John, but when I insert it using this:
sqlStatement.text = "INSERT INTO users (First_Name, Last_Name) VALUES (" + Main._firstName + ", 'Doe')";
it inserts it as "null Doe".
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 Replieshow tp use databases with Flash CS4 ?I have created a form, an email page and a username/password protected pages, but I cannot find any tutorials that would help me how to connect to a database.
View 7 RepliesI have to access database from flash 3.0, but dont need to communicate with php or any server side languages, I have to directly connect to database,
View 2 Replieswriting a PHP script that will decide to create a new row in mysql or just update an exsisting account and pass the information back to my swf file.. I am sure alot of people would need this when creating a form that updates or creates account information...
View 1 RepliesI'm trying to insert some data into my DB from two Combo Boxes in Flash. I'm not quite sure how to go about it. I have no idea how to give the combo box a 'var' value like we do for a regular textfield. I have other pages where I have regular text fields that work fine as I can specify the 'var' value in the properties but not for combo boxes. I'm new to actionscript so please bear with me.
Action Script for my button:
Code:
on (press) {
loadVariablesNum
("http://localhost/Test/acadForm.asp",0, "post");
[code]....
I have a map as a button in flash and a database in access, how can I show the data in asscess in flash , now i know there is no a direct link from access to flash and I have to use PHP, ASP, etc.... But really I am not a programmer and I don't want to be .. so any easier way to do this?
View 7 Repliesjust like facebook game, I see that even I am playing facebook social game, it still have some downloading when I click on an item for the first time, or just by doing something new. Is that people can divide flash into many parts and connect them when they need?
View 1 RepliesI am fairly new to actionscript 3, and coding in general, and I am trying to build a music application with a user account system, using which each different user can access their own music files.
I have found many tutorials online on how to create music players and playlists, user login systems, but nothing that combines these into one application.
I am working on one CD presentation for chamber of commerce I have to make a search engine in this CD presentation. they have 8,000 company name address email website address and product details in Access data base can i make a search in flash MX or is there any possibility to search from XLS file
View 1 RepliesI want to know can we use access's database to work with flash or adobe air?
and if u have any sample of a database which work with air or flash in local
how to make a connection with my swf and an Access DataBase... or do you know where can I found this information?
View 2 RepliesIs it at all possible for flash to access images from outside flash the way it draws info from a database?
View 1 Replies[URL] I got partial success with the tutorial above, but couldn't figure out a few things.
1) How to save the date and time to the database? Based on web search result on how to find date or time in APS, I thought I could do
[Code]...
but the ASP generated errors on the 2 lines.
2) When executing the file (getURL("http://yourSite.com/processForm.asp",0,"post");
}), it always opens the processForm.asp file in a new window. Can it be executed in the same window or just being hidden?
The tutorial is old, and I wonder if there are new ways to do the things with CS4 or CS5?
how to send data from a flash to a database and how the receive it aswell. Im presuming you pass the data from the flash to a php file to the database when sending and call the data using a php file to the database aswell. What im trying to do is just have a button that will increment a number in a database by 1 and then display that information on a different Frame within the flash later.
Basically what i want to do if have a button pressed to increment a number in a database.
I am reading one tutorial :- But I can't understand what is "Gateway.php" and all such things. I am a beginner in Flash.
View 2 RepliesI have to fetch data from database into the flash..
View 1 RepliesI need to create a database using Flash which gets the data such as "name , last name..." from the user and stores it in a database.
View 1 RepliesI am creating e-learning material that will be accessedonline by students. Is there anyway that Flash can write to adatabase to tell us how long the student was logged in for and how
long there were on a page?
I have made a .swf file that scrolls boxes- these boxes willin the end contain products contained in a ASP database. Here isthe problem, I don't know how to get the Flash movie I have made toSince I don't know flash that well, I have made transparentbuttons to go over the scrolling boxes to open a URL with theaction scripting -----on (release) {getURL("http://www.myurl"); } This works finebut I would like the content in the scrolling boxes to changedepending upon items in an ASP database. In the database, there isan area to specify "featured" items, which are dynamically put onthe site in specified areas where tags(anchors) for the "featured"items are placed. What I think I should do is code the tag(anchor) for the"featured" item into my flash movie but I don't know how to dothis.
View 1 RepliesI am trying to create a 'Password' database with flash to push both to and from an external database, the only problem is that I do not want to have to run IIS or Apache or any other web server. Is there any way to read a non localhost/web based type database within flash? If so can someone point me to a tutorial or
at least in the right direction?
Is it possible for flash to accept value from a database?There is a database storing values "postions" and "descriptions" (there are 2 coloumns named so to store the values).In flash I want to accept the values entered in these 2 coloumns. How to go about it? If I create 2 dynamic text boxes with variable names "p" and "d" respectively and an "accept" button on the scene, what script should I add to the button so that these text boxes accept the values?
so my 2 queries are:
1) how do I send the value from the database to flash?
2) how do I accept the same in flash?