Hi,
I have opened a recordset with "SELECT * from Table"
There are 56 fields in this table.
While accessing the values of all the fields in the recordset by the
name of the field
e.g.
rsPatients.Fields("PlateID").Value
rsPatients.Fields("CURRENT_PLATE").Value
the values after the 30th or so field do not exist. However if I
iterate through the Fields collection, the values for all the fields
are there. I have also tested the query in Query Analyzer and the
record is returned correctly with all the values.
Why is this?
Roslyn
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM
--------------------------------------------------------------------~->
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
