Fossil SCM
Retrieve the value of an SQL count(*) as an integer, not a float (discovered by accident while playing with compiler warnings).
Commit
735b6be7ea8cc686a7b61db36198ab51845d270572ee0b1d30a215634e55f3e9
Parent
d847300f3b59fa1…
1 file changed
+1
-1
+1
-1
| --- src/piechart.c | ||
| +++ src/piechart.c | ||
| @@ -156,11 +156,11 @@ | ||
| 156 | 156 | if( (pieFlags & PIE_OTHER)!=0 && nTotal>1 ){ |
| 157 | 157 | db_prepare(&q, "SELECT sum(amt), count(*) FROM piechart WHERE amt<:amt"); |
| 158 | 158 | db_bind_double(&q, ":amt", rTotal/OTHER_CUTOFF); |
| 159 | 159 | if( db_step(&q)==SQLITE_ROW ){ |
| 160 | 160 | rTooSmall = db_column_double(&q, 0); |
| 161 | - nTooSmall = db_column_double(&q, 1); | |
| 161 | + nTooSmall = db_column_int(&q, 1); | |
| 162 | 162 | } |
| 163 | 163 | db_finalize(&q); |
| 164 | 164 | } |
| 165 | 165 | if( nTooSmall>1 ){ |
| 166 | 166 | db_prepare(&q, "SELECT amt, label FROM piechart WHERE amt>=:limit" |
| 167 | 167 |
| --- src/piechart.c | |
| +++ src/piechart.c | |
| @@ -156,11 +156,11 @@ | |
| 156 | if( (pieFlags & PIE_OTHER)!=0 && nTotal>1 ){ |
| 157 | db_prepare(&q, "SELECT sum(amt), count(*) FROM piechart WHERE amt<:amt"); |
| 158 | db_bind_double(&q, ":amt", rTotal/OTHER_CUTOFF); |
| 159 | if( db_step(&q)==SQLITE_ROW ){ |
| 160 | rTooSmall = db_column_double(&q, 0); |
| 161 | nTooSmall = db_column_double(&q, 1); |
| 162 | } |
| 163 | db_finalize(&q); |
| 164 | } |
| 165 | if( nTooSmall>1 ){ |
| 166 | db_prepare(&q, "SELECT amt, label FROM piechart WHERE amt>=:limit" |
| 167 |
| --- src/piechart.c | |
| +++ src/piechart.c | |
| @@ -156,11 +156,11 @@ | |
| 156 | if( (pieFlags & PIE_OTHER)!=0 && nTotal>1 ){ |
| 157 | db_prepare(&q, "SELECT sum(amt), count(*) FROM piechart WHERE amt<:amt"); |
| 158 | db_bind_double(&q, ":amt", rTotal/OTHER_CUTOFF); |
| 159 | if( db_step(&q)==SQLITE_ROW ){ |
| 160 | rTooSmall = db_column_double(&q, 0); |
| 161 | nTooSmall = db_column_int(&q, 1); |
| 162 | } |
| 163 | db_finalize(&q); |
| 164 | } |
| 165 | if( nTooSmall>1 ){ |
| 166 | db_prepare(&q, "SELECT amt, label FROM piechart WHERE amt>=:limit" |
| 167 |