coldfusion query buildin functions
Method Signiture
| Return Type | Method Signiture | Description |
|---|---|---|
| void | queryName.first() | jump to the first row of a query |
| void | queryName.last() | jump to the last row of a query |
| boolean | queryName.isFirst() | true if we are positioned at the first row |
| boolean | queryName.isLast() | true if we are positioned at the first row |
| boolean | queryName.next() | go to the next row, return true if there is a next row |
| boolean | queryName.previous() | go to the previous row, return true if there is a previous row |
| int | queryName.findColumn(String name) | get the internal zero based Column ID by name |
| void | sort(int columnID, boolean ascending) | sort by a column, use findColumn to get the column id |
| String | getColumnTypeName(int columnID) | gets the data type of a column, this one didn't work properly when I tested it, it would return NUMERIC for a field that was a varchar. There is a method called guessColumnType that was probably used to determine it, it guessed wrong. |
留言