coldfusion query buildin functions

Method Signiture
Return TypeMethod SignitureDescription
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.

留言

這個網誌中的熱門文章

【研究】列印的條碼為什麼很難刷(掃描)

統一發票列印小程式

C# 使用 Process.Start 執行外部程式