>Set adoRecordSet = Server.CreateObject("ADODB.Recordset") >Set adoSQL = Server.CreateObject("ADODB.Connection") >adoRecordSet.Source = "SELECT myfield1 AS Expr1, myfield2 AS Expr2, myfield3 AS Expr3 FROM mytable" >strConnection = "DSN=Visual FoxPro Tables;SourceDB=f:\mydirectory" >adoRecordSet.ActiveConnection = strConnection >adoRecordSet.CursorType = 1 >adoRecordSet.LockType = 3 >adoRecordSet.Open >>And here is where I actually use the data:
>Select Case adoRecordSet.Fields("Expr1") > Case True > Response.Write "Something" > Case Else > Response.Write adoRecordSet.Fields("Expr1") > Response.Write "Something Else" >End Select > >Select Case adoRecordSet.Fields("Expr2") > Case True > Response.Write "Another thing" > Case Else > Response.Write adoRecordSet.Fields("Expr2") > Response.Write "Another other thing" >End Select > >Response.Write "Active=" & adoRecordSet.Fields("Expr3") >>Thanks