populating a table with two cells/row using 1 db field

[mww22]

I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it....
<%
Do While Not objRS.EOF
Response.Write &quot;<TR>&quot; & VBCRLF & &quot;<TD width=% align=center valign=middle border=1>&quot; & VBCRLF
Response.Write VBTAB & &quot;<A href=whatever.asp?TA_ID=&quot; & objRS(&quot;lngTopicAreaID&quot & &quot;&TA=&quot; & Server.URLEncode(objRS(&quot;strTopicArea&quot) & &quot;>&quot;
Response.Write objRS(&quot;strTopicArea&quot
Response.Write &quot;</A>&quot; & VBCRLF & &quot;</TD>&quot; & VBCRLF & &quot;</TR>&quot; & VBCRLF
objRS.MoveNext
Response.Write &quot;<TD width=% align=center valign=middle border=1>&quot; & VBCRLF
Response.Write VBTAB & &quot;<A href=joe.asp?IW_ID=&quot; & objRS(&quot;lngIndexWordID&quot & &quot;&IW=&quot; & Server.URLEncode(objRS(&quot;strIndexWord&quot) & &quot;>&quot;
Response.Write objRS(&quot;strIndexWord&quot
Response.Write &quot;</A>&quot; & VBCRLF & &quot;</TD>&quot; & VBCRLF & &quot;</TR>&quot; & VBCRLF
objRS.MoveNext

Loop
Call DBClose()
%>
It ends up throwing an exception error # 0x80020009
If anybody has any suggestions on how to do what I want to do, I would appreciate it.
Thanks in advance,
MWW22

 

[mww22]

Correction to the error I made
I would like to know how to populate a table with the contents of a 2 field table in SQL. The way that I thought would work isn't.... Anyway here is the code I wrote to do it....
<%
Do While Not objRS.EOF
Response.Write &quot;<TR>&quot; & VBCRLF & &quot;<TD width=% align=center valign=middle border=1>&quot; & VBCRLF
Response.Write VBTAB & &quot;<A href=whatever.asp?TA_ID=&quot; & objRS(&quot;lngIndexWordID&quot & &quot;&TA=&quot; & Server.URLEncode(objRS(&quot;strIndexWord&quot) & &quot;>&quot;
Response.Write objRS(&quot;strIndexWord&quot
Response.Write &quot;</A>&quot; & VBCRLF & &quot;</TD>&quot; & VBCRLF & &quot;</TR>&quot; & VBCRLF
objRS.MoveNext
Response.Write &quot;<TD width=% align=center valign=middle border=1>&quot; & VBCRLF
Response.Write VBTAB & &quot;<A href=joe.asp?IW_ID=&quot; & objRS(&quot;lngIndexWordID&quot & &quot;&IW=&quot; & Server.URLEncode(objRS(&quot;strIndexWord&quot) & &quot;>&quot;
Response.Write objRS(&quot;strIndexWord&quot
Response.Write &quot;</A>&quot; & VBCRLF & &quot;</TD>&quot; & VBCRLF & &quot;</TR>&quot; & VBCRLF
objRS.MoveNext

Loop
Call DBClose()
%>
It ends up throwing an exception error # 0x80020009
If anybody has any suggestions on how to do what I want to do, I would appreciate it.
Thanks in advance,
MWW22