|
|
|
|
|
Total Hits: 587 | Today: 0 |
Author: Greg Gurath
|
Rating:
|
|

Code for parsing search strings (AND, OR, NOT, NEAR and quotes) for Microsoft SQL Server and other SQL servers that accept that syntax....
|
|
|
|
Total Hits: 1304 | Today: 1 |
|
Rating:
|
|

If you have a database you'll want to be able to do searches against the records you have in it. With this script you can base your search on either a single field or all your table fields....
|
|
|
|
Total Hits: 1191 | Today: 0 |
|
Rating:
|
|

This is a quick and dirty script that checks to see if a user exists in a database before inserting the record. The script also doesn't allow for empty form values. If either one of the cases are true, the user is redirected to the sign-in page....
|
|
|
|
Total Hits: 343 | Today: 0 |
|
Rating:
|
|

Want to add value to your current search? Allow your users to search from within search results. As databases grow the necessity for the user to continually narrow a search to the item that they truly want will grow also....
|
|
|
|
Total Hits: 877 | Today: 1 |
|
Rating:
|
|

The code below prints the first name from the table labeled "Publishers" where the first name contained the letter "J". The "%" is the equivalent of a wildcard...
|
|
|
|
Total Hits: 583 | Today: 0 |
Author: Johannes J. Burger
|
Rating:
|
|

Searching a Database (SQL Server), on 2 datefields. Using 2 Database fields in a search query. How to search for overlapping date fields....
|
|
|
|
Total Hits: 675 | Today: 0 |
Author: ASPxtreme
|
Rating:
|
|

This article is about how to retrieve and update information stored in databases, Using SQL to query and return search results and ADO Find Method....
|
|
|
|
Total Hits: 1172 | Today: 0 |
Author: ASP101
|
Rating:
|
|

A sample of how to search a DB for certain records. It's really no different then doing any other query except that you need to use wildcards....
|
|
|
|
Total Hits: 922 | Today: 0 |
|
Rating:
|
|

It's one thing to list your records in ascending or descending order on your web page, but how about letting the user sort your records the way they want? Let's say you are displaying a list of users on your page and you want to display all of the first and last names....
|
|
|
|
Total Hits: 2026 | Today: 0 |
|
Rating:
|
|

When the form is sent (to the same page actually), we open a Recordset using SQL to select the record whose values in the lookup fields (UserEmail and Password) equally match the given strings....
|
|
|
|
Total Hits: 1414 | Today: 0 |
|
Rating:
|
|

This sample code answers the call for for a sample of how to search a DB for certain records. It's really no different then doing any other query except that you need to use wildcards....
|
|
|
|
Total Hits: 751 | Today: 0 |
|
Rating:
|
|

It searchs all database for the keywords which you have written. It can search in every field, every table....
|
|
|
|
Total Hits: 1296 | Today: 0 |
|
Rating:
|
|

This tutorial creates a search utility designed to show you the basics behind doing a simple database search using ASP. If you just want to download it, change the data in the Access database, make a DSN called "Employees," and use it....go for it!...
|
|
|
|
Total Hits: 697 | Today: 0 |
|
Rating:
|
|

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....
|
|
|
|
Total Hits: 597 | Today: 1 |
|
Rating:
|
|

It is a simple search utility designed to show you the basics behind doing a simple database search using ASP. If you just want to download it, change the data in the Access database, make a DSN called "Employees," and use it....go for it!...
|
|
|
|
Total Hits: 312 | Today: 0 |
|
Rating:
|
|

This article, by Jerry Wood, shows a nifty little script, which, with just one ASP page, allows you to dynamically search a column in a table using a string comparison....
|
|
|
|
Total Hits: 446 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|

In this article we will see on how to search the database for a group of records. Searching a database is very easy and fun provided you know how to do it....
|
|
|
|
Total Hits: 713 | Today: 0 |
|
Rating:
|
|

I wrote this for my company's intranet to display a search for our standard operating procedures. It will search a table in my database that contains SOP titles and is multi-word capable. It will also display the results as hyperlinks to htm files containing the SOP's....
|
|
|
|
Total Hits: 651 | Today: 0 |
Author: Adam Ware
|
Rating:
|
|

I have created a generic database search page for any database. The page dynamically populates a drop down list with database columns names then which users can search, the page also displays a generic database values....
|
|
|
|
Total Hits: 821 | Today: 0 |
Author: Natalia Babkina
|
Rating:
|
|

Step by step giving the instruction how to: - browse for table names in any database; - browse for column names in any table any database; - use a variable in query string instead of complicated functions and encoding....
|
|
|
|
|
|
|