Re: Witango-Talk: Smart Look up

Charles Brown Wed, 19 Feb 2003 10:16:53 -0800

OK, assuming I got the question right, here is a simple search, by selecting the first letter of first or last name, or by typing in first few letters of first or last name.The following goes in the <BODY> section of your HTML page. I just cut it from a search form. Clicking on a letter brings up all names starting with that letter. The letters and the input names (below the letter search) are set to "begins with" in the search action.

<FORM NAME="find_cust" METHOD="POST" ACTION="" onSubmit="return chkdte()">
<CENTER><TABLE BORDER=2 CELLSPACING=3 CELLPADDING=5 BORDERCOLOR="blue">
<TR VALIGN=TOP ALIGN=LEFT>
    <TD>
        <center>Search by starting letter of Last Name?<br>

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="A" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="B" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="C" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="D" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="E" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="F" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="G" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="H" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="I" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="J" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="K" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="L" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="M" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="N" ><br>

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="O" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="P" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="Q" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="R" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="S" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="T" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="U" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="V" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="W" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="X" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="Y" >

        <INPUT NAME="lname" TYPE=SUBMIT VALUE="Z" ></center> 
    </TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
    <TD>
        <center>Search by starting letter of First Name?<br>

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="A" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="B" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="C" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="D" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="E" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="F" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="G" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="H" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="I" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="J" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="K" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="L" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="M" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="N" ><br>

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="O" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="P" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="Q" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="R" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="S" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="T" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="U" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="V" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="W" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="X" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="Y" >

        <INPUT NAME="fname" TYPE=SUBMIT VALUE="Z" ></center> 
    </TD>
</TR>
<TR>
    <TD>
    <TABLE ALIGN="CENTER">
    <TR VALIGN=TOP ALIGN=LEFT>
        <TD>
            First Name Starts With . . .<BR>

            <INPUT NAME="fname1" TYPE=TEXT SIZE=20 MAXLENGTH=30 VALUE=""><BR><BR>

            And/Or . . . <BR><BR>

            Last Name Starts With . . .<BR>

            <INPUT NAME="lname1" TYPE=TEXT SIZE=20 MAXLENGTH=30 VALUE="">
        </TD>
    </TR>
    </TABLE>
    </TD>
</TR>
</TABLE>
<INPUT TYPE=SUBMIT VALUE="Find"> <INPUT TYPE=RESET VALUE="Reset Values">
</FORM>
</CENTER>

Jon van der Raadt wrote:

In our application, we need to be able to positively identify clients and, will not be able to use a pop-down list as there will be too many choices to make this practical. What we are interested in is being able to type a portion of the client's name and have the system display the records in the database that most closely match the entry. Perhaps just starting with the first typed letter or first few letters in a list or a list which includes closest matches...

Has any one worked on or created functionality like this?

Any comments/suggestions would be appreciated.

---
-Dhanashri

TeamOnly
Web Solutions

412, Alastair Ross Technology Centre
3553 - 31 Street NW
Calgary, Alberta Canada T2L 2K7

http://www.teamonly.net

Office: (403) 286-5586
Fax: (403) 286-5576

________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body

Re: Witango-Talk: Smart Look up

Reply via email to