Exclude a FieldItem from Recordset

[jon24422531]

Hi guys

I am trying to exclude a field from a table that is generated from a SQL recordset, however I wish to use the field items in the table as a "title". I have worked how to show (D) in the "title" bit, but I don't want the field (D) to appear in the table

So I have a recordset with fields A, B, C, D

<table class="sortable">
<tr>
<%
 for each fieldItem in rsData.fields
  Response.Write vbTab & vbTab &"<td bgcolor=""#EBDDE2"" title=""Click to Sort""><strong>" & fieldItem.name
  Response.Write "</strong></td>" & vbCrLf
 next
  Response.Write vbTab & "</tr>" & vbCrLf
%>
</tr>
<%

Do While not rsData.EOF
 Response.Write "<tr>"
 for each fieldItem in rsData.fields
  if fieldItem.name = "A" then
 Response.Write "<td>&nbsp;<a href=""WorkLogOpenDetail.asp?id=" & fieldItem.Value & """ title=" & rsData.fields.item("D").Value & """>" & fieldItem.value & "</a></td>"
  else
 Response.Write "<td><small>&nbsp;" & fieldItem.value & "</small></td>"
  end if
 next
 Response.Write "</tr>"
 rsData.MoveNext
Loop
%>
</table>
<%end if%>

Many thanks

Jonathan

http://www.telecom-stuff.com