Versions Compared

Old Version 1

changes.mady.by.user Megan Bond

Saved on

compared with

New Version 2

changes.mady.by.user Megan Bond

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width70%

API Overview

The pjs.query() API is a shortcut for executing an SQL statement and automatically fetching the results. The results are returned by default as a primitive JavaScript array or object. However, if the 4th parameter is specified, the results are instead returned into a set of strongly defined fields, a strongly defined array, or a strongly defined data structure.

This API first prepares the SQL statement, binds parameters (if any), executes the statement, and then fetches the records.

Note
If the SQL statement is an INSERT or an UPDATE, parameter 3 and parameter 4 are not applicable.

This API also has the capability to INSERT or UPDATE records using a primitive JavaScript object that represent fields and their corresponding values.

Note
If the SQL statement is an INSERT or an UPDATE, parameter 3 and parameter 4 are not applicable.
Column
width30%

Contents

Info
iconfalse
Table of Contents
indent5px
classh3
separatorbraces
Warning
titleImportant!

This API requires the Profound.js Connector module.

Some of the Examples listed below are not available in all versions of Profound.js.

...