Here is the code:<BR><BR>Dim sSQL<BR>Dim oConn<BR>Dim oRs<BR>Dim aItem<BR><BR>sSQL = "select Name,Desc,SellPrice from Products where Department=&#039;DVDs&#039;;"<BR><BR>Set oConn = Server.CreateObject("ADODB.Connection")<BR>oConn.O pen "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & DB_PATH<BR><BR>Set oRs = Server.CreateObject("ADODB.Recordset")<BR>oRs.Curs orLocation = 3 &#039;adUseClient<BR>oRs.CursorType = 3 &#039;adOpenStatic<BR>oRs.CacheSize = 6<BR>oRs.PageSize = 6<BR>oRs.Open sSQL, oConn<BR>oRs.AbsolutePage = 1<BR><BR>aItem = oRs.GetRows<BR><BR>As it is, aItem gets all the records from the query. The same is true if I use GetString.<BR><BR>What am I doing wrong?<BR>