SQL

Sets the SQL statement for the query.

The SQL statement is usually passed in when the object is created, but you can change it using this property. The SQL is not executed until you call one of the execute methods (SelectSql() or ExecSql()).

Examples

var Query;
Query = CRM.CreateQueryObj("Select * from company", "");
Query.SQL = "Select * FROM person";
Query.SelectSql();
while (!Query.eof)
{
CRM.AddContent (Query("pers_personid")+" = " +Query("pers_lastname") +" ");
Query.NextRecord();
}
Response.Write(CRM.GetPage());

Resets the SQL SELECT statement to query the Person table instead of the Company table.