Text data in a table not populating correctly

marydn · Jun 21, 2002

I am trying to take data from a database and fill up a table in a row, column format. Instead of getting:

Reg Proj Ter Comments
a b c d
e f g h

I get:
Reg Proj Ter Comments
a b c d e f g h

Here is the code.....Can anybody help meeeeeeeeeee........

<HTML>
<BODY>

<%
Dim objRS
Set objRS=Server.CreateObject ("ADODB.Recordset&quot

objRS.Open "BTSCurrentActivity",objConn,,,adcmdTable
%>

<TABLE>
<CAPTION>
BTS Current Activity Report (Edit Mode)
</CAPTION>

<TR>
<TH>Region</TH>
<TH>Project Name</TH>
<TH>Territory</TH>
<TH>Originally Awarded</TH>
<TH>Anchor Tenant Rent Year One</TH>
<TH>AnchorTenant Rent Year Three</TH>
<TH>Comments</TH>
</TR>

<%

Do While Not objRS.EOF
Response.Write "<TD><input type=text name=Reg
value=" & objrs("Region&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg
value=" & objrs("ProjectName&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg
value=" & objrs("Territory&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg
value=" & objrs("OriginallyAwarded&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg
value=" & objrs("AnchorTenantRent1&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg
value=" & objrs("AnchorTenantRent3&quot

& "</TD>"
Response.Write "<TD><input type=text name=Reg v
Value=" & objrs("Comments&quot

& "</TD>"
objRS.MoveNext
loop
objRS.Close
Set objrs = Nothing
objconn.close
Set objconn = Nothing
%>
</TABLE>
</BODY>
</HTML>

THANKS!

FengShui1998 · Jun 21, 2002

marydn,

You need "<tr>" and "</tr>" to denote rows.

fengshui_1998

marydn · Jun 21, 2002

Thanks FengShui,

I actually realized that after I submitted the post,errrrr. I have a new problem - the </TD> shows up as part of the data. For example, KS/NE</TD. But only for some of the fields - any help would be wooonderfullllll!!!

Thanks!

FengShui1998 · Jun 21, 2002

marydn,

Can you show your code, please?

Thanks,

fengshui_1998

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Text data in a table not populating correctly

marydn

Programmer

FengShui1998

MIS

marydn

Programmer

FengShui1998

MIS

Similar threads

Part and Inventory Search

Sponsor