...
| Code Block |
|---|
| language | javascript |
|---|
| title | Add a record using a primitive JavaScript object |
|---|
|
var record = {
id: counter,
firstname: fname,
lastname: lname
}
pjs.query("INSERT INTO table SET ?", record); |
The following example is available with Profound.js version 4.0.0 and later.
Update a Record
| Code Block |
|---|
| language | javascript |
|---|
| title | Update a record using a primitive JavaScript object |
|---|
|
var fieldsToUpdate = {};
fieldsToUpdate.firstname = fname;
fieldsToUpdate.lastname = lname;
pjs.query("UPDATE table SET ? WHERE id = ?", [ fieldsToUpdate, currentId ]); |
...