formatting a cell with null value

Hi all,

I wasn't sure which forum to post this in but it's really a formatting question so I decided to post here. I am using coldfusion and sql server to create a project log, but using dreamweaver/html to make it look good.

I have a sql query that displays all the data from a table. I am outputting this list to the user in a table with a border value of 1. If there is a data cell that is empty (null) then it leaves a big hole in my output table - i.e. there is no border around the cell and there are big ugly gaps displayed. Does anyone know how to code the following pseudocode "if cell value in any field is null then output  ".

thanks!
melissa

You can't do this in the display for the whole table at once, but within any cell you could do something like:



Or you can take the easy way out and just always output a space after the value, like:

#myQuery.myColumn# 

Sweet! I didn't realize you could do this - thanks so much!