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()