Programming Reference:Functions:CCBuildSQL

From CodeCharge Studio Community Wiki

Description
Builds an SQL command.

Location
Common

Syntax

CCBuildSQL(operation, where, order_by);

Return value
SQL command string

Parameters

Name	Type	Description	Required
operation	string	SELECT, INSERT, or UPDATE tablename and/or joins.	Yes
where	string	Any SQL where parameters.	No
order_by	string	SQL ORDER BY.	No

See also:
CCBuildInsert

PHP

//A crude sample:

global $DBIntranetDB();
$db = new clsIntranetDB();
$db->SQL = "SELECT * FROM MyTable ";
$db->Where = "MyField=1";
$db->OrderBy = "MyField";
$db->query(CCBuildSQL($db->SQL, $db->Where, $db->OrderBy));