Controlling field sizes of a table created with response.write

Hi,
I am pulling all the fields from a table from a sql server database. The
fields are being displayed with the following code:
Response.Write "<TABLE BORDER=1>"
Do While Not rs.EOF

Response.Write "<TR><TD>" & rs("RoomID") & "&nbsp;</TD>"
Response.Write "<TD>" & rs("Type") & "&nbsp;</TD>"
Response.Write "<TD>" & rs("Smoking") & "&nbsp;</TD>"
Response.Write "<TD>" & rs("Capacity") & "&nbsp;</TD>"
Response.Write "<TD>" & rs("Rate") & "&nbsp;</TD></TR>"
rs.MoveNext
Loop
Response.Write "</TABLE>"

However, the fields are displayed with field size at its minimum. I am
trying to find out if it is possible to tweak the above code so that one can
controll the individual field spacing. Any help is appreciated in advance.
Thanks.
.

Relevant Pages

  • Cannot find column XXXX
    ... I am used to use MS Access to view a SQL Server database table. ... Microsoft Office Access can't open the table in Datasheet view ... How can I get rid of the message? ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Query returning 1.7million records slow
    ... >When I run select * from tablename it can take over 5 minutes. ... only want certain rows then I would adjust the query ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Copy Project in Visual Studio - datasets missing
    ... uses a back-end SQL Server database and has a lot of datasets. ... The problem is that Visual Studio copies everything to the new project ... EXCEPT all of the datasets are missing. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Microsoft Access DB Driver for JDBC
    ... no i'm a student and the ms sql server database is regarded the holy ... grail around here ... Prev by Date: ...
    (comp.lang.java.programmer)
  • How to retrieve only new rows?
    ... Hello I want to retrieve only new rows from my sql server database to be ... processed in XML Files. ... Prev by Date: ...
    (microsoft.public.biztalk.general)
Loading