CodeCharge Studio

DataSource->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

See Also

DataSource Property
DataSource->SQL Property
DataSource->Where Property
DataSource->Order Property
DataSource->RecordsCount Property


On-line, printable versions and updates