Skip to content

alasql attaching to sqlite #529

@agershun

Description

@agershun

Source: Stackoverflow.com

TANACH_6_1.db exists at the same location as the following HTML. It runs (no errors) but nothing appears at the terminal. Have checked and rechecked syntax and looked at several examples. Tested sql in "SQLEXPERT". alasql is working as I was able to create an in memory database. Please help:

    <!DOCTYPE html>
    <html>
    <head>
    <meta charset="UTF-8">
    <title>AlaSQL - JavaScript SQL database console</title>
    <link rel="stylesheet" href="style.css" type="text/css">
    <script src="js/xlsx.core.min.js"></script>
    <script src='js/alasql.min.js'></script>
    <script src='js/sql.js'></script>
    </head>
    <body>
    <script>
    alasql('ATTACH SQLITE DATABASE tanach("TANACH_6_1.sqlite");
    USE tanach;
    SELECT verse from bookChapterVerse where bookChapterVerseID = 614',[],function(res){console.log("result:",res.pop());});
    </script> 
</body>
</html>

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions