My guess is that your recordset returns data from more than one long text column with one or more non-long text column in between. Check "PRB: 80020009 Error When Retrieving Data from SQL" (ID: Q175239).
HTH, Tore. -----Original Message----- From: Adrian Hoess [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 3:09 AM To: ActiveServerPages Subject: Problem with GetRows : Never encountered this one before Hi all This is a strange one ... I have opened a recordset and placed it into a local array using the getrows method. i seem to have missing values in the array which are present in the recordset. i loop through the rs, and print all the values out. no problem. i then call getrows and then loop through the array to print out the variables, and some values are missing. if i swap the fields around in the sql statement, additional elements in the array dissappear, or reappear. i can never get all the values in the recordset. -------------------------- here is the code: -------------------------- Set objRs = Server.CreateObject("adodb.recordset") objRS.Open strSQL, strConn , adOpenForwardOnly, adLockReadOnly, adCmdText if NOT (objRS.EOF) then while NOT objRS.EOF response.write objRS(0) & " : " response.write objRS(1) & " : " response.write objRS(2) & " : " response.write objRS(3) & " : " response.write objRS(4) & " : " response.write objRS(5) & " : " response.write objRS(6) & " : <br>" objRS.MoveNext Wend response.write("<br>") Dim arrResults arrResults = objRS.getRows Dim iRowLoop, iColLoop For iRowLoop = 0 to UBound(arrResults, 2) For iColLoop = 0 to UBound(arrResults, 1) Response.Write(arrResults(iColLoop, iRowLoop) & " : ") Next Response.Write("<p>") Next . . . -------------------------- here is the print out : -------------------------- SELECT articleID, templateID, sectionID, longTitle, shortContent, shortTitle, longContent FROM articlesLive INNER JOIN articleMeta ON (articlesLive.articleID = articleMeta.metaID) WHERE ((statusID = 3) AND (sectionID <> 1) AND (visible = 1)) AND (articlesLive.longContent LIKE '%annual reports%' OR articlesLive.shortTitle LIKE '%annual reports%' OR articlesLive.shortContent LIKE '%annual reports%' OR articlesLive.longTitle LIKE '%annual reports%') 7 : 6 : 4 : long title : short content : Annual Reports : long content : <--- RS 7 : 6 : 4 : long title : : : long content : <--- ARRAY -------------------------------- any ideas ?????!!!! Thanks Adrian --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
