[ Main Menu ] [ Extension Tools Menu ] [ Free Edition Menu ]


[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"]( )
[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.

iHTML example
Example Source Code