public function DatabaseConnection_pgsql::queryRange

cis7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
cle7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
elmsmedia7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
icor7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
meedjum_blog7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())
mooc7 database.inc public DatabaseConnection_pgsql::queryRange($query, $from, $count, array $args = array(), array $options = array())

Runs a limited-range query on this database object.

Use this as a substitute for ->query() when a subset of the query is to be returned. User-supplied arguments to the query should be passed in as separate parameters so that they can be properly escaped to avoid SQL injection attacks.

Parameters

$query: A string containing an SQL query.

$args: An array of values to substitute into the query at placeholder markers.

$from: The first result row to return.

$count: The maximum number of result rows to return.

$options: An array of options on the query.

Return value

DatabaseStatementInterface A database query result resource, or NULL if the query was not executed correctly.

Overrides DatabaseConnection::queryRange

File

includes/database/pgsql/database.inc, line 143
Database interface code for PostgreSQL database servers.

Class

DatabaseConnection_pgsql

Code

public function queryRange($query, $from, $count, array $args = array(), array $options = array()) {
  return $this->query($query . ' LIMIT ' . (int) $count . ' OFFSET ' . (int) $from, $args, $options);
}
Error | ELMSLN API

Error

×

Error message

  • Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/elmsln_community/api.elmsln.org/includes/common.inc:2791) in drupal_send_headers() (line 1499 of /var/www/html/elmsln_community/api.elmsln.org/includes/bootstrap.inc).
  • Error: Call to undefined function apc_delete() in DrupalAPCCache->clear() (line 289 of /var/www/html/elmsln_community/api.elmsln.org/sites/all/modules/apc/drupal_apc_cache.inc).
The website encountered an unexpected error. Please try again later.