[snip]
SUM(IF(If FOO is this, return this number, else return a blank)) that looks
like this really
SUM(IF(RecordID = '100101', 1, '')) as min1
Which works correctly BUT, if the statement is false it does not show a
blank cell in the worksheet, but a "0" (zero).
I have tried
stuff, 1, '\'' (escape a tick which Excel normally uses to display numbers
as text)
stuff, 1, ' ' (a space)
stuff, 1, NULL (which still returns a zero)
stuff, 1, (which throws errors)
stuff, 1, '\"\"' (which still returns a zero)
stuff, 1, '\ ' (escape a space)
The worksheet still has zero values displayed, no matter what I do (except
for that which throws errors). Ideas?
[/snip]
I got it (and feel somewhat a d'oh!). I just ley PHP handle it when it
writes it out;
if($dbrow->min1 > 0){
print($dbrow->min1);
}
for each row...
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
