CodeCharge Studio

ds->CountSQL Run-Time Property (PHP)

Applies to

DataSource Object

Type

string

Access

read/write

Syntax

object->ds->CountSQL [=value]

Description

Stores the main part of the SQL query that is used to retrieve the number of records returned by a SELECT database query.
This property does not include the WHERE clause, before the query is executed conditions from the Where property are appended.
Note: The usual content of this property includes the COUNT aggregate function: SELECT COUNT(*) FROM ...

Examples

Dynamically Modify the SQL Statement,
Dynamically Modify the WHERE and ORDER BY Clauses of a ListBox,
Dynamically Modify the ORDER BY Clause,
Dynamically Modify the WHERE Clause