Latest News

the latest news from our team

FrontPage 98

In order to complete a web query you must have two pages. The first page being the input page saved with a .htm extension. The second being the results page saved with a .asp extension (Active Server Page).  Keep in mind that the .asp page you create will be linked to the .htm input page. The correct .asp page must be specified, or the association between the input page and the results page will not work.

Creating ODBC Input Form Page

  1.  Create a new input form.  Add a text field to enter your value.  To insert a text field click Insert on the menu bar.  Highlight Form Field, then click on One-Line Text Box. The window changes to as shown below:

frontpg1

 

  1. Save the ODBC Form Page with a .htm extension.  This being your input page.
  2. Select the text box.  Right click the mouse button and select Form Field Properties.  The Text Box Properties dialog box will then appear.
  3. Name the Text Box, then click OK.

ODBCaa02

  1.  Right click inside the Form Field and select Form Properties.  The Form Properties dialog box will appear. Under What To Do With Form Results adjust the Form Properties to ‘Send To Other’.

ODBCaa03

    1. Select ‘Options’ from the Form Properties dialog box.  The Options for Custom Form Handler window will appear.
    2. Enter the name of your active server page with a .asp extension.  The correct .asp page must be specified, or the association between the input page and the results page will not work.
    3. Click OK.

ODBCaa04

  1.  Click OK again when the Form Properties dialog box appears.

 

 Creating ODBC results form page

Note:  The correct .asp page must be specified, or the association between the input page and the results page will not work.

  1.  Create a new second page for the query. Name this page with an extension of ASP.

    Example: ‘odbc_fp98_query.asp’.

  2.  Add a Database Region to your query form. To add a database, select Insert from the menu bar, highlight Database, then click Database Region Wizard.

    frontpg6

  3.  The Database Region Wizard dialog box will appear.  Use a DSN that is defined as a system DSN on your Windows NT IIS Server.  Then click Next.

    frontpg5

  1.  Under ‘Enter the SQL string for the Query’ enter your SQL statement as shown below. At the point in your WHERE clause that you wish to enter the value from your Form, select Insert Form Field Parameter.

    Note:  If you are querying for alpha characters use quotes, for numerical characters do not.

    frontpg7

  2.  The Insert Form Field Parameter dialog box will appear.  Enter the name of the text field on the first form, and click OK.

    ODBCaa06

  3.  Click Add Field to enter the names of the fields to be presented. Then click Finish.

    frontpg9

  4.  Your results will then be shown in the FrontPage Editor.

    ODBCaa09

Note:  Pay close attention to whether you are using caps lock or no caps in the input form page on the web.  Image character keys are case sensitive.

 

Leave a Reply

Your email address will not be published. Required fields are marked *