ASP Tables + strange stuff

  • Thread starter Thread starter HenryW
  • Start date Start date
H

HenryW

I have a section of ASP code that dynamically builds a table. And per
usual it writes out to the table like so:

Response.Write("<td><font face=""Verdana"" size=""2""><b> Status
</b></font></td>")
Response.Write("<td><font face=""Verdana"" size=""2""><b> Description
</b></font></td>")

' make a couple of column headers

Do While Not objRS.EOF

Response.Write("<td><font face=""Verdana"" size=""2"">" &
objRS("chg_stat") & "</font>" & "</td>")
Response.Write("<td><font face=""Verdana"" size=""2"">" &
bjRS("co_desc") & "</font>" & "</td></tr>")

ObjRS.MoveNext

Loop

Response.Write "</table>"
'Clean up
'Response.Write "The Sql just executed was:: " &
"<br>" & strSql& "<br>" ' see the sql and check it in enterprise mngr

objRS.Close
Set objRS = Nothing
ObjConn.Close
Set objConn = Nothing


NOW THE PART THAT DRIVES ME CRAZY.

The actual code invloves alot more columns/rows and the recordset is
good size.
The problem is this:

Once I get 6 columns, no matter how I adjust the width, etc, I start
losing my data... a line that looks like this:

Response.Write("<td><font face=""Verdana"" size=""2"">" &
objRS("chg_stat") & "</font>" & "</td>")

and has data in the recordset element will (after column #6) result in

<td></td>

in the resluting html... I worked on this for 4 hours Friday. To
sanity check myself, I got 1 line of code working and then copied and
pasted so there are zero typos.

And again after 6 columns, the <td></td> started again with no data,
and you may rest assured my recordset object had data in those
variables at runtime....I know I checked.
I felt like I was losing my mind.
I'm also sort of new to ASP, and folks this is whipping me like
people whip a rented mule.

Any ideas at all?

TIA, most humbly.
 
Upgrade to ASP.NET and use the Table web control or better still a DataGrid
A
 
microsoft.public.inetserver.asp.general is the newsgroup you need to post
this question in. This is the ASP.Net newsgroup.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
Back
Top