update query to SQLite database

I'm trying to do an update query from a Zinc textfield component to SQLite database.  The following won't work.  Any idea what I need to adjust?


on(release)
{
var val = _parent.myDB.runQuery("UPDATE preferences SET typenum = \""+thisfield.text+"\" WHERE id = 1;");

}
COwebmasterAsked:
Who is Participating?
 
ch2Connect With a Mentor Commented:
so try like this.

_parent.myDB.runQuery("UPDATE preferences SET typenum = '"+_root.thisfield.text+"' WHERE id = 1;");
0
 
ch2Commented:
Well did never use that class but as i know a bit of sqlite and mysql. Did you open a connection to the database?

I searched a bit and got to this link: http://www.thecodezone.com/downloads/sqlite.html

So try like this

// Connect
var id:Boolean = _parent.myDB.connect("my.db");
// Check connection
if (id) {
      trace("connected");
      var stat:Boolean = _parent.myDB.runQuery("UPDATE preferences SET typenum = \""+thisfield.text+"\" WHERE id = 1;");
      if (stat) {
            // Check if inserted
            trace("Record inserted");
      } else {
            trace("Record not inserted");
      }
} else {
      trace("Record not connected");
}
_parent.myDB.close;
0
 
COwebmasterAuthor Commented:
Thanks but the issue is that it inserts the string "+thisfield.text+" instead of the value inside that textfield which is a number or anything else the end user enters.  Not sure how to handle that on an update query.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
ch2Commented:
Try this.

_parent.myDB.runQuery("UPDATE preferences SET typenum = '"+thisfield.text+"' WHERE id = 1;");
0
 
ch2Commented:
or also try this.

_parent.myDB.runQuery("UPDATE preferences SET typenum = "+chr(34)+thisfield.text+chr(34)+" WHERE id = 1;");
0
 
COwebmasterAuthor Commented:
Ok, let me try those..
0
 
ch2Commented:
If the above dosen't work also try this and post here the trace.

var sql = "UPDATE preferences SET typenum = '"+thisfield.text+"' WHERE id = 1;";
trace (sql)
_parent.myDB.runQuery(sql);
0
 
COwebmasterAuthor Commented:
Ok, I tried the first solution:

_parent.myDB.runQuery("UPDATE preferences SET typenum = '"+thisfield.text+"' WHERE id = 1;");

and it inserted undefined
0
 
COwebmasterAuthor Commented:
Ok, I also tried:

_parent.myDB.runQuery("UPDATE preferences SET typenum = "+chr(34)+thisfield.text+chr(34)+" WHERE id = 1;");

and that didn't update anything.
0
 
COwebmasterAuthor Commented:
The trace on the above is:

UPDATE preferences SET typenum = 'undefined' WHERE id = 1;
0
 
ch2Commented:
ok so that is correct.

This is the right one:

_parent.myDB.runQuery("UPDATE preferences SET typenum = '"+thisfield.text+"' WHERE id = 1;");

but now your problem is the textfield because it's unefined or empty. Where is the textfield located?
0
 
COwebmasterAuthor Commented:
The textfield is located on the _root with the button to update.  Both are flash components.
0
 
COwebmasterAuthor Commented:
YES!!!!!!

_root didn't get referneced.  

Thanks ch2!
0
 
ch2Commented:
nice it worked for you!

Thanks for the points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.