IDC
Datasource: sqltel
Username: sa
Template: semplice.htx
SQLStatement:
+
+ SELECT au_lname, au_fname, title
+ FROM authors, titles, titleauthor
+ WHERE authors.au_id = titleauthor.au_id
+ AND titles.title_id = titleauthor.title_id
+ AND au_lname like '%cognome%%%'
HTX
<HTML>
<HEAD><TITLE>titolo documento</TITLE></HEAD>
<BODY BGCOLOR="FFFFFF">
<H1>Titolo pagina</H1>
<!--risultato select: restituisce gli autori col cognome indicato-->
<OL>
<%begindetail%>
<!--cognome nome titolo-->
<LI><%au_lname%> <%au_fname%> <FONT COLOR="RED"><%title%></font>
<%enddetail%>
</OL>
</BODY>
</HTML>
Utility client: ISQL_w, MS QUERY
Database Microsoft: Access
Linguaggi di programmazione: Visual Basic
Internet: IDC e HTX
