p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: Search SQL Database


Message #1 by "Mark Owen" <mowen@p...> on Thu, 1 Mar 2001 05:57:29
I will give it a try. Thanks for the assistance.

Marko

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Friday, March 02, 2001 2:24 AM
To: How To
Subject: Re: Search SQL Database


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I am currently using a recordset to link an <option> frop down list. I
: need to know if there is a way to use a text box instead of the <option>
: list
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

So get them to type in a few letters...and submit the form, and execute an
SQL query;

SELECT field1, field2, field3...fieldn
FROM table1
WHERE field1 LIKE '%" & strSearchCriteria & "'"

and put that into an ADO recordset for display on the screen...

The other option that you listed (the user being able to type in a few
letters and all the records matching would automagically appear is not
possible using just HTTP - since the Web is stateless - as soon as the
server has sent the webpage to the client, it forgets all about it. Unless
you use something that maintains a persistant connection (ActiveX control,
or Java applet) you need to resubmit the form.

HTH

Cheers
Ken



  Return to Index