There are some limitations to GetRows, and you have come across one of them. My suggestion is to:
[] use binded fields [] use CacheSize [] either use ADODB.Stream or use the GetChunk() method of the Field object I have some examples of all of these here: http://www.davidpenton.com/testsite/datafetch/ David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Bill Lammey [mailto:[EMAIL PROTECTED]] Howdy all, I'm having a strange problem with a query only returning partial data. It's a table with over 42 columns, some of them of type text. I'm selecting only 42 of the fields, and I structure the query so that the text fields are selected last, and in order. Using getrows populates an array (41x0) with some but not all of the text type fields empty, and the last one full. Figured my problem was of the text field order type, but I'm sure I'm selecting them in order. Here's the real surprise, when I build an array from the recordset by hand using the following code, it looks just like the result of getrows(), but WITH THE MISSING DATA! Is this something that I should have expected or is this a problem with getrows() that might be new? heres the relevant code; (I'm using Win2K with all the latest and IIS5, with the .NET sdk installed (hope that isn't the cause!) but these are plain old .asp files.) ... set rsRecord = cnData.execute(Query) iRow = rsRecord.Fields.Count recordInfo = rsRecord.getrows '<-----Bad Guy dim RecordInfo2() redim RecordInfo2(iRow - 1, 0) rsRecord.movefirst d = -1 for each fld in rsRecord.fields d = d + 1 scratch = fld.Value RecordInfo2(d, 0) = trim(scratch) '<-----Good Guy (after loop) next ... A few searches here and there turned up no weaknesses or size limitations on getrows, I'll continue to keep looking... Thanks in advance for reading this overly long post... "Will the highways on the Internet become more few?"- GW Bush, Concord, N.H., Jan. 29, 2000 --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
