{"id":2313,"date":"2014-12-18T19:55:05","date_gmt":"2014-12-18T19:55:05","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2313"},"modified":"2014-12-18T19:55:05","modified_gmt":"2014-12-18T19:55:05","slug":"frontpage-98","status":"publish","type":"post","link":"https:\/\/www.minisoft.com\/support\/frontpage-98\/","title":{"rendered":"FrontPage 98"},"content":{"rendered":"

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).\u00a0 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.<\/p>\n

Creating ODBC Input Form Page<\/p>\n

    \n
  1. \u00a0Create a new input form.\u00a0 Add a text field to enter your value.\u00a0 To insert a text field click Insert on the menu bar.\u00a0 Highlight Form Field, then click on One-Line Text Box.\u00a0The window changes to as shown below:<\/li>\n<\/ol>\n

    \"frontpg1\"<\/a><\/p>\n

     <\/p>\n

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

      \"ODBCaa02\"<\/a><\/p>\n

        \n
      1. \u00a0Right click inside the Form Field and select Form Properties.\u00a0 The Form Properties dialog box will appear.\u00a0Under What To Do With Form Results adjust the Form Properties to ‘Send To Other’.<\/li>\n<\/ol>\n

        \"ODBCaa03\"<\/a><\/p>\n

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

            \"ODBCaa04\"<\/p>\n

              \n
            1. \u00a0Click OK again when the Form Properties dialog box appears.<\/li>\n<\/ol>\n

               <\/p>\n\n\n\n\n
              \n

              \u00a0Creating ODBC results form page<\/h3>\n

              Note:\u00a0 The correct .asp page must be specified, or the association between the input page and the results page will not work.<\/p>\n

                \n
              1. \u00a0Create a new second page for the query.\u00a0Name this page with an extension of ASP.\n

                Example: ‘odbc_fp98_query.asp’.<\/li>\n

              2. \u00a0Add a Database Region to your query form.\u00a0To add a database, select Insert from the menu bar, highlight Database, then click Database Region Wizard.\n

                \"frontpg6\"<\/a><\/li>\n

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

                \"frontpg5\"<\/a><\/li>\n<\/ol>\n

                  \n
                1. \u00a0Under ‘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.\n

                  Note:\u00a0 If you are querying for alpha characters use quotes, for numerical characters do not.<\/p>\n

                  \"frontpg7\"<\/a><\/li>\n

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

                  \"ODBCaa06\"<\/a><\/li>\n

                3. \u00a0Click Add Field to enter the names of the fields to be presented. Then click Finish.\n

                  \"frontpg9\"<\/a><\/li>\n

                4. \u00a0Your results will then be shown in the FrontPage Editor.\n

                  \"ODBCaa09\"<\/a><\/li>\n<\/ol>\n

                  Note:\u00a0 Pay close attention to whether you are using caps lock or no caps in the input form page on the web.\u00a0 Image character keys are case sensitive.<\/td>\n<\/tr>\n

              <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

               <\/p>\n","protected":false},"excerpt":{"rendered":"

              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).\u00a0 Keep in mind that the .asp page you create will be linked to the .htm input page. […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2313"}],"collection":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2313"}],"version-history":[{"count":1,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2313\/revisions"}],"predecessor-version":[{"id":2324,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2313\/revisions\/2324"}],"wp:attachment":[{"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}