Hello, I am creating a auction site. I am using VBscript, and SQL Server.

I have set up an SQL table named "items" and now i want to set up a

keyword search so people can search the table for what they want to buy. 

I want people to be able to search by title.  The titles for the all items

will exsist in the "title" column of the table "items". I would like to

use a stored procedure to increase performance. After the user enters in

there keywords and searches i then want to page the records 25 or 50 at a

time (user definable on the search page). On the results page there will

be a table displaying the search results and giving information about each

matching record such as ending time, number of bids, and current price. I

really dont even know where to start on this. That is why i have emailed

everyone who knows anything about the subject to try to get some ideas.



Thanks

Brad

ASP Today  7/20/1999 very good article titled "Forms Driven Queries" will

get you started. ASP Free also has some good information to help you define

your approach and example code to help you start.



-----Original Message-----

From: Brad Libby [mailto:libby_brad@b...]

Sent: Wednesday, September 27, 2000 5:55 PM

To: ASP Databases

Subject: [asp_databases] SQL keyword search





Hello, I am creating a auction site. I am using VBscript, and SQL Server.

I have set up an SQL table named "items" and now i want to set up a

keyword search so people can search the table for what they want to buy.

I want people to be able to search by title.  The titles for the all items

will exsist in the "title" column of the table "items". I would like to

use a stored procedure to increase performance. After the user enters in

there keywords and searches i then want to page the records 25 or 50 at a

time (user definable on the search page). On the results page there will

be a table displaying the search results and giving information about each

matching record such as ending time, number of bids, and current price. I

really dont even know where to start on this. That is why i have emailed

everyone who knows anything about the subject to try to get some ideas.



Thanks

Brad