Actionscript 3 :: Insert A Variable Into SQLite Database?

Feb 2, 2012

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".

View 1 Replies


Similar Posts:


Database :: Sqlite And Flex - Insert Into If Not Exists?

Feb 4, 2010

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.

View 2 Replies

Flex :: Get Local SQLite Database In Sync With Live Server Database?

Dec 17, 2009

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.

View 2 Replies

Flex :: Query - Sqlite - Insert Into Or Ignore

Feb 5, 2010

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 just fine, but I would also like to add a few rows of data into a couple of the tables so the information is present 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. here's what I'm trying, but it doesn't seem to be working.

[Code]...

View 2 Replies

Actionscript :: SQLite Insert Statements In A Transaction?

Aug 16, 2011

I'm trying to get my head around how to do a SQLite bulk insert using transactions in Flex / Actionscript 3 (using Adobe Air 2). This works, but it doesn't make sense to re-create a new SQLStatement in the loop:

private function onAddBulkContacts():void {
_responder = new Responder(resultEventHandler, errorEventHandler);
contacts_db.connection.begin(null, _responder);
var statement:SQLStatement;

[Code]...

But the latter code throw an error saying that it can't execute the second time through, since the statement itself is still executing (and I believe will be in that state until the commit). I guess I can understand that the statements get added to the execution queue, but it doesn't make sense that I have to add the SQL text within the loop, exactly the thing I'm trying to avoid. I'm sure there's a better way to do this, but I've spent way too long hacking and reading trying to figure out what the proper sequence is.

View 1 Replies

ActionScript 3.0 :: Use A Sqlite Database?

Nov 9, 2010

I am wanting to try to use a sqlite database in my project.I have downloaded several sqlite managers from the internet and they all save the database with a sqlite extension.However I see in flash we use the db extension (is this correct?);How can I use the databases I create if they all save with a sqlite extension?

View 4 Replies

Flex :: Web App Access A Sqlite Database?

Nov 16, 2010

I'm making an application (web based) using flex and i have a requirment to access the SQLite database on the local system. There is no server running and i've decided to give them the link to the html file and see how that works out.

So in the root directory, there will be all required swf, html files, etc and a .db file. Can i access that database thro the flex web application ?

View 2 Replies

Flex :: Querying SQLite Database With AIR App

Dec 13, 2010

I have been struggling with trying to interface with SQLite and Adobe AIR. I am using the Flex 4 SDK with AIR 2.0. I modified code from a tutorial by David Tucker on InsideRIA ([URL]). I am writing in FlashDevelop (which I suppose could be my problem), and I can compile and run the app. The issue is that when I go to search the db file, I always get some error which results in the 'BREAKER' trace (ie - the 'queryError' function is called). I have tried simply running the SQL command on the db and it works fine, so there is an issue somewhere in the way Flex or AIR is handling my query (or obviously I could have made a mistake in coding).

[Code]....

View 1 Replies

ActionScript 3.0 :: Connecting To A SQLite Database?

Aug 30, 2010

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?

View 0 Replies

Flex 4 :: Create An Encrypted SQLite Database

Aug 26, 2010

How can I create and use an encrypted SQLite database for an AIR application, please?

View 1 Replies

Local Internal Database In Flash And SQLite

Jan 12, 2011

I need to store a large amount of data that will be internally accessed often within a flash file. The database is temporary and does not need to be stored in an external file. Is it possible to use SQLite to create a database that may be used internally in flash? As far as access speeds are concerned, is this an efficient solution?

View 1 Replies

Flex :: Improve The Performance Of The SQLite Database?

Apr 26, 2011

Background: I am using SQLite database in my flex application. Size of the database is 4 MB and have 5 tables which are

table 1 have 2500 records
table 2 have 8700 records
table 3 have 3000 records
table 4 have 5000 records
table 5 have 2000 records.

Problem: Whenever I run a select query on any table, it takes around (approx 50 seconds) to fetch data from database tables. This has made the application quite slow and unresponsive while it fetches the data from the table.

How can i improve the performance of the SQLite database so that the time taken to fetch the data from the tables is reduced?

View 3 Replies

Database :: Embed A SQLite DB (*.db File) To The AIR Application?

Jan 14, 2012

I want to emded SQLite database (*.db file) to the AIR app, like images, mp3 etc.This is to ensure that it was impossible to copy my database for other users.

View 2 Replies

Flex :: Getting Next Record In SQLite Database For Mobile Application?

Feb 27, 2011

I have a mobile application that uses an sqlite database. I cannot seem to figure out how to access the next record when the user presses the 'next' button. My database is using 'id' as primary key with autoincrement as integer.

private function nextMoveRPart(event:EffectEvent):void
{
var cardNumber:int = parseInt(cardNumberLabel.text);

[Code].....

View 1 Replies

Flash :: Mysql Application With Local Database (not Sqlite - Not Air)

Jan 10, 2012

I would like to have a Flash Application (not air) to connect to a local database. Air is not only getting unsupported by Adobe in LINUX but besides, it has serious problems and miss implementation with SQLite. So we want to connect to a local MySQL database. This application should be simple, so we do not want to also have an unnecessary web server (also local) to make a middle communication between the flash app and the MySQL server. There is this driver that allow to communicate Flash with MySQL [URL] Question is: Would it be any problem using this approach when installing the whole application to each client? (because we also in the installation should install a MySQL server).

View 1 Replies

Actionscript 3 :: Prevent Air For Android SQLite Database From Being Overwritten?

Feb 14, 2012

Im creating an sqlite db in my air for android app inside the following function:[code]i can successfully create tables, insert and select, but each time i re-publish the app from flash cs5.5 the database is overwritten and all data is lost. Totally stumped, any ideas welcome!i'm publishing a debug release directly from flash pro via usb. When the app is initialised it calls the method above, on receiving the OPEN event it creates a table using the following SQL statement.[code]I can then run some operations, insert, select etc and everything is as expected. If i exit and re-luanch the app, the previous data sets are intact, but when i re-publish from flash any data stored from the previous release has disappeared.According to the documentation SQLConnection.open() will open a connection to the file supplied in the parameters and if it doesn't exist, it will create one...

View 2 Replies

Actionscript 3 :: Open A Remote Sqlite Database Over Http?

Apr 2, 2012

Is it possible to open an sqlite file over http? I only need to read the db, and was hoping I could do something like:

var dbFile:File = new File("http://10.1.1.50/project/db.sqlite");
sqlConnection.open(dbFile);

Error #3125: Unable to open the database file.', details:'Connection closed.', operation:'open', detailID:'1001'

My situation calls for several apps compiled for various devices to share this file, which is served locally via wamp.

View 1 Replies

Flex SQLite Optimization: Adding Database Name In Front Of Tables?

Sep 18, 2011

This article on Livedocs says you should add the database name in front of tables.[URL]..My question is, should I do that everywhere where a table name appears or only once?In this query: select T1.col,T2.col from T1 left join T2 on T1.id=T2.id order by T2.order;

Should I add main.T1 and main.T2 everywhere or just after for, the first time: select T1.col,T2.col from main.T1 left join main.T2 on T1.id=T2.id order by T2.order;

View 1 Replies

Flash :: #3115 Error When Retrieving Data From SQLite Database

Oct 4, 2011

I have this little piece of code to retrieve data from a local SQLite database (to an AIR app):

import flash.filesystem.File;
import flash.data.SQLConnection;
import flash.data.SQLStatement;

[Code]....

It is only a "proof of concept" piece of code and it "lives" in the first frame of the timeline of the Flash IDE. What happens? When I compile my SWF (AIR for iPhone), I get this error:

SQLError: 'Error #3115: SQL Error.', details:'no such table: 'background'', operation:'execute', detailID:'2013'

I created a basic db with a Firefox extension (SQLiteManager). What can cause this error? The table exists!

View 1 Replies

ActionScript 3.0 :: Save The Path Of The Chosen File In Sqlite Database?

Jun 24, 2010

I m trying a make a database on sqlite using actionscript3 and flex.I can browse through file and select a file using browseForOpen().I can get the url by Filename.url and storing it into a string type variable fileUrl:String.I m creating table like:

CREATE TABLE IF NOT EXISTS test_table (id INTEGER PRIMARY KEY AUTOINCREMENT,user_name TEXT,password TEXT ,fileurl TEXT)

i made a text input form for entering user_name and password like:

<mx:TextInput x="50" y="10" width="117" id="user_name"/>
<mx:TextInput x="50" y="10" width="117" id="password"/>

Now i want to insert values into the table like:

sqls.text = "INSERT INTO testt_table (user_name, password,fileurl) VALUES('"+user_name.text+"','"+password.text+"',fi leUrl);";

but its giving errors.How can I enter the url or path of the file chosen into the table.

View 0 Replies

Actionscript 3.0 :: Insert Data To Database?

Sep 28, 2008

var variable:URLVariables = new URLVariables();
var myRequest:URLRequest = new URLRequest();
myRequest.data = variable;

[code]....

View 9 Replies

Flash :: Use It To Insert Data Into A MS Access Database?

Mar 1, 2007

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]...

View 2 Replies

ActionScript 3.0 :: Insert Data Into Database From Flash?

Mar 16, 2009

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]........

View 2 Replies

ActionScript 3.0 :: Insert Data From Flash Into Mysql Database?

Dec 21, 2009

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 Replies

Sql :: Counter Variable In SQLite

Jan 5, 2010

I'm working on a simple todo app that has a column for each day of the week. On startup, the app checks to see if there are any incomplete tasks from before the current date. If so, they're moved to the top of the current date's column. The app is cloud-based, but the tasks are backed up for offline mode with an SQLite db. I can easily move the tasks by updating their date property, but I need the order property of each task to increment starting at 0 to place them at the top. I need to be able to define a count variable in SQLite alone and increment it with each update that's performed. I know this code doesn't work, but it's an easy way of explaining what needs to be done:

[Code]....

View 4 Replies

Php :: Insert To MySQL Database Not Working Online (via Flash Application)?

Apr 16, 2012

So, 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]...

View 1 Replies

Mysql :: Create An Insert Form With TextInput Containing ComboBox Provided By MySQL Database Table?

Jan 13, 2010

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 Replies

ActionScript 3.0 :: Insert A Variable Into A Variable Name

Mar 30, 2009

I'm looking for a way to insert a variable into a variable name. I have this bit of as3 code: I'd like to replace #### with a variable myNumber but don't know the syntax.

[Code]...

View 3 Replies

Flex :: Pass An Edited Flex Datagrid To A CFC To Insert To A Database?

Nov 3, 2009

I have a datagrid which is editable and I need to send that back to the database via a CFC for insertion into the database after all the editing is complete. Dumping the array collection to cfdump tells me that I have an array with items and a structure but i cannot understand how to "loop" through each and insert into the DB.There seems to be very little written which actually works! My MXML and CFC are below but give me the error of "You have attempted to dereference a scalar variable of type class coldfusion.runtime.Array as a structure with members." -which is nice

[Bindable]
private var getconsent:ArrayCollection = new ArrayCollection([
{LocationName:'Service A', Contact: 'Bob Jones' },

[code].....

View 3 Replies

ActionScript 3.0 :: Insert Variable Value Into A Path?

Nov 4, 2009

The bold below is what I would like to work, however it does not.  It might not be able to happen like this at all.

basically on mouse down I take the event.target.name and perform a string manipulation to get the number out of the target and add some string to front and end to get the name of the movieclip I would like to effect.  Is it possible to insert the value of dotName into the path?
 
eventName = event.target.name;
stringManip1 = eventName.substring(13, eventName.indexOf("_")); //get the Number before the _
dotName = "dot" + stringManip1 +"_mc"

[Code].....

View 3 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved