Data Integration :: Connecting To Oracle Database?
Jun 8, 2011I'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?
View 2 RepliesI'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?
View 2 RepliesI'm using the XML Connector to bind information to a List Component. Everything binds okay but when I run the MC I only get one item of information. The object I'm binding from the XML is called "Location" and there are a total of 5 listed in the XML. The five are Los Angeles, Seattle... The only one being displayed is Los Angeles. What do I need to do get the other 4 locations to display in the list?
View 1 RepliesI'm still learning AS3 and am trying to set up validating user (text box) input of 2 items (name and password) by checking with an SQL Server Database on my website.I have the ASP page set up using a standard request/response.write script. It works I've tested the ASP, and it works. The ASP receives the 2 variables, hopefully each in a name-value pair, and checks with the DB, then if the name and password received from the Flash SWF match a name and password in the DB, sends back a "YES" and, if not, sends back a "NO".I'm having difficulty getting the AS3 written and working correctly. Here's what I have so far that displays errors, causes a flickering when previewed and doesn't yet work.
stop()nextBtn.addEventListener(MouseEvent.CLICK, nextBtnClick, false, 0, true);function nextBtnClick(e:MouseEvent):void {var input1:String = T1.text;var input2:String = T2.text;var variables:URLVariables = new
[code].....
I have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event.
The page is for a booking/promotion concert company. They want a "Featured Shows", "Calendar", and flash file that all are interconnected. One page. Does anyone know how to do this, where to find tutorials, or so on? Note, i'm not wanting to WRITE data to the database, I just want to GET data to post on the flash file.
All the web services tutorials I have reviewed always demonstrate how to setup the WebServicesConnector and bound to other input components on the stage (like the textinput component). I want to bind from a variable value in my Flash movie (ie; _level0.set_zone ) to somewheres in my WebServicesConnector. How can I set this up within my binding bound to value field?
View 4 RepliesIs there an easy way to connect to MS Sql 2005 using Flash 9?
View 1 RepliesCase1: When a client makes a remoteObject request ie to save some Info... A call is made to Java SAVE_INFO method. If request failed ie came back to FaultHandler ( we save the info in an arrayCollection).Later we call SAVE_INFO again for each item in arrayCollection ie( if arrayCollection has 10 items.. We call 10 times the same method.. I know that's kind of stupid but we have no control over java to write a overloading method). Some times we see there are multiple records of same info in DB. I am not sure if this happens when looping over arraycollection and making calls or during normal one time call. We could not find a pattern to reproduce. Java LOG level is at Error level in production. can't set to INFO in production to monitor all calls. We dont know if this multiple times saved record is, the one in arrayCollection or normal one.
Flex3 RemoteObject --> WAS 6.1 , lCDS 3.0, Java1.5 --> Webservice -- > Java (hibernate) --> Oracle 10gCase2: When application is left open and user leaves for the day and submits info the following morning, we see duplicate records in DB of that info.(No arrayCollection here. Simple straight one call)Flex3 RemoteObject --> OC4J Blazeds Java1.5 (JDBC) --> Oracle 10g.Recently one of our Testers testing case 2 application found this pattern and I am starting to think that may be in the case 1 also.. users might be leaving for lunch/break and resubmitted the arrayCollection after coming back. During lunch java might have killed the sessions for the client and after resubmitting 10 at same time.
Can anyone help me with getting a message that is said in flash (like a game) go to a mysql database?
View 2 RepliesIm new to data input using flash,how to connect to a mysql database.
View 5 RepliesI'm wondering if the following can be done with Flash -
- can a swf contain it's own database that the user can add, delete, read?
- while the view is online, entering and interacting with the data- is it being sent back and forth to the server?
- can this database be protected with some sort of encryption that is only unlocked by the user's code?
- and so that if the user emailed the swf or the db file from within the swf, only a person with the key could access the data?
I 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 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 RepliesI 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.
View 2 RepliesI 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?
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.
View 3 RepliesIs 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.
View 1 Replies[Code]...
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.
1. I wish to build a questionnaire with 14 questions where the user can answer Yes or No each question.
2. Then I would like to save these answers in a mySQL
[Code]...
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.
View 4 RepliesSharedObject not support for iPhone? iphone support any database for iphone application ?
View 6 RepliesI 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.
my_lv.fname = fname;
my_lv.lname = lname;
my_lv.emailaddr = emailaddr;
[code].....
I have a project that sends queries to a database and receives XML formatted data:
Markets_xml = new XML();
Markets_xml.onLoad = readMarketsXML;
Markets_xml.load("
http://208.62.199.74/ws_ckp_data/Service.asmx/GetMarkets?MarketName=Al l&MarketTypes=Industrial");
Markets_xml.ignoreWhite = true;
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 am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
View 1 Replies[code]...
I got the script to work perfectly, even got to register a few hundred members to the site. However, my old host had a bandwidth limit of 400gb so I had to move to a new provider. I transferred all the files with no problems, and even setup the database properly. My new problem is registering... I can login just fine using an existing account I had made. But I go to try and make a new account and I get an "undefined" error.[code]...
I'm developing a desktop application in Flash, but I can't seem to find any tutorials that aren't based on FLEX to connect my application to a database file.
Do I have to write my application in FLEX to use SQLite or can I create an AIR app in Flash and still use it?