Results 1 to 7 of 7

Thread: How would i...

Threaded View

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2003
    Posts
    9

    How would i...

    I want to create a search box, where users can enter a name, and it searches the database and displays. the form tag is

    <form runat="server" name="form1" method="post" action="search2.asp">

    in search2.asp i put the SQL as

    Code:
    SQLString = "SELECT * FROM Clients WHERE Request.Form("surname")=surname ORDER BY clientID ASC "
    Am i doing something really silly and wrong?

    Plus, in future i'd like to create a thing, where the user can select what field he'd like to search in aswell, and advice?

    Thanks in advance
    Last edited by Bubbles_; Mar 31st, 2003 at 11:06 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width