XML Unleashed

Scripting the XML DSO

Essentially, the XML DSO exposes two scripting interfaces: an SQL interface, which supports a subset of SQL, and the W3C XML DOM interface, which supports all of the Level1 DOM (see Chapter 15, "Utilizing the Document Object Model (DOM)" ).

Using SQL

The moveNext, movePrevious, moveLast, and moveFirst methods are all supported, but the syntax is slightly different from that in the TDC DSO. In the TDC DSO, parentheses after the methods that take no parameters are optional. In other words, the following is quite acceptable and would move the iterator to the next recordset:

cats.recordset.moveNext

In the XML DSO, empty parentheses must be included after the method. For example:

cats.recordset.moveNext()

The following ...