•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 392,080 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,040 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 3274 | Replies: 2
 |
•
•
Join Date: May 2004
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
force Search Page to return no records on open 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"
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" 
•
•
Join Date: Feb 2002
Location: Long Island, NY
Posts: 1,134
Reputation:
Rep Power: 12
Solved Threads: 2
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!
•
•
Join Date: May 2004
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
Linear Mode
•
•
•
•
adult advertising agplv3 ajax asp business coding dell developer development dom drivers engine feed firefox google internet legal linux marketing microsoft mozilla msn news office open open source open-source operating os reader red hat revenue search security sex software source sun super system ubuntu vista weather web wiki windows xml xoap yahoo
- Display Search Results as Hyperlinks to Records (ASP)
- search in page (PHP)
- Need Help Creating a Search Page (ColdFusion)
- IE "can not find the search page" (Web Browsers)
- Inetrnet Explorer could not open the search page after SP2 install (Web Browsers)
Other Threads in the ASP Forum
- Previous Thread: ASP Replace Function....
- Next Thread: Error including Parent directory files
