FieldValue

Gets or sets individual fields in a query.

Parameters

FieldName. Specifies the field name.

Examples

Copy

var value;
value = Query.FieldValue("MyField");

Retrieves a field named MyField.

Copy

var value;
value=Query("MyField");

Retrieves a field named MyField

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 the name field from the selected SQL query.