dbQuery

Version 21.0.7964


dbQuery

Version 21.0.7964


Executes a query against the database.

Required Parameters

  • driver: The JDBC driver class name in the Java version or the ADO.NET provider name in the .NET version.
  • conn: The connection string or database URL.
  • query: The SQL query string.

Optional Parameters

  • commandtimeout: CommandTimeout, in seconds, for the operation to complete. Zero (0) means no timeout. This attribute defaults to 60. The default value is ‘60’.
  • fromrow: Number of rows to skip from start. The default value is ‘0’.
  • maxrows: Maximum number of rows to return from the database. Set to -1 to get all results. The default value is ‘-1’.
  • paramname#: The parameter names.
  • paramvalue#: The parameter values.
  • paramtype#: The parameter types.
  • transactionid: The Id of the transaction.

Output Attributes

  • *: Output varies based upon the query.