nicks60610
MIS
I have a query from which I am pulling data from 4 tables, but the problem I have now is that in 2 of the tables, I am using 2 fields which have identical names;
WO_WORK_ORDER.DESCRIPTION and SY_WO_STATUS.DESCRIPTION. They are two different fields, but both are text fields. Now when I do my table and display the results, how can I separate the two fields?
<%=Server.HTMLEncode(rs.Fields("WO_BASE".Value)%>
<%=Server.HTMLEncode(rs.Fields("PLANNER".Value)%
<%=Server.HTMLEncode(rs.Fields("EMPLOYEE_ID".Value)%
<%=Server.HTMLEncode(rs.Fields("EQUIPMENT".Value)%
<%=Server.HTMLEncode(rs.Fields("REQUESTOR".Value)%
<%=Server.HTMLEncode(rs.Fields("DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("LONG_DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("SHIFT".Value)%><BR></FONT></TD>
Thanks in advance!!
WO_WORK_ORDER.DESCRIPTION and SY_WO_STATUS.DESCRIPTION. They are two different fields, but both are text fields. Now when I do my table and display the results, how can I separate the two fields?
<%=Server.HTMLEncode(rs.Fields("WO_BASE".Value)%>
<%=Server.HTMLEncode(rs.Fields("PLANNER".Value)%
<%=Server.HTMLEncode(rs.Fields("EMPLOYEE_ID".Value)%
<%=Server.HTMLEncode(rs.Fields("EQUIPMENT".Value)%
<%=Server.HTMLEncode(rs.Fields("REQUESTOR".Value)%
<%=Server.HTMLEncode(rs.Fields("DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("LONG_DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("DESCRIPTION".Value)%
<%=Server.HTMLEncode(rs.Fields("SHIFT".Value)%><BR></FONT></TD>
Thanks in advance!!