Hi Janine, If you're using oracle, there's a great way around this (and I'd assume sql server has something similar). Use the nvl function in your query like so: SELECT nvl(columnname, 0) FROM yourtable.
nvl basically replaces nulls with something else. The only caveat is that the replacement must be of the same datatype as the original column. So, if you don't want zeros to show up for a number column, you'd have to do a replace in your cfoutput to replace the zeros with "null" or something similar. Hope that helps. -Deanna Deanna Schneider Interactive Media Developer [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
