The SQLweb Engine processes "extended" HTML files that are referenced via the CGI interface. Once processed by SQLweb, the output to the browser is pure standard HTML. No special browser or client-side software is needed-- all "extended" tags are processed on the server by SQLweb.
The SQLweb Tags are processed by the SQLweb Engine to output standardHTML. Below is a detailed description of these tags and how theywork.
Syntax
<CURSOR SQL="sql statement"> ... </CURSOR>
Description
The CURSOR tag is used to interface with the database. It is normally, but not always, preceeded by one of more IF tags that perform data validation prior to the execution of the SQLstatements.
The CURSOR tag can be used for any valid SQL statement .
Example
<OL>
<CURSOR SQL="select * from emp">
<LI>:last_name, :first_name, :phone</LI>
</CURSOR>
</OL>
Syntax
<HOST CMD="Operating System Command">
Description
The HOST tag is used to replace the output of a host command in the place of the tag.
Example
<HOST CMD="finger :finger_name">
Syntax
<IF EXPR="sql where clause"> ... </IF>
Description
The IF tag is implemented as a WHERE CLAUSE and processed by Just Logic/SQL
Syntax
<IF2 EXPR="expression"> ... <IF2>
Description
The IF2 tag is a built-in tag that is processed by the SQLweb engine directly without help from the database engine.
Example
<IF2 EXPR=":remote_ip_addr IN('127.0.0.1','127.0.0.2')
AND :count BETWEEN 1 AND 10
AND SUBSTR(:name,1,2) = 'SQ'">
<P>You are <I>Local</I> and :count is between
1 and 10 and :name starts with SQ.</P>
</IF2>
Syntax
<INCLUDE FILENAME="file reference">
Description
The SQLweb INCLUDE tag is used to embed a SQLweb page within another.
Syntax
<SYMBOL EXPR="SQLweb expression">
Description
The SYMBOL tag is used to create and modify symbols.
Example
<SYMBOL EXPR=":new_sym := NVL(:old_sym,'default')"> <P>The symbol new_sym is now :new_sym, but old_sym is :old_sym!</P>
email: sales@justlogic.com
Last modification: 10/96