' Database #1
Set conDB1 = Server.CreateObject("ADODB.Connection")
' Open the Database
conDB1.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\ussdavidson.com\data\crewmembers.mdb"
' Make the SQL Query
strName = "A"
If Request.QueryString("Name") <> "" then strName = Request.QueryString("Name")
SQL_Members = "SELECT * FROM crew WHERE txtLname LIKE '" & strName & "%'"
' Execute the SQL Query and load it into a recordset
Set rsCrew = conDB1.Execute(SQL_Members)
Welcome to the USS Davidson Reunion Website - Dedicated to the memory of the ship and the officers and men who sailed her.