Hello everyone-

I'm a newbie to web design and have a project I'm working regarding a simple search within an access database using asp hosted at an ISP.

From what I have read, it should be a piece of cake but I haven't been able to find an example I can easily learn from. I just can't seem to display the results from the results page. Also, I am looking for the user to enter a text string once searching two fields in a single table, i.e., First Name and Last Name but after playing with the SQL statements, I'm not sure how to formulate it.

I've configured a DSN-less connection and can get the code to show me everything in the table but not much else.

The project is for a contact database for a Chamber of Commerce. Once the user visits the site, based on a search for an agent name, company name, and/or category, the results page should return the entire line of data including the company's address and phone number. If the fields are left blank, then Id like for everything in the database to be returned.

I'm 100% sure my inexperience in this arena is making this much harder than it needs to be. I've hit my head on the wall hundreds of times over the course of the last 2 weeks.

Any assistance is very much appreciated.

Thanks.