Pow db:exec

From PlainOldWebserver

Pow_db.exec(sql)

Executes an SQL statement.

  <?sjs
        try {
                var pdb = new pow_DB("object_db");
         pdb.exec("CREATE TABLE foo ('object_id' int, 'name' varchar(10),
                'name2' varchar(12))");
        } catch  (e) {
         // noop
        }
        pdb.exec("INSERT INTO foo (object_id, name, name2) VALUES (1, 'gus', 'bob')");
        var results = pdb.exec("SELECT * FROM foo WHERE 1=1");
        var res = pdb.pretty_print(results);
        document.write(res);
        document.writeln(results["column_names"].join(" ")+"<br>");
        for (var i=0;i<results.length;i++) {
         document.writeln(results[i].join(" ")+"<br>");
        }
  ?>

See Also

• Pow_db()
• Pow_db.exec()
• Pow_db.drop_database()
• Pow_db.pretty_print()