#!/bin/csh -f

set database = "/usr/local/etc/httpd/htdocs/laserdisk/artsurvey/db.new.laserdisk"

cat <<End_Of_Form >$1

<title>A Survey of Western Art</title>

<H2>A SURVEY OF WESTERN ART<br>

<hr>

<h2>Please select at least one of the following properties<br>to be searched for.<br></h2>
Then use the <b>submit</b> button at the bottom of the document to query the database.<br>
<hr>

<FORM ACTION="http:/cgi-bin/database_interface/artsurvey/check_query" METHOD="POST">

Country:<inPUT NAME="s_01"> (separate multiple items with '<b>/</b>')<br> 

Search for <b>any</b> <inPUT type="radio" name="s_01" value="ORING" CHECKED><br>
or <b>all</b> <inPUT type="radio" name="s_01" value="ANDING" > of the items typed above or selected from the list below,st,<br>
<SELECT NAME="s_01" MULTIPLE SIZE=8>
End_Of_Form
cut -f1 -d\, $database  | sort -u | awk -F\, '{printf"<OPTION>%s\n",$1}' >>$1
cat <<End_Of_Form >>$1
</SELECT>(use CTRL to select multiple items)

<hr>
Site:<inPUT NAME="s_02" SIZE=20> (separate multiple items with '<b>/</b>')<br>
Search for <b>all</b> <inPUT type="radio" name="s_02" value="ANDING" CHECKED> or<br>
<b>any</b> <inPUT type="radio" name="s_02" value="ORING"> of the above, '<b>/</b>' separated item
s.<br>
<SELECT NAME="s_02" MULTIPLE SIZE=8>
End_Of_Form
cut -f2 -d\, $database  | sort -u | awk -F\, '{printf"<OPTION>%s\n",$1}' >>$1
cat <<End_Of_Form >>$1
</SELECT>(use CTRL to select multiple items)

<hr>

Type of Work:<inPUT NAME="s_03" SIZE=20> (separate multiple items with '<b>/</b>')<br>
Search for <b>all</b> <inPUT type="radio" name="s_03" value="ANDING" CHECKED> or<br>
<b>any</b> <inPUT type="radio" name="s_03" value="ORING"> of the above, '<b>/</b>' separated items.<br>
<SELECT NAME="s_03" MULTIPLE SIZE=8>
End_Of_Form
cut -f3 -d\, $database  | sort -u | awk -F\, '{printf"<OPTION>%s\n",$1}' >>$1
cat <<End_Of_Form >>$1
</SELECT>(use CTRL to select multiple items)

<hr>

Work:<inPUT NAME="s_04"> (separate multiple items with '<b>/</b>')<br> 

Search for <b>any</b> <inPUT type="radio" name="s_04" value="ORING" CHECKED><br>
or <b>all</b> <inPUT type="radio" name="s_04" value="ANDING" > of the items typed above or selected from the list below,st,<br>
<SELECT NAME="s_04" MULTIPLE SIZE=8>
End_Of_Form
cut -f4 -d\, $database  | sort -u | awk -F\, '{printf"<OPTION>%s\n",$1}' >>$1
cat <<End_Of_Form >>$1
</SELECT>(use CTRL to select multiple items)

<hr>

Detail of Work:<inPUT NAME="s_05"> (separate multiple items with '<b>/</b>')<br> 

Search for <b>any</b> <inPUT type="radio" name="s_05" value="ORING" CHECKED><br>
or <b>all</b> <inPUT type="radio" name="s_05" value="ANDING" > of the items typed above or selected from the list below,st,<br>
<SELECT NAME="s_05" MULTIPLE SIZE=8>
End_Of_Form
cut -f5 -d\, $database  | sort -u | awk -F\, '{printf"<OPTION>%s\n",$1}' >>$1
cat <<End_Of_Form >>$1
</SELECT>(use CTRL to select multiple items)

<hr>


<inPUT type="submit" value="Submit Query"><inPUT type="reset" value="Reset the form">
</FORM>


<FORM ACTION="http:comment_collector.html">
<inPUT TYPE="submit" VALUE="Send comments to the maintainer">
</FORM>

End_Of_Form

#<inPUT TYPE="radio" NAME="ANDFIELDS" VALUE="YES" CHECKED> <ab>Select records with <b>ALL</b> of the above.<br>
#<inPUT TYPE="radio" NAME="ANDFIELDS" VALUE="NO" >Select record with <b>ANY</b> of te above.<br>