A set of seven page definition files is available in ColdFusion Studio and JRun Studio. The library can be used to quickly build data access capabilities into wizards.
This section is included for HomeSite users who may want to upgrade to use these additional features.
Following are examples of each of the seven wizard definition pages available in the library. For complete syntax and usage information, see the Wizards Definition Page Library section of the VTML Reference.
<PAGE name="SelectWizardNameAndLocation" type="SelectNameAndLocation" caption="Data Drill-Down Application" image="..\\images\\Main.bmp">
<INPUT name="editApplicationName" param="ApplicationName" required="yes" validationMsg="You cannot leave the Application Name field blank"> <INPUT name="editLocation" param="Location "required="yes" validationMsg="You cannot leave the Location field blank"> </PAGE>
<PAGE name="DataSource" type="SelectDataSource" caption="Data Source"
image="..\\images\\SelectData.bmp"> <PARAM name="ListBoxLabel" value="Select data source:"> <PARAM name="ListBoxDescription" value="Choose the data source from which you would like to display data.\n\nIf your database is not registered as ODBC data source, open the ODBC administrator in Control Panel and add system data source for this database."> <PARAM name="ResetParams" value="Joins"> <PARAM name="RemoveParams" value="Tables,SearchFields,ResultFields, DetailFields,UniqueIdentifier"> <INPUT name="cbDataSources" param="DataSource" required="yes" validationMsg="You did not select the data source. Please select one before proceeding."> </PAGE>
<PAGE name="Tables" type="SelectTables" caption="Tables"
image="..\\images\\SelectTable.bmp"> <PARAM name="DataSource" value="$${DataSource}"> <PARAM name="ListBoxLabel" value="Select database tables:"> <PARAM name="ListBoxDescription" value="Please specify the tables which will be involved in this application. This should include any tables against which you would like to search or tables containing data that will be displayed on either the Result or Detail pages.\n\nPress Ctrl or Shift together with the mouse click in order to select more than one table. Do not select unrelated tables."> <PARAM name="MultiSelect" value="yes"> <PARAM name="ResetParams" value="Joins"> <PARAM name="RemoveParams" value="SearchFields,ResultFields, DetailFields,UniqueIdentifier"> <INPUT name="lstTables" param="Tables" required="yes" validationMsg="You did not select any tables. Please select at least one before proceeding."> </PAGE>
<PAGE name="Table" type="Table" caption="Table"
image="..\\images\\SelectTable.bmp"> <PARAM name="DataSource" value="$${DataSource}"> <PARAM name="ListBoxLabel" value="Select database table:"> <PARAM name="ListBoxDescription" value="Records from this table will be displayed in the record viewer."> <PARAM name="RemoveParams" value="Table,ViewFields,EditFields, UniqueIdentifier"> <INPUT name="cbTables" param="Table" required="yes" validationMsg="You didn't select the table. Please select one before proceeding."> </PAGE>
<PAGE name="TableJoins" type="SelectTableJoins" caption="Table Joins" image="..\\images\\SelectJoins.bmp">
<PARAM name="DataSource" value="$${DataSource}"> <PARAM name="Tables" value="$${Tables}"> <PARAM name="ListContent" value="$${Joins}"> <INPUT name="lstJoins" param="Joins"> </PAGE>
<PAGE name="SearchFields" type="SelectFields" caption="Fields for Search
page" image="..\\images\\SearchCriteria.bmp"> <PARAM name="DataSource" value="$${DataSource}"> <PARAM name="Tables" value="$${Tables}"> <PARAM name="ListBoxLabel" value="Select the search fields:"> <PARAM name="ListBoxDescription" value="Choose all fields that should be included as search criteria on the Search page. Press Ctrl or Shift together with the mouse click in order to select more than one field."> <PARAM name="MultiSelect" value="yes"> <INPUT name="lstFields" param="SearchFields" required="yes" validationMsg="You did not select any fields. Please select at east one before proceeding."> </PAGE>
<PAGE name="IDField" type="SelectField" caption="Unique Identifier"
image="..\\images\\UniqueIDDetail.bmp"> <PARAM name="DataSource" value="$${DataSource}"> <PARAM name="Tables" value="$${Tables}"> <PARAM name="ListBoxLabel" value="Select the unique identifier for the Detail page:"> <PARAM name="ListBoxDescription" value="In order to 'drill-down' to the detail page the wizard needs to know the unique identifier for the detail page. This is the field that determines which record should be displayed in detailed form.\n\nFor example, if you are building an application to search an employee database you might use a field called 'Employee_ID' as the unique identifier."> <PARAM name="MultiSelect" value="no"> <INPUT name="cbFields" param="UniqueIdentifier" required="yes" validationMsg="You did not select the unique identifier. Please select one before proceeding."> </PAGE>