1) Can Adobe Air Database create more than 1 table in the DB?will it work by just executing two create table statement work?[code]
2) How can i do SQL indexing for a table in a database?[code]Will this work for indexing?
3) If all the above work, how to i check if the database is implementing the above?
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
View 1 RepliesCan I build flash application that connects to database? (MySQL) For example: Photo Gallery that brings me the photos from database...
View 3 RepliesHere is the issue: a client wants his entire equipment inventory accessible by persons navigating to his jquery mobile site. The inventory that exists on the desktop site was, as I understood, built with Flex. Is it possible to access this database for the jquery mobile site? I believe it is. I was then given this information from someone in the know:
Database:
mlxx.db.xxxxxxx.hostedresource.com
login: mxxx
[code]...
I've set up a small project as a test. I'm using BlazeDS and JPA with Hibernate on my test server, and flex with with dpHibernate to access the Java entities. Each Java entity extends BaseEntity, a class that contains ID and UUID fields. The Flex entities are created by DTO2FX.
when I run the Flex project to try and display a few rows from a Users entity, the SQL that is actually being executed is joining every table in my database. This continues until I get java.lang.StackOverflowError. This behavior is completely unexpected, and I'm not really sure where to look to fix the problem.
@Entity
@FXClass(ignoreSuperclasses={Principal.class, UserDetails.class})
@Table(name="edrUser")
[Code].....
How do I get a Boolean value in AS3 whether a table or an entry exists in the database?
View 2 RepliesI am basically having a problem in submiting the users score and name to the database table. When the user reaches the final score screen they are shown two dynamic text boxes that display there total result and a input text box where the user can enter their name. I have done everything and it still don't work. I know I can receive the data but I don't get why it doesn't submit it to my table.
The input text box has a instance name of "playername"
Score total dynamic text box 1 "correct_total"
Score total dynamic text box 2 "wrong_total"
I have also attached an image of my database table [URL].
PHP files. insertValues.php
<?php
$host = "localhost";
$user = "root";
$pass = "";
$database = "activitysystem";
[Code] .....
I've got remote databases on hosting. Can Flash Builder generate Spark Form with similar structure from database table?
View 2 RepliesIs there any fast table components available for mobile devices (Anroids ,iOS) in Air?
View 1 RepliesIs it possible to create a database driven website using these alone? Or do i need to learn any other technology? If i do then what should i learn? I know j2se for the desktop and oracle SQL/MySQL i finally got the feeling that i need to learn PHP anyway along with css and javascript. So it is fine. Also another query. Which CMS should i consider? Wordpress or Joomla?
View 1 RepliesAm in a need to create a table (looks like a grid) in flash using action script.
View 5 RepliesAm in a need to create a table (looks like a grid) in flash using action script.
View 2 RepliesIs it possible to install a SQLite database that is readable and writable by all users on a computer (windows or mac)?As far as I've seen in the API docs the only folders I can read/write access to are local to the specific user of the computer.
View 1 RepliesWhenever I try to create more than one table in actionscript, only the first one gets run.I've been using a string for my query or embedding an external file with the SQL code, and every time AS seems to ignore everything after the first.Perhaps this is a feature of Actionscript and how it deals with databases and adding each table is a separate query, but is there a way to get around this? I like the idea of having my whole db CREATE statement set in one contained place.
View 1 RepliesI have sqlite table named categories with fields id, name, and parent_id. Sample data is much like:
id name parent_id
1 products 0
2 tools 0
[code].....
I have a dynamic text field which is rendering html and pulling in CDATA text from from an external xml file.I would like to create a simple table within the CDATA field... like this:
Code:
<![CDATA[
<table>
<tr>[code].........
I tried this, but it didn't work... I looked in to this and read that I could not use the <table> tag within a CDATA tag.Is there any way around this? Or is there a an alternative way to achieve what I am attempting to do?
I want to create 2 tables in a single adobe air database. I am using Adobe flash builder with the import flash.data.*;
I tried initializing the statement below. it give me the error on creating the second table. Do I have to use other API so that
private function db_opened(e:SQLEvent):void {
sqls.sqlConnection = sqlc;
sqls.text = "CREATE TABLE IF NOT EXISTS test_table ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT);";
sqls.execute();
[Code] .....
ERROR
Error: Error #3106: Property cannot be changed while SQLStatement.executing is true.
at Error$/throwError()
at flash.data::SQLStatement/set text()
I am trying to connect to database from the Adobe FLex AIR application.
Is it possible to connect to database(SQL Server / ORACLE) from Action script.
I 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
I want to create a table like structure in Flex, with labels as header. The rows entries might be a check box or a text input box,Like give below.[code]Or can I create a data grid and have text input boxes or check boxes as column values?
View 1 RepliesI am trying to create a table of thumbnail pictures from an xml. I have made the table load from from the file though when the items are created the other layers (e.g background and text field) only show in the first thumb. I also want to be able to click the thumb and have it go to the corresponding url from "curl[]". I just can't work it out. At the moment it will only go to the last url added in the array! I have a clip on the main stage with instance name thumbnail Here is the code I am using
[Code]...
How to connect to MYSQL DB from Java, create table, insert data, retrieve it with datatypes. How to make use of the data to/from in Flex application. i have basic knowledge in sending and receiving messages using BlazeDS.
View 1 RepliesI am trying to create a high score table offline that doesn't need php just relies on dynamic textboxes.I am basing it on a kind of random football results generator. I have been able to get the random scores and add points to a team depending on the score but now I would like to be able to display them in a 'league' table based on their points score.
View 7 RepliesI have a wordpress based site that stores information about an image in a database field called "background" in a table called "wp_postmeta".The 'loader' gets an url such as "/thisImage/background.swf"The "background.swf" should somehow display "background.jpg" instead but since I've changed the field name in the database (from background to temp_background) it doesn't work.I pass variables to the "loader" swf and they are correct based on the new field name but it still isn't working.I need to know if there is anything in the .fla's (and therefore the .swfs) that is pointing to somewhere in the database hard-coded. Basically I need someone to look at them and tell me how they are working.
View 2 RepliesMultiple axis creation via MXML works fine:
http:[url]...
But when I'm trying dynamically create horizontal and vertical axis then I'm getting extra axes. I believe this is Adobe bug. How I can fix this behavior?
<?xml version="1.0" encoding="utf-8"?>
<s:Application
minHeight="600"[code].....
How to make a table in Flash and enable the column headers on the table to sort column on click?I have seen some tutorials with mySQL but I'd like to start with something basic. Is a sortable table possible using just Flash and AS 2.0?
View 1 RepliesI want to find out how i could possibly create and database in flash. I have been trying to create a signup form and a signin form. I have created the design but am unable to link it to database. I do have the knowledge of php so can i link the flash file with php?
View 1 RepliesId like to know if theres any way, to create a local database, with actionscript, php and mysql.And communicate with the database, like inserting data to the database, and selecting data from the database,I mean,if actionscript is able to communicate with the local database through php and mysql.
View 3 Repliesi am trying to create a database in flash (reading from an access filwe) whih is going well but i want it to return movie mpeg or flash files...
View 2 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 Replies