framework reference

• global
• Application
• Request
• Response
• Session
• HopObject
• File
• FtpClient
• Image
• Mail
• Xml
• database connection
• database rowset
• mimepart
• skin

modules reference

• core.Array
• core.Date
• core.Number
• core.Object
• core.String


• helma.Aspects
• helma.Chart
• helma.Color
• helma.Database
• helma.File
• helma.Ftp
• helma.Html
• helma.Http
• helma.Mail
• helma.Search
• helma.Skin
• helma.Ssh
• helma.Url
• helma.Zip


• jala.AsyncRequest
• jala.BitTorrent
• jala.Captcha
• jala.Date
• jala.DnsClient
• jala.ErrorTracker
• jala.Form
• jala.History
• jala.HtmlDocument
• jala.I18n
• jala.ImageFilter
• jala.IndexManager
• jala.ListRenderer
• jala.Mp3Info
• jala.PodcastWriter
• jala.RemoteContent
• jala.Rss20Writer
• jala.Utilities
• jala.XmlRpcRequest
• jala.XmlWriter

dbRowset

Object
   |
   +--dbRowset

---

See:

- global.getDBConnection
- dbConnection

---

SUMMARY: Constructor | Properties | Methods

DETAIL: Constructor | Properties | Methods

---

Constructor Summary

dbRowset(Object)             Rowset object representing the results of a value returning database query initiated using the dbConnection.executeRetrieval method.

 

Methods Summary
Number	getColumnCount()            Get the number of columns of this result, identical to the length attribute.
String	getColumnDatatypeName()            Get the name of the datatype associated with the column.
Number	getColumnDatatypeNumber()            Get the number of the datatype associated with the column.
Object	getColumnItem(<String> name)            Get the value of a column by its name (the value can be accessed by number simply indexing them - this is not faster than by name for FESI).
String	getColumnName()            Get the name of a column, in a way which is always working.
Object	getLastError()            Return the last error which occured when connecting or executing a statement, null (which test as false) if none.
void	getMetaData()            Return the meta data attached to the row set.
Boolean	hasMoreRows()            Optimistic view of the possibility that more rows are present.
Boolean	next()            Get the next row of results, return true if there is a next row, false otherwise.

Constructor Detail

dbRowset

dbRowset(Object)

Rowset object representing the results of a value returning database query initiated using the dbConnection.executeRetrieval method. There is no constructor to instantiate these objects.

In addition, the RowSet will return any column name property as its value, any index as the value of the corresponding column, and enumerate column names. The enumeration will only contain the column names, not any property added to the prototype or the object itself. However the internal names (valueOf, toString, length), the properties of the prototype (including the routines of the RowSetAccessprotocol) takes precedence over the name of columns when accessed as a property. The usage of indexed access or of the routine getColumnItemis therefore prefered.

The RowSet string representation includes the SQL statement and its logical position if at start or at end.

See:
- global.getDBConnection
- dbConnection

---

Method Detail

getColumnCount

Number getColumnCount()

Get the number of columns of this result, identical to the length attribute. It is possible to call this routine before the first record is fetched.

Returns:
Number of colums

---

getColumnDatatypeName

String getColumnDatatypeName()

Get the name of the datatype associated with the column. See the jdbc documentation for details. Some database do not return a valid name, in that case undefined is returned. It is possible to call this routine before the first record is fetched.

Returns:
String containing the name of the data-type associated with the column

---

getColumnDatatypeNumber

Number getColumnDatatypeNumber()

Get the number of the datatype associated with the column. See the jdbc documentation for details. It is possible to call this routine before the first record is fetched.

Returns:
Number of data-types associated with the column

---

getColumnItem

Object getColumnItem(<String> name)

Get the value of a column by its name (the value can be accessed by number simply indexing them - this is not faster than by name for FESI). The proper value is returned even if the name is used for a property of the RowSetAccess protocol, as next or length. A record must be available (that is next must have been called at least once).

Parameters:
name - as String, name of the column

Returns:
value of a column

---

getColumnName

String getColumnName()

Get the name of a column, in a way which is always working. The names can be accessed as properties, but they are shadowed by the functions and properties of the RowSetAccess prototype object. It is possible to call this routine before the first record is fetched.

Returns:
String containing the name of a column

---

getLastError

Object getLastError()

Return the last error which occured when connecting or executing a statement, null (which test as false) if none.

Returns:
last error or else null if none

---

getMetaData

void getMetaData()

Return the meta data attached to the row set.

---

hasMoreRows

Boolean hasMoreRows()

Optimistic view of the possibility that more rows are present.

Currently only returns false if next returned false. It is possible to call this routine at any time.

Returns:
Boolean false if calling next() returned false

---

next

Boolean next()

Get the next row of results, return true if there is a next row, false otherwise. Note that next must be called before the first row can be accesses.

Returns:
Boolean true if a next row exists else false

---

SUMMARY: Constructor | Properties | Methods

DETAIL: Constructor | Properties | Methods

---