table display looks funny without data when query executes

[kodjo]

Is there any snippet that I could use to correct a table's cell appearance if there are no records in them? They look very untidy if the database does not fill it with any data during a query execution.

[Ribeyed]

hi,
yes you can do this:

<%

if RS("field") = "" then

response.write "& nbsp;"

else

response.write RS("field")

end if

%>

Hope this helps. take out the space between & and nbsp couldn't write correctly because it wouldn't show up in the example.