Hey everyone,
I have two separate views that pull numeric data from a table using
SQL. I am looking to add the two together in another view before bringing
it back with cold fusion for display. My problem is that if either table
has a null value data field where the join fields are equal, the request
comes back blank. So I have tried "coalesce" and even went as far as trying
an old trick I learned when I developed Access databases which was to use
"NZ(table.field)+NZ(table2.field2)" but as expected, that errored out. Does
anyone have some suggestion I might try to correct this problem and if so,
what are they?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
