contents   index   previous   next



Cursor columnName()

syntax:

cursor.columnName(n)

where:

n - zero-based integer corresponding to the column in the query. The first column in the result set is 0, the second is 1, and so on.

 

return:

string - the name of column number n in the cursor.

 

description:

Given a column number, columnName() returns the name of the column.

 

When using SELECT statements with wildcards (*) to select all the columns in a table, the columnName method does not guarantee the order in which it assigns numbers to the columns. Thus, use columnName to find which name corresponds to which column number.

 

see:

#link <sedbc>, Cursor columns()

 

example:

// assume 'database' is a valid, open Database object

var curs = database.cursor(SELECT * FROM customer);

 

// get the name of the first column in the cursor

header = customerSet.columnName(0);

 


Cursor columns()