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>