<% Set cn = Server.CreateObject("ADODB.Connection") cn.Open = "Provider=SQLOLEDB;Server=SERVERNAME;uid=DBUSER;pwd=DBPASS;Database=DBNAME;" Set rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT misc3_realestate.by_affiliates.* FROM misc3_realestate.by_affiliates WHERE Website = 'X' ORDER BY misc3_realestate.by_affiliates.Company ASC" rs.Open SQL, cn %> Boyer Young | Omaha-area Land Development