Issues in inserting currentDate into WebSQL from javascript in WebSQL

Question

I'm trying to use the current date and time to do INSERT and SELECT statements, but the data is not getting inserted in WebSQL. Below is my code:

CREATION..
myDb.transaction(function(tr) {
        tr.executeSql('CREATE TABLE IF NOT EXISTS stInfo (keyNum INTEGER NOT NULL PRIMARY KEY, timestamp varchar(255) );');         
});

INSERTION
function insert() {
 var timeStamp = getCurrentDate();  returns in format YYYY-MM-DD HH:MM
myDb.transaction(function(tr) {
          tr.executeSql("INSERT INTO stInfo('keyNum','timestamp') values(215424," + timeStamp + ");");              
 });
}

Try removing the comments around keyNum and timestamp in your insert statement. That's the first thing that doesn't look right. — Will
– Will, Commented May 29, 2012 at 20:10

Tyler Mortensen · Accepted Answer · 2012-08-16 18:07:40Z

2

Old post, but I will answer it anyway. Easiest would be:

tr.executeSql('INSERT INTO stInfo (keyNum, timestamp) VALUES (?,?)',["215424", timestamp]);

Also, watch your double and single quotes.

answered Aug 16, 2012 at 18:07

Tyler Mortensen

4613 gold badges8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul Sweatte · Accepted Answer · 2013-02-11 19:01:27Z

0

Use single quotes to surround the timestamp:

tr.executeSql("INSERT INTO stInfo('keyNum','timestamp') values(215424,'" + timeStamp + "')");

edited Feb 11, 2013 at 19:01

answered Jul 2, 2012 at 23:36

Paul Sweatte

24.7k7 gold badges131 silver badges270 bronze badges

Collectives™ on Stack Overflow

Issues in inserting currentDate into WebSQL from javascript in WebSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related