Select count sqllite ionic

Ionic Framework ionic-v3
1

i want to ask why if i alert my result it becomes undefined? this is the code

result:any;

countdb(){
    this.sqlite.create({
      name: 'logindata.db',
      location: 'default'
    }).then((db: SQLiteObject) => {
      db.executeSql('SELECT COUNT(mobilephonid) AS result FROM login',{})
      .then(res => {
this.result = res.rows.item(0).result
alert(this.result)})
      .catch(e => console.log(e));
    });
  }
2

Did you solve the issue? because i have the same :smiley:

3

db.executeSql(‘SELECT COUNT(mobilephonid) AS result FROM login’,{})

Your error is in the above line.

db.executeSql(‘SELECT COUNT(mobilephonid) AS result FROM login’,) use this line