Search these areas:
Help
Support Forums
Product Info



Introduction
DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
Views
Templates
Components
Data Analysis
Members
Security
Importing
Exporting
FTP
JavaScript
Object Model
JavaScript Objects
General Scripting Objects
Data Access Objects
cmdDelete Object
cmdInsert Object
cmdSelect Object
-execute
-getColumns
-getFilter
-getSort
-getTablename
-setColumns
-setFilter
-setSort
cmdUpdate Object
Data Access Method Arguments
Field Object
Fields Collection
Index Object
Indexes Collection
previous Object
record Object
Resultset Object
Table Object
Tables Collection
TextImporter Object
Settings Object
View Object
Web Object
File Access Objects
Http Client Objects
Security and Membership Objects
Document Object Model (DOM)
Error Descriptions
Object Model Extensions
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
Glossary
New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

DataWeb User's Guide

cmdSelect.setColumns()
Syntax

cmdSelect.setColumns(columns)

Arguments Description
columns Sets the columns for the cmdSelect object and query, overwriting any prior setting.

Returns

Return value is undefined.

Description

The cmdSelect.setColumns() method specifies the columns, i.e., fields, to be retrieved by the cmdSelect.execute() method. The columns argument may be a comma-delimited string, an array, or an array literal specifying the field names of a given table.

Example

The following setColumns() example uses a comma-delimited string to set the columns to be retrieved. It then prints out the columns specified by the setColumns() method.
  var sel = new cmdSelect("AddressBook");
  sel.setColumns("FirstName, LastName, Email");
  response.write(sel.getColumns());
Output:

FirstName, LastName, Email

Related Topics

cmdSelect Object, cmdSelect.getColumns(), cmdSelect.execute()
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
Email Us