BBJSP JSON:Query Tag (Deprecated)

The BBJSP system is deprecated. For new development, use BBxServlet.

Description

In BBj 17.0 and higher, the query tag can be used within a BBJSP Page execute a query and generate a JSON object.

Attributes

Attribute Name

Description

Required

Expression

Data Type

datasource

the datasource attribute specifies the name of the database to use.

true

true

String

order

the order attribute specifies the order-by field.

false

true

int

page

the page attribute specifies which page of data to retrieve.

false

true

int

rows

the rows attribute specifies how many items are in each page of data.

false

true

int

sort

the sort attribute specifies the sort-order field.

false

true

int

sql

the sql attribute specifies the SQL query to be executed.

true

true

String

Remarks

The JSON Tag Library needs to be referenced in the BBJSP Page

Example

<%@ 
taglib uri='/WEB-CFG/tld/json.tld' prefix='j' %>
<j:query datasource='TestDB' sql='select * from USERS'/>

See Also

BBJSP

JSON Tag Library

<JSON.Param>