1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37

+ (int)intFromDatabase:(FMDatabase *)db query:(NSString *)queryString
{
	int retVal = 0;
	FMResultSet *rs = [db executeQuery:queryString, nil];
	if ([rs next])
	{
		retVal = [rs intForColumnIndex:0];
	}
 
	[rs close];
	return retVal;	
}
 
+ (int)recordCountFromDatabase:(FMDatabase *)db fieldName:(NSString *)inFieldName
					 tableName:(NSString *)inTableName whereClause:(NSString *)inWhereClause
{
	return [Utils intFromDatabase:db 
                            query:[NSString stringWithFormat:@"select count(%@) as ctr from %@ where %@",
                                            inFieldName, inTableName, inWhereClause]];	
}
 
+ (int)maxValueFromDatabase:(FMDatabase *)db fieldName:(NSString *)inFieldName
				  tableName:(NSString *)inTableName whereClause:(NSString *)inWhereClause
{
	int retVal = 0;
	NSString *sql = [NSString stringWithFormat:@"select max(%@) as maxval from %@ where %@",
					 inFieldName, inTableName, inWhereClause];
	FMResultSet *rs = [db executeQuery:sql, nil];
	if ([rs next])
	{
		retVal = [rs intForColumn:@"maxval"];
	}
 
	[rs close];
	return retVal;
}