Thanks for the info & help! Bill Lammey Product Manager Knowledge Express http://www.knowledgeexpress.com (610) 783-4500 ext. 23 (800) 529-5337
-----Original Message----- From: Bill Lammey [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 3:08 PM To: ActiveServerPages Subject: getrows() limitations? 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.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
