I have a View Created in SQL Server 7.0 that joins about 8 tables. When I browse the view I am able to see all the fields.
But When I try Selecting Data from the View using asp two of the fields are not being displayed. I tried displaying all the field names from the list but the fields are not being displayed in the list, so apparantly the fields are accessible why is that.
The query is as follows:
SelInfo = "Select * from EmdData where staff_number='"&strEmployee_no&"'"
The fields I am trying to access are ; emplevel & emplevelid
Any help would be greatly appreciated