ActionScript 2.0 :: "Forms And Database Integration"?
Nov 10, 2010
This tutorial will guide you through the steps of sending information into a Microsoft Access Database using a Flash form and ASP as a server side script.[URL]..but when i upload files and open site and click "submit" show me this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/processForm.asp, line 15
integrate flash forms with any database,without using ASP or any other scary programming.All I want is to insert & retrieve data from a database directly from my flash movie.
simple way to integrate flash forms with any database,without using ASP or any other scary programming.All I want is to insert & retrieve data from a database directly from my flash movie.
My company has a database-driven system of web forms, each ofwhich consists of many questions in various layouts (2-columnradio, 1 column checkbox, etc). The forms are never hard-coded.Each HTTP request causes Java code to perform DB queries todynamically generate the various questions and answers.Thosequestions are then rendered through JSP and Struts tiles into HTML.The HTML also contains JavaScript functions to hide/showconditional questions on the web page based on answers to earlierquestions. Now we're trying to figure out the best way to adapt thissystem to use a Flash front-end instead of HTML/JavaScript.My preliminary research suggests at least two possibleapproaches:
1. A pre-compiled SWF could send a request with certainparameters, and the server could respond with an XML description ofthe form to build. Then the SWF could parse that XML andynamically generate the form using attachMovie for each formelement (with a lot of math to determine relative positions ofelements with variable sizes, like text labels). 2. Flex might reduce the code for placing elements, by usingMXML to describe the form structure as well as visual arrangement.I haven't used this yet, and I'm wary of Flex 2 simply because itrequires Flash Player 9 which is only at 50% browser penetration
I would like to basically create an flash application that would allow a visitor to answer a few questions and then be presented with an image based on the answers provided via a form. If the generated output is not acceptable - I would like the visitor to be able to regenerate the output with a single click and continue to do so until the image is acceptable. The questions/process would be something like:
1. What is your favorite shape? (a drop down list of data from DB would be selectable)
2. what is your favorite color? (same as above option)
3. what is your favorite things to do? (this answer would work similar to a search and match keywords related to images within the DB and be placed in a designated area of the image)
4. what is your name? (first - last)
the results would then generate a image... Does anyone know where I can begin the process of making a application like this?
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?
I would like to build a dynamic webdatabase.(One form that updates text and bit-maps.)I must use Microsoft ACCESS or mySQL.Is it possible and is there any video tutorials out there?I heard a lot of "tissling and tassling" that flash is not well suited to work with databases.
I 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?
where you can load an image from a SQL database ? I would like to show this image in Flash, but i don't know how to load in from a SQL database using ASP.
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.
I 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?
im trying to figure out if there is a way to use flash as a front end for a database. i need flash to be able to search the database for part numbers and match the part number with an excel file and be able to open the excel file from flash.
Is there a tutorial somewhere that tells/shows how to display an image from a db. I have my image paths in a mysql db and I am using php to display my other text fields. I just haven't been able to get my images to show. Below is the code that I am using so far. Here is my actual goal, I am trying to have a flash document the has a list in the datagrid that is connected to a mysql db. I have successfully done this. When a user clicks on a product in the datagrid it populates the details below the grid and I have done so successfully. What I now need is to show a picture of the product in the details section. I would also like to see how to show different images for different vendors, each vendor has its own image size, so if I put just one image placeholder then some of the images will be scewed. I need something that shows image in placeholder 1 if company=1, show image in placeholder 2 if company=2, etc.
It will not load the image from the database using ASP. I set Images as a variable from ASP. It was displaying "images/img1.jpg" instead of image visually.
I'm working on Flash project for which I have to conenct to Oracle database, retrieve data and display it.Is it possible to connect to Oracle database from Flash?
how to store the data in to a database using flash form(actually i created the frontend ie all input text feelds, but iam unable to save the data into the same system. i dont need to send the data through the net to any server or idont need to email it.
I have a Flex web app that communicates with a Java back-end via BlazeDS. The Flex client is composed of a flex-client module, which holds the views and presentation models and a separate flex-service module which holds the models (value objects) and service objects.
I am in the process of writing asynchronous integration tests for the flex-service module's RemoteObjects using FlexUnit4. In some of the tests, I modify the test data and query it back to see if everything works (a technique shown here: [url]...
How do I go about resetting the database to a known state before each FlexUnit4 test method (or test method chain)? In my Java server integration tests, I did this via a combination of DBUnit and Spring Test's transactions -- which rollback after each test method. But these Flexunit integration span multiple requests and thus multiple transactions.
I have a standalone flash app that needs to get user inputand send it to a remote server / database. When I use the methodbelow, a browser window opens which I don't want to happen - I wantthe data to be sent but not display the page.
This works fine when I test the movie from Flash (on my local machine) and if I type the query string directly into my browser, I get the correctly formatted information. The problem arises when I post the swf to my server and test. From my server, I get nothing The swf files and the data are on different servers. Is this the problem? What is a good quick solution.
I want to create a slideshow banner that will showcase our products. The slideshow will contain the image of the product, the name, the price, the item code and the link when someone clicks on it. Each week we update the best sellers and it can be from 5 to 15 different products. Similar to what we have now in our website www.deiequipment.com which now is static, we want to animate it and rotate the products like a slideshow.The problem we are encountering is that we have to manually update the slideshow content.
We would like to know if there is a way through scripting or catalyst to connect to a database and simply update all these fields automatically. So for example if the database has 5 items, automatically will pre-fill each field listed above and the slideshow will have 5 products.
If we update the database now with 10 products, to update automatically. That way we can create 1 slide show, the time it takes to rotate to the next product, and add simple button controls to the slide show for next and back that will simply go through the loaded items.I tried to do a research on how to do it online but some takes me to scripting, others to catalyst dabases, but none are specific to what I need.As a note, the image will just be an image holder that will be updated with the image field in the database that points to the URL location of the image.
i want to intertwine php, MySql and flash. so i can make a flash movie display text that is in the sql database and a php script to change the database, php > sql = i can do but sql > flash = i can't do..i want it so the sql data show's in a text box in the flash movie...
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
I have researched this issue all over and most people say use the .refresh() method to update a datagrid after updating or adding a new record. This does not do anything. So, my issue is this. I have a mySQL database hosted I am connecting via PHP, I have 1 mxml file and 2 php files (I know I can use just 1 but I am learning and this was easier for me to use for troubleshooting). The issue is no matter what I change on the datagrid the update does not show on the datagrid unless I close out of IE and reopen it. I can refresh or open the page in another window and the update does not show. I have to exit entirely and restart in order for any updates or additions to show.Here is my licenseTracker.mxml