|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/davidbacker/_logs/W2KWEB2A/CH/artresearch/essays/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/REC-html40/loose.dtd"><HTML>
<HEAD>
<TITLE>CollectorsHighways.com - Fine Art - Art Research: Essays Archive: Hints for Database Searching</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- last updated: 08/09/2001 DSB -->
</HEAD>
<BODY BGCOLOR="#ffffff"><A NAME="Top"></A>
<!-- 6 X 4-->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" >
<!-- row 1: logo, banner ad, global navigation, path links -->
<TR>
<TD VALIGN="TOP" WIDTH="265"><IMG SRC="../../images/graydot.gif" WIDTH="265" HEIGHT="50" BORDER="0" ALT="logo space"><BR><font face="Arial, Helvetica, sans-serif" ><B><I>sponsorship message</I></B></font></TD>
<TD WIDTH="30" ><IMG SRC="../../images/onepixel.gif" WIDTH="30" HEIGHT="1" BORDER="0" ALT=""> </TD>
<TD VALIGN="TOP"><IMG SRC="../../images/graydot.gif" WIDTH="460" HEIGHT="50" BORDER="0" ALT="banner ad space"></TD>
<TD> </TD>
</TR>
<!-- row 2 -->
<TR>
<TD> </TD>
<TD COLSPAN="3" VALIGN="TOP">
<!-- horizontal table for global navigation links $$$$$$$$$$$$$$ -->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" >
<!-- 1 row with spacer-->
<TR>
<TD WIDTH="16"> </TD>
<TD VALIGN="TOP" WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1"> <A HREF="../../index.html">home</A> </font></TD>
<TD> </TD>
<TD WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1"> about us </font></TD>
<TD> </TD>
<TD WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1">contact us </font></TD>
<TD> </TD>
<TD WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1"> site map </font></TD>
<TD> </TD>
<TD WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1"> help </font></TD>
<TD> </TD>
<TD WIDTH="75" ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" size="+1">seller login</font></TD>
</TR>
</TABLE>
<!-- end horizontal table for global navigation links $$$$$$$$$$$$$$ -->
</TD>
</TR>
<!-- row 3: 5 areas of Fine Art Community to be added later: -->
<!-- PAINTING | DRAWING | SCULPTURE | PRINTS | PHOTOGRAPHS -->
<TR><TD COLSPAN="4"> </TD></TR>
<!-- -->
<!-- row 4: location path links, expanded left to right with drill-down -->
<TR>
<TD COLSPAN="4">
<!-- dynamic path links -->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" >
<TR>
<TD WIDTH="50"> </TD>
<TD><A HREF="../../index.html"><font face="Arial, Helvetica, sans-serif" size="-1"> Fine Art</font></A> / <A HREF="../index.html"><font face="Arial, Helvetica, sans-serif" size="-1">Art Research </font></A> / <font face="Arial, Helvetica, sans-serif" size="-1"><A HREF="index.html">Essays Archive</A><font face="Arial, Helvetica, sans-serif" size="-1"> / Hints for Database Searching </font>
</TD>
</TR>
</TABLE>
<!-- END dynamic path links -->
</TD>
</TR>
<!-- row 5: -->
<TR>
<TD ALIGN="LEFT" VALIGN="TOP" COLSPAN="4">
<!-- central area: %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
4 columns for links, content, marketplace, special feature -->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="755">
<!-- C O L U M N 1 111111111111111111111111111111111 -->
<TR>
<TD VALIGN="TOP" COLSPAN="3"><IMG SRC="../../images/onepixel.gif" WIDTH="605" HEIGHT="1" BORDER="0" ALT=""><BR><P>
<DIV ALIGN="CENTER"><font face="Arial, Helvetica, sans-serif" ><B>Essays Archive</B></font></DIV>
<P>
<!-- insert 1 X 3 -->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="605">
<TR>
<TD WIDTH="10%"> </TD>
<TD WIDTH="80%"> <P>
<font face="Arial, Helvetica, sans-serif" >
<B><P>Hints for Database Searching</P>
</B><P>By Susan Theran</P>
<P>Searching any of the Collectors Highway databases may be as simple as entering a word or name in a field and selecting the search button.</P>
<P>A more refined search may be conducted by searching on two or more fields.</P>
<P>If you searched the Artist Database for artists with the last name of Hopkins and the nationality American, the search results would show 56 artists whose surname is Hopkins, 174,104 American artists, but only the 11 artists who fulfill both requirements would listed.</P>
<FONT COLOR="#0000ff">
</FONT><P>
[ CHART GOES HERE ]</P>
<P>Using the principles of Boolean Logic<SUP>*</SUP> and the words "AND", "OR", and "NOT" permits more precise searches within a field.</P>
<B>
<P>AND</B> will narrow a search within a field to narrow a search. Symbols for AND are the word "and", an ampersand "&", a plus symbol "+", or a space between words. Use of the operator AND means all conditions must be fulfilled to get a match.<SUP>**</SUP> </P>
<B><P>OR</B> will broaden a search. It is particularly useful when you want to add a synonym. Example: cat or kitten. </P>
<B><P>NOT</B> is used when you want to exclude certain words from your search. Be careful when using the NOT operator as you may exclude items by mistake. Symbols are the word "not" or the minus sign "-".</P>
<P>If you were searching the marketplace ads for images of a red rose, the operators would show these results.</P>
<!-- USE Excel CHART but pick up overlapping circles form this HTML but
<A HREF="http://www.kzoo.edu/is/library/advanced_searching/boolean.html"><U><FONT COLOR="#0000ff">http://www.kzoo.edu/is/library/advanced_searching/boolean.html</U></FONT></A> </P> -->
<!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
<P> </P>
<CENTER>
<!-- site search box -->
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="1" >
<TR><TD>
<font face="Arial, Helvetica, sans-serif" > Site Search</FONT>
<FORM method="POST" ACTION="/FORMS/SRCHDEMO.CGI">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" >
<TR><TD> <INPUT NAME="searchterm" size="20" maxlength="30" value=" "></TD>
<TD VALIGN="BOTTOM"> <A HREF="results.html" ><IMG SRC="go.jpg" WIDTH="35" HEIGHT="17" BORDER="0" ALT="GO"></A></TD>
</TR>
</TABLE>
</FORM>
</TD></TR>
</TABLE>
<!-- END site search box -->
</CENTER>
</TD>
<TD WIDTH="10%"> </TD>
</TR>
</TABLE>
</TD>
<!-- C O L U M N 4 444444444444444444444444444444 -->
<TD VALIGN="TOP" >
<!-- Marketplace and Special Feature on right-hand side -->
<TABLE CELLPADDING="0" CELLSPACING="1" BORDER="0" >
<!-- 1st row -->
<TR>
<TD VALIGN="TOP" BGCOLOR="#dddddd" WIDTH="100" ALIGN="CENTER"><IMG SRC="../../images/onepixel.gif" WIDTH="100" HEIGHT="1" BORDER="0" ALT=""><BR><A HREF="../../marketplace/index.html"><font face="Arial, Helvetica, sans-serif" size="+1">marketplace</font></A><BR><BR><A HREF="../../marketplace/index.html"><IMG SRC="../../images/marketplace.jpg" WIDTH="65" HEIGHT="76" BORDER="0" ALT="mktplace"></A><BR><BR>
<font face="Arial, Helvetica, sans-serif" >See the latest<BR>exciting items<BR>in our listings!<BR><BR></FONT>
</TD>
</TR>
<!-- 2nd row -->
<TR><TD><IMG SRC="../../images/onepixel.gif" WIDTH="1" HEIGHT="30" BORDER="0" ALT=""></TD></TR>
<!-- 3rd row -->
<TR>
<TD VALIGN="TOP" BGCOLOR="#dddddd" ALIGN="CENTER"><BR> <font face="Arial, Helvetica, sans-serif" size="+1">special feature</font> <BR>
<IMG SRC="../../images/graydot.gif" WIDTH="65" HEIGHT="76" BORDER="0" ALT="special"><BR><BR>
<font face="Arial, Helvetica, sans-serif" >Today's items<BR>
headlines<BR>
more information<BR><BR></FONT>
</TD>
</TR>
</TABLE>
<!-- end top of right side-->
</TD>
</TR>
<!-- row 4 -->
<TR>
<TD COLSPAN="3"><CENTER><BR><BR><A HREF="HowToSearch.html#Top">To Top of Page</A><P>
<font face="Arial, Helvetica, sans-serif" size="-1"><A HREF="../../index.html">home</a> | about us | contact us | site map | seller login<BR>
privacy statement<BR>
(c) Collectors Highway, Inc., 2001<BR></font></CENTER></TD>
<TD VALIGN="TOP" >
</TD>
</TR>
</TABLE>
<TD>
</TR>
</TABLE>
<!-- end central area: %%%%%%%%%%%%%%%%%%%%%%%%%%%%% -->
</BODY>
</HTML>