Instead of displaying the result of the query on screen, the display can be stored in session variables and then placed on the screen via a template. This is one of the two methods to place data onto the template. The other method is to use a direct template like FormTemplate, FilterTemplate, EditUpdateTemplate, EditDeleteTemplate, EditAddTemplate.
There are 4 types of object that can be generated and stored in a session variable - Grid, BLOCK, SelectBox and Chart. Each one of these objects has its own property format.
When dbMagicLayout is specified, it is assumed that the entire module is dedicated to generate the object when the Obj.ASPdb is executed.
Test Layout Object / MagicLayout Session Variable
When the dbMagicLayout property is specified, the output is stored in a session variable as ASPdb_Layout_UnitID_ObjectID. The Test Layout Object check box will append a response.write at the end of the ASP code to display the object.
Note: dbDisplay is set to False when dbMagicLayout is specified.
The grid will be stored in the session variable including the set attributes.
A block is defined as the values (cells) of field column(s) arranged in a serial manner. The tagging of these cells is similar to the <Table> construct where head, tail, begin-row, end-row, begin-cell, end=cell tags can be specified. There are also 3 more controls to determine how to "flow" the cells into the matrix - Across Size, Across Direction and Across Orientation.
Selectbox layout type exports a single or multiple selection selectbox together with the submit button.
The select frame will be visible upon selecting the SelectBox layout type. SelectBox Macro is the macro to create the line items of the selectbox. Button Tag is the text on the select button.
Note that upon a multiple select the result is stored in a session
format of -> Session("SV_SelectBoxItem_Unit") = Select1,Select2....
For example, if the selection are fieldnames, then just add the SELECT and FROM... to construct the query.
If the Chart option is selected then the Chart form will be activated.