Search db by Field
Providing search capabilities to a db enables users to query on whichever element you target them to. However allowing users to target which portion of the db they would like to query gives extra value. In this example, utilizing our db of US States (state, statename, and capital) the user can search in any of three fields (by dropdown menu input) rather than the application targeting one specific table element. Note: The db only has 50 observations in it, so it is better to search on single or double letter combinations.
- Visit Site:
- Search db by Field
- Filed in:
-
ASP / Tutorials & Tips / Database-related
- Date Added:
- Jun 26, 2000
- Last Updated:
- Jun 26, 2000
License and Pricing Information
| Publisher site visits: | 2,438 |
|---|---|
| Average rating: | 2.33 |
| Total ratings: | 3 |
Publisher Info
- Author:
Other listings by this publisher
- Vote/User Poll (With a db and IP Capture)
- Impression Counter (With a db)
- ASP Hit Counter
- Simple Table Display With Where Clause (Hard Coded)
- Access Article Db
- Write and Read A Cookie
- Two Table Join
- Form Dates
- 404 Error Page (CDONTS)
- JavaScript Image Click ScriptWriter
- Disk Space Usage
- Multiple Form Selection
- Search Within Search Results
- Mail A Link
- Multiple Form Selection (Where In)
- Color Safe Palette or Nested For Next Loops & Arrays
- Print View (From a db template)
- Simple Database Input and Display
- Select All Text
- Search Many Sites from One Location
- Alert Box
- Confirm Alert Box
- Output To MSExcel
- Search Database
- CodeAve.com
- Count Click Throughs (With a Db)
- Access To HTML
- ASP Session Counter
- Import CSV to HTML
- Date Dependent Content
- ASP Cookie Writer
- MouseOver Pop-Up Windows
- Link & Display Text Files
- SQL: Sum, Average, Max, Min, Count, Detail
- String Functions (Len, Left, Mid, Right)
- Financial Graph
- Display an Excel DB
- ASP Form Input to HTML
- Name Search & Hyperlinks to Detail
- Display Table Script Writer
- Create Excel on the Server
- Framed Click Through
- 404 Error Page (With a Db an IP Capture)
- Date Last Modified ScriptWriter
- Create Excel from Form Input
- Create XML Documents from Access Output
