Hi Roslyn,
> 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.
Not all field types respect the Value property. Do you have a create
table sample for us that demonstrates the types of each of the fields?
Some fields (long text and binary, for example) will only 'return'
from the recordset a single time. If you want to do anything with the
value you must store it in a variable the FIRST time you reference the
field. Wrong:
If rs("fieldname") & "" <> "" Then
Response.Write rs("fieldname")
End If
Right:
myField = rs("fieldname")
If myField & "" <> "" Then
Response.Write myField
End If
> However if I iterate through the Fields...
I imagine the actual code to be different in your iteration versus
your 'by name' code - probably due to not assigning the contents to a
variable or having a 'funky' named field.
Regards,
Shawn K. Hall
http://ReliableAnswers.com/
'// ========================================================
Let me explain...no, there is too much. Let me sum up;
-- 'Inigo', The Princess Bride
------------------------ 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/
