| Products | Minisoft News | Events | Downloads | Product Manuals
 
  News

Minisoft News

Is your company legally licensed?

Press Release:
Minisoft Releases PCI Compliant Versions of ODBC, JDBC, and OLE DB


Demo and Updates

Download an Evaluation today!

ODBC Updates

Documentation

Installing the ODBC Upgrade

Release Notes

ODBC Manual

Get Acrobat

Product Review

ODBC Product Comparison

Case Study -
QSS and Minisoft

Brochure -
"Minisoft PCI Compliant"

Customer Feedback

Latest Reviews

Product FAQ

Support FAQ

Checking Versions


ODBC Application Samples

ODBC Downloadable Utilities


ODBC for UNIX

ODBC for Eloquence

ODBC on OSX

JDBC


MSJOB Information

 
   



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.gif (9169 bytes)
     
  2. Save the ODBC Form Page with a .htm extension.  This being your input page.
  3. Select the text box.  Right click the mouse button and select Form Field Properties.  The Text Box Properties dialog box will then appear.
  4. Name the Text Box, then click OK.


     
  5. 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'.


     
  6. Select 'Options' from the Form Properties dialog box.  The Options for Custom Form Handler window will appear.
  7. 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.
  8. Click OK.


     
  9. 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.gif (13692 bytes)
     
  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.gif (20514 bytes)
  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.gif (20616 bytes)
     
  2. The Insert Form Field Parameter dialog box will appear.  Enter the name of the text field on the first form, and click OK.


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

    frontpg9.gif (20481 bytes)

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

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.