[Main Page]      [Literature]      [Software]      [People]      [Conferences]      [Courses]      [Web-DB]

 

UNIVERSITY OF PITTSBURGH
School of Information Sciences

INFSCI 2710 - Database Management

Stefan Brass

Web-DB Interfaces:   Example in HotSQL

See also: http://www.clearlight.com/~dmc/hotsql/
or http://www.chimerasoft.com/hotsql/

Source File "course_query" (Standard HTML) 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Course Database (Query Form)</TITLE>
</HEAD>
<BODY>
<H1>Course Database (Query Form)</H1>
<FORM METHOD="post" ACTION="/cgi-bin/hotsql.exe/course_print">
Please Enter Instructor: <INPUT NAME="Instructor" SIZE=20>
<INPUT TYPE=SUBMIT VALUE="Execute Query">
</FORM>
</BODY>
</HTML>

Source File "course_print" (with HotSQL-Commands) 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
<HTML>
<HEAD>
<TITLE>Course-DB (Query Result)</TITLE>
</HEAD>
<BODY>
<!-- hsql print "<H1> Courses by $Instructor</H1>" -->
<UL>
<!-- hsql connect sis, scott, tiger -->
<!-- hsql select CRN, Title from Course WHERE Name='$Instructor' -->
<!-- hsql list "<LI> $2 ($1)" -->
</UL>
</BODY>
</HTML>

Alternative to "list"-Command 
<!-- hsql loop -->
	<!-- hsql print "$2 ($1)" -->
<!-- hsql endloop -->

Stefan Brass (sbrass@sis.pitt.edu), April 23, 1999

Original URL: http://www2.sis.pitt.edu/~sbrass/db/webdb1.html   [HTML 3.2 Checked]