Page Comparison

...

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

Add multiple records with one INSERT statement (available in Profound.js version 5.0.0)

Code Block

title	Add multiple records using an array of primitive JavaScript objects

var record1     = {flda: "AAA", fldb: "BBB"};
var record2     = {flda: "XXX", fldb: "YYY"};
var recordArray = [record1, record2]        ;
pjs.query("INSERT INTO TN6193P01 SET ?", recordArray);

Add a Record

Code Block

title	Load various types of data values into a table with four columns

var version = "12345";

var record = {};
record.OneField = version;                         // variable
record.TwoField = data[1].__SOMEFIELD;             // object property
record.RedField = "Suspended";                     // literal
record.BlueField = cvtDate (data[1].DUEDATE);     // function call

pjs.query ("INSERT INTO table SET ?", record)

...

Versions Compared

Old Version 20

New Version 21

Key

Add multiple records with one INSERT statement (available in Profound.js version 5.0.0)

Add a Record