ResultSet object (Object/NES)

This is part of the database access suite in Netscape Enterprise Server. It is returned by a stored procedure call.

Availability:

JavaScript - 1.2
Netscape Enterprise Server - 3.0
JavaScript syntax:nesmyResultSet = myStProc.resultSet();
Object properties:prototype
Object methods:close(), columnName(), columns(), next()

When you call a stored procedure in a RDMS, you don't always get back a sequence of records in the same layout and structure as when you just do a simple SQL select style query.

An SQL query would return a series of records separated by newline characters. A stored procedure might return a mixed collection of records of different types.

A ResultSet object is created by asking the Stproc object for it when the stored procedure has been called and returned from the database.

The traversing mechanisms provided with a result set allow you to move forwards through the data but you cannot move backwards. Also, you can only read values from a result set as opposed to a cursor which allows you to update it and write new values back.

Example code:

   <SERVER>
   // An example derived from Wrox Professional JavaScript
   database.connect("ODBC", "myDatabase", "me", "myPassword", "");
   myStoredProc = database.storedProc("myProcedure", 40);
   myResultSet = myStoredProc.resultSet();
   </SERVER>

See also:database.storedProc(), Netscape Enterprise Server, Stproc.resultSet(), unwatch(), watch()

PropertyJavaScriptJScriptNIEOperaNESECMADOMCSSHTMLNotes
prototype1.2 1.2 n/a n/a n/a n/a3.0 3.0 n/a n/a n/a n/a-

MethodJavaScriptJScriptNIEOperaNESECMADOMCSSHTMLNotes
close()1.2 1.2 n/a n/a n/a n/a3.0 3.0 n/a n/a n/a n/a-
columnName()1.2 1.2 n/a n/a n/a n/a3.0 3.0 n/a n/a n/a n/a-
columns()1.2 1.2 n/a n/a n/a n/a3.0 3.0 n/a n/a n/a n/a-
next()1.2 1.2 n/a n/a n/a n/a3.0 3.0 n/a n/a n/a n/a-