using classic asp to search multiple forms

[John R]

I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File
Number. I am using sql server to store all the information, can anyone
please help. ?

[Ray Costanzo [MVP]]

I think many people can help, but I personally am unsure as to what kind of
help you need. What are you having trouble with?

Ray at home

"John R" <ad***@wirelesscybercafe.com> wrote in message
news:a4**************************@posting.google.c om...

I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File
Number. I am using sql server to store all the information, can anyone
please help. ?

[Jeff Cochran]

On 28 Nov 2004 17:06:21 -0800, ad***@wirelesscybercafe.com (John R)
wrote:

I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File
Number. I am using sql server to store all the information, can anyone
please help. ?

Sure. Create a form for the info, then query based on it.

Detailed help would naturally follow a detailed question.

Jeff

[Hal Rosser]

"John R" <ad***@wirelesscybercafe.com> wrote in message
news:a4**************************@posting.google.c om...

I am searching for a specific record based on different criteria:
First Name, Middle Name, Last Name, City, State, Zip Code, File
Number. I am using sql server to store all the information, can anyone
please help. ?

use the criteria to build a string into an SQL query - then run the query
The ADO recordset will contain the record if the eof and bof properties are
both false.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.799 / Virus Database: 543 - Release Date: 11/19/2004