PDA

View Full Version : Type mismatch: 'FormatNumber'


Chamark
05-11-2006, 11:18 PM
I run an SQL query and it returns the data. If there is no data in a field that I have formatted then I get this message Type mismatch: Formatnumber.

Example: I formatted a field as a percent with two decimal places. If there is no data returned for that field in that row I get the error message. If I don't format any of the fields then I don't get the error when no data is returned.

How can I format all my fields that will allow for zero or nulls? Using DW 8.

Thanks in advance for you assistance.

davidj
05-12-2006, 08:30 AM
do an IF on the values

IF (value ==''){value = 'na';}

thats in PHP