If an SQL statement returns no data how can I enter a value in a field?
Select Sum(ext-price) From ordertable
As long as the shipdate is equal to the current day the above select statement will Sum the ext-price field. That is okay. How do I fix the select statement to enter 00.00 in the ext-price field if there is no order for the current day?
This is being displayed on my webpage that uses Dreamweaver.
Obviously if the condition is not met there is no data to sum. So how do I fill in this field with zeros?