| <iHTML |
| [LOGIN="uid/pword"] | (As specified in Registry) |
| [DBNAME="dsname"] | (As specified in Registry) |
| [SQL="SQL Statement"] | ( ) |
| [OUTPUT="output statement"] | ( ) |
| [NOOUTPUT="resolution for no output"] | ( ) |
| [FAILTURE="resolution for failture"] | ( ) |
| [FIRST="first row of query to output"] | (1) |
| [MAX="last row of query toi output"] | (last row in table) |
| [COLUMNS="number of columns"] | (1) |
| [BTWN="string to insert between columns"] | ( ) |
| [AFTER="string to insert after last columns"] | ( ) |
| [BREAKONNOOUTPUT="Yes | No"] | (No) |
| [BREAKONNOFAILTURE="Yes | No"] | (Yes) |
| [USECONNECT=""] | (As specified in Registry) |
| > |
|
This is the main iHTML 1.0 command set. This is therefore backwards
compatible and allows you to use both methods to access datasources. The
other method is <iSQL>.
|
| Comments |
DBNAME is the ODBC name of the datasource to use. If this is not
included, the default datasource (as defined in the registry) will be used.
|
|
LOGIN is the user ID and password which is used for logging on to
the database. They are separated by the slash (/) character.
|
|
SQL is the actual query string which is passed to the server. You can use
any SQL command which is allowed by the database server being used (e.g.,
any PL/SQL specific terms can be used when talking to Oracle including stored
procedures).
|
|
OUTPUT is the text to be displayed for EACH row of output. That is, text
will be displayed once for every row generated by the query in SQL. This can
contain any HTML tags, freeform text, or graphics.
|
|
To include results from the SQL query string, use the following format:
':#'
|
|
where '#' is the digit representing the column number in the result table.
For example, with the query "SELECT id, name, sin FROM emp_table", :1
represents the 'id' column, :2 represents the 'name' column, and :3
represents the 'sin' column.
|
|
NO OUTPUT is the text to be displayed when the query in SQL succeeds, but
returns no rows. This is most often used with the INSERT and DELETE
statements. Used with iIF, it is possible to display a message or perform
another function depending on the results.
|
|
FAILURE is the text to display when the query in SQL fails to execute
(because of some error condition). You can place the :i_sqlerrortext in the
FAILURE directive. Once the query resolves to a failure, it will output
the error string.
|
|
BREAKONFAILURE: If set to "YES" (the double quotes are required), this will
cause the rest of the HTML document containing this tag to be skipped when a
failure occurs. In this way, <iHTML> tags following the current one can be
aborted. This is displayed if the document source is viewed. It is not
displayed in the resulting HTML page in the browser.
|
|
Note 1: If not specified, this parameter defaults to "NO".
|
|
Note 2: If no FAILURE string is specified, but BREAKONFAILURE is
set to "YES", you will not be able to determine what error occurred, since
ihtml 2.1 will not output the server-specific error code.
|
|
BREAKONNOOUTPUT functions similar to BREAKONFAILURE except that it applies
to the NOOUTPUT condition.
|
|
Use this method only when the information you need cannot be generated with
a properly constructed SQL join.
|
|
FIRST: First "Row" of the query to display
|
|
MAX: Last "Row" of the query to display
|
|
COLUMNS: Number of columns, width of the columns in characters.
|
|
Note: The default is 1 column of infinite characters. This includes any
tags as well. The default is used if the parameter is left out. You may
need to change the defaults in order to be more compatible with the existing
HTML pages.
|
|
BTWN: This is the column separator to insert between columns. Normally
this would consist of white space, or HTML tags.
|
|
AFTER: This is the last column terminator. Normally this would be the
new paragraph tag.
|