cklee
|
| Posted: 02/10/2002, 6:10 AM |
|
Is there a way to replace error message when the sql clause return zero record from the where expression. I have a sql statement as
select avg(pbc) as AvPBC from collect where pbc <>0 and month="Jan"
For some months in my database, PBC are zero for all days in the month. When CC executes, it will return a error as "Microsoft VBScript runtime (0x800A000D)
Type mismatch: 'fldavpveh'"
|
|
|
 |
Nicole
|
| Posted: 02/11/2002, 1:20 AM |
|
Hello,
check "avpveh" field type in db and CC. They should match.
Try to run the query in db query analyzer. Is it successful? If yes, then the field type on CC form is incorrect.
|
|
|
|
cklee
|
| Posted: 02/11/2002, 5:52 AM |
|
The question is for the 12 months of the year, there may be one or two months that the daily pveh are zero i.e. no transaction. The sql select statement will return null for that month and no average value return. In what way, I can control CC to assign a "0" to that month while the remaining months have the values. I use ASP.
|
|
|
|
|
