Experiencing an undefined function error, using SQL queries with Javascript

Question

I am simply trying to have this one button implement a function that simply shows the users scores for the game overall. This data is updated in an Access DB each time the user plays the game. I don't know if this is an issue with my SQL queries or with my JavaScript coding. I simply need a popup window to display this information when the user clicks this button. Code is as follows:(Just a portion of the code that's supposed to display the popup window, nothing more.)

<button onclick="showscores()" style=" top: 155px; left: 160px; position: absolute;"> Show scores

var user = "FOO";

var myDB = new ACCESSdb("C:\\Users\\FOO\\Users.mdb", {showErrors:true});

function showscores(){
    // select and retrieve the user info data , containing the score data 
    window.alert(myDB.query("SELECT * FROM userInfo WHERE UserName = 'username'));
}

Marco · Accepted Answer · 2015-10-25 20:34:21Z

1

You have a syntax error in your query - a missing closing double quote. It should be:

window.alert(myDB.query("SELECT * FROM userInfo WHERE UserName = 'username'"));

answered Oct 25, 2015 at 20:34

Marco

24.1k13 gold badges81 silver badges132 bronze badges

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

Comments

benni_mac_b · Accepted Answer · 2015-10-25 20:38:55Z

0

myDB should be declared within the function unless declared globally, its not clear in your example if that is the case.

function showscores(){
    var myDB = new ACCESSdb("C:\\Users\\FOO\\Users.mdb", {showErrors:true});
    // select and retrieve the user info data , containing the score data 
    window.alert(myDB.query("SELECT * FROM userInfo WHERE UserName = 'username'"));
}

answered Oct 25, 2015 at 20:38

benni_mac_b

8,9075 gold badges43 silver badges60 bronze badges

3 Comments

user5447193 Over a year ago

Yes, I did declare it globally. Sorry for the ambiguity. Now that I fixed the double quote syntax error, I'm getting back a false value from my database.

benni_mac_b Over a year ago

Cool, I suggest opening a new question for that as it may be one of many things, file path, table name, column name etc

user5447193 Over a year ago

Okay , will make a new question then.

Collectives™ on Stack Overflow

Experiencing an undefined function error, using SQL queries with Javascript

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related