I have a query running against an Oracle table that uses ASP to return the rows to a table. Empty columns do not have a border in the table, however. In a different application (PHP/MySQL) I was able to work around this by inserting a non-breaking space in the table. That isn't working for this one, however. I also tried inserting a transparent GIF spacer, but that doesn't work, either. I'm using DW MX and IE 5.5 (standard browser for my company). Here's the code:

<table width="90%" border="1" cellspacing="0" cellpadding="0">
<tr>
<th><font size="-1">Acquired Company Code</font></th>
<th><font size="-1">Acquired Company Text</font></th>
</tr>
<%

Dim dbgCount

dbgCount=0

Do Until rsCACS.EOF
Response.Write("<tr>"
Response.Write("<td class=oratables>" & rsCACS("CACS_CMPY_CD".Value & "</td>"
Response.Write("<td class=oratables>" & rsCACS("CACS_CMPY_TX".Value & "</td>"
Response.Write("</tr>"

dbgCount=dbgCount+1

rsCACS.Movenext

Loop

rsCACS.Close

Set rsCACS = nothing
Set objCnn = nothing
%>
</table>

Any suggestions?

Adding a transparent gif to the offending cells should work - that's how I'd do it. What does your code look like when you try the non-breaking space or xparent gif methods? Perhaps it's your syntax.

Ned Frankly
www.nedfrankly.com
You think I ramble on HERE?

Edited by - NedFrankly on 01 Nov 2002 20:20:23

er, I've been juggling too much this week and forgot I never could get the syntax down! If I want to add an image called 'spacer.gif', where/how does it go here?

Response.Write("<td class=oratables>" & rsCACS("CACS_CMPY_CD".Value & "</td>"

If your 1x1 xparent gif is called 'spacer.gif' and is located in your images folder:

Response.Write("<td class=oratables>" & rsCACS("CACS_CMPY_CD".Value & "<img src='images/spacer.gif'></td>"



Ned Frankly
www.nedfrankly.com
You think I ramble on HERE?

why don't you just use CSS for the borders? they'll work irrespective of the content inside the cell.

------------------------
Julio

PHP | MySQL | UD4

ICQ: 19735247

I updated the existing 'oratables' class and specified border width and color, but there was still no border for existing cells. The syntax supplied by NedFrankly, however, did the trick. Thanks for the assistance!