Enter * to display all - DB.R.W. Search Form

  • Thread starter Thread starter bfiser
  • Start date Start date
B

bfiser

I have a database results wizard search form built. My search works
great when data is input. However what I need to do is give an option
to "Click a button" to display all data or "Input a *" to display all
records. How can I do this?
Thanks,
Ben
 
I have a database results wizard search form built. My search works
great when data is input. However what I need to do is give an option
to "Click a button" to display all data or "Input a *" to display all
records. How can I do this?
Thanks,
Ben
Click to expand...

I found that, when I built a search function (site below), entering % would
return all records.

I didn't have to do anything, except add this text to infrom the visitor:
<p>Search by Name<br />
(% returns all)<br />
(Blank resets page)</p>

I am not sure whether I built this using the DBRW or not.

The search query is:
strSQL = "SELECT * " _
& "FROM Results " _
& "WHERE name LIKE '%" & Replace(strSearch, "'", "''") & "%' " _
& "ORDER BY Timestamp, name;"
where strSearch is an ASP variable input from the form

I don't know whether this helps or not
--
Cheers,
Trevor L.
[ Microsoft MVP - FrontPage ]
MVPS Website: http://trevorl.mvps.org/
----------------------------------------
 
Back
Top