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

 

[Jeff Cochran]

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]

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.