SelectSql()

Executes SQL statements.

Use this method to execute statements that return rows (SELECT statements).

Parameters

None

Examples

Copy

var Query;
Query = CRM.CreateQueryObj("Select * from company", "");
Query.SelectSql();
while (!Query.eof)
    {
        CRM.AddContent(Query("comp_companyid") + " = " + Query("comp_name")+" ");
        Query.NextRecord();
    }
Response.Write(CRM.GetPage());

Displays the company identifier and name field from the selected SQL query until the end of the query.