DBINSERT

Defines a set of database insertions that is expected to result from a page or response. e.g.

        <dbInsert dbTable="log" id="userid"/>

This specifies that a single insertion is expected into the log table; the id of the inserted row is assigned ot the variable userid

If multiple insertsions are expected, or if a specific database query is required, use in conjection with the dbInsertRef element. e.g.

        <dbInsert dbTable="orders"/>
                <dbInsertRef id="order1" />
                <dbInsertRef id="order2" />       
        </dbInsert>
or
        <dbInsert dbTable="orders"/>
                <dbInsertRef id="order1" query="select max(id) from orders"/>
                <dbInsertRef id="order2" query="select max(id)-1 from orders"/>       
        </dbInsert>        

Values can also be extracted from the database using the set element. The difference with dbInsert is that dbInsert is checking all tables for insertions as well as optionally extracting the identifiers of inserted rows.

1. Allowed Content

dbinsertref -- Defines a database insertion that is expected to result from a page or response.

---

2. Attributes

Attribute	Value(s)	Default Value
count	The number of expected insertions. CDATA	1
dbtable	A reference to a dbTable element CDATA	#REQUIRED
id	An optional variable name that can be used in output elements, or as part of a regular expression e.g. <dbInsert dbTable="log" id="userid"/> ... <fetch queryString="id=#{userid}"/> Variable expansion is first performed on global vaiables and then on the javascript of the current HTML page. ID	#IMPLIED

---

3. Content Rule

( dbinsertref ) *

---

4. Parent Elements

definepage   -- Used to define the structure of a html page
exec   -- Run a datatbase sql command
form   -- Specifies that a page or response contains a frameset
frame   -- Specifies the contents of a frame.
set   -- Set a variable to a value extracted from the database, to a value extracted from the current page.
verify   -- Verify the most recently fetched page against a specification.

Top Elements || All Elements || Tree