pQuery.setBoolean

Signature: pQuery.setBoolean(parameterName, value)

Returns: ParameterizedQuery pQuery - this ParameterizedQuery object. To see what methods can be used on a ParameterizedQuery, refer to the 'Parameterized Query' functions.

Sets the parameterName to the given Java Boolean value.

Note

The JDBC driver converts this to an SQL BIT or BOOLEAN value when it sends it to the database.

Note

The parameterName may include the parameter prefix character (colon ':' or at sign '@') but is not required. For example: ':fieldValue' and 'fieldValue' will reference the same named parameter.

Parameters

Type	Name	Description	Default
String	parameterName	the name of the parameter
String or Boolean	value	the value to use for parameterName

Example

// Examples of how to correctly use the setBoolean parameter option.
// Create the pQuery object with the SQL to be called
var pQuery = qie.getParameterizedQuery(
   `update patient set name = :name, is_active = :isActive, photo = :picture where patient_id = 1`
);

var avatarStream = new java.io.ByteArrayInputStream(qie.base64DecodeToBytes("aGVsbG8="));

pQuery.setString("name", "Jonathan");
// Example: value as Boolean
pQuery.setBoolean("isActive", true);
pQuery.setBinaryStream("picture", avatarStream);

// Execute the query
var queryResult = pQuery.doQuery("EMR Database");

pQuery = qie.getParameterizedQuery(
   `update patient set name = :name, is_active = :isActive, photo = :picture where patient_id = 1`
);

var avatarStreamForStringValue = new java.io.ByteArrayInputStream(qie.base64DecodeToBytes("aGVsbG8="));

pQuery.setString("name", "Evelyn");
// Example: value as String
pQuery.setBoolean("isActive", "false");
pQuery.setBinaryStream("picture", avatarStreamForStringValue);

queryResult = pQuery.doQuery("EMR Database");


// Example: parameterName with prefix and value as String
pQuery = qie.getParameterizedQuery(
   `update patient set name = :name, is_active = :isActive, photo = :picture where patient_id = 1`
);

var avatarStreamForPrefixedName = new java.io.ByteArrayInputStream(qie.base64DecodeToBytes("aGVsbG8="));

pQuery.setString(":name", "Harold");
pQuery.setBoolean(":isActive", "true");
pQuery.setBinaryStream(":picture", avatarStreamForPrefixedName);

queryResult = pQuery.doQuery("EMR Database");