If you would like to see an example of each of these pages working, please download this [Template] for NOF 4.0.1 and this [Template] for NOF 5.0. Please note these are works in progress. The NOF 4.0 Template may require to to delete and read the Update component. Be sure to install the Sports database in your ODBC as Sports or your Video database in your ODBC as Video.

Requires:

That the page extension is set of "asp."

Connection:

MSDBConnection - Specifies the ODBC data source name (DSN)

Action:

MSDBQuery - Specifies the table in the OBDC data source we wish to access, as well as what records we wish to see. This takes the form of a SQL SELECT statement. If the user comes directly to  this page, the list displays the records in the SQL SELECT statement. If the user comes to this page from a search page, the MSDBQuery will use the search criteria passed to it from the search page.

Display:

MSDBList - Specifies the fields to display, the page it should link to, the field the link should appear on, and the key field of the table being displayed.
Note: The value of the key field is unique to each record, which allows ASP to differentiate one similar record from another. The key field property is required if you are going to link to a detail page from this list

Requires:

That the page extension is set of "asp." If being used as an “Update Page”, the "Layout is a form" checkbox must be checked.

Connection:

MSDBConnection - Specifies the ODBC data source name (DSN)

Action:

MSDBQuery - Specifies the table in the ODBC data source we wish to access and display fields from.
Note: Detail Pages are often made into “Update Pages,” used for Adding, Modifying or Deleting a record.  In all cases but Adding a record, the customer has come to this detail page from a list page. Therefore the SQL SELECT statement in this MSDBQuery is ignored in favor of the record passed from the List page. In the case of Adding a record, this MSDBQuery specifies which table will get this new record.
MSDBUpdate - Only used when the page is an “Update Page.” The key field property is required if you are going to Modifying or Delete from a database. This key field will not change it’s value and is unique to each record, which allows ASP to differentiate one similar record from another.

Display:

MSDBDynaField - Basically a HTML text field that is directly linked to a field in the database table. On an “Update Page” we would like this MSDBDynaField to be empty. Therefore the "Use Query" property needs to be "false". In the case of a detail page that displays, modifies or deletes a record, this field should be "true".