force Search Page to return no records on open

Expand Post »

I have a page that is primarily designed to search the database for all entries within the entered state.

I'd like to open the page with no results being returned in the results form. Currently when the page is loaded it returns all the records in the db.

Here is the select statement:
"SELECT * FROM National WHERE (State like '%:

earchValue::%') ORDER BY State ASC"

Similar Threads

Internet Explorer could not open the search page. maybe some type of dns error? in Web Browsers
Inetrnet Explorer could not open the search page after SP2 install in Web Browsers
Search a word, return the line in C++
Display Search Results as Hyperlinks to Records in ASP
IE "can not find the search page" in Web Browsers

ymcapa

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2004

Permalink

May 24th, 2004

Re: force Search Page to return no records on open

So you want a query that returns zero results? If so, does that SQL statement have to remain unmodified? Please be a tad clearer. Thanks!

samaru

Team Colleague

Reputation Points: 262

Solved Threads: 18

a.k.a inscissor

Offline

1,227 posts
since Feb 2002

Permalink

May 24th, 2004

Re: force Search Page to return no records on open

Quote originally posted by inscissor ...

So you want a query that returns zero results? If so, does that SQL statement have to remain unmodified? Please be a tad clearer. Thanks!

I wanted the results to be empty when the user first loads the page so that they can then search for the info they desire. I solved the problem in the hyperlink instead of the SQL statement by adding "?searchvalue=ST" to the end of the url.

Since no state has the abbreviation "ST" this returns empty results on load.

here is the page in question if you want to look: www.ymcayg.org

ymcapa

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: ASP Replace Function....

Next Thread in ASP Forum Timeline: Error including Parent directory files

DaniWeb Message

Cancel Changes

User Name
Password