% Const adOpenForwardOnly = 0 Const adLockReadOnly = 1 Const adCmdTable = 2 dim info Set info = Server.CreateObject ("ADODB.Recordset") strSQL = "SELECT * FROM Veterans where id = " & Request("link") & "" info.Open strSQL, connstr, adOpenStatic, adLockReadOnly, adCmdText %>