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]
