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