I'm getting data from a database and I need to add the string field value and the record id.

However, I need this to work with some existing code...

I'm replacing this (see code below) and getting data from my database.

NSDictionary *dict = [[NSDictionary alloc] initWithContentsOfFile:path];
self.allCategories = dict;
[dict release];

But needs to work with these key and value search functions.

- (void)resetSearch {
NSMutableDictionary *allCategoriesCopy = [self.allCategories mutableDeepCopy];
self.Categories = allCategoriesCopy;
[allCategoriesCopy release];
NSMutableArray *keyArray = [[NSMutableArray alloc] init];
[keyArray addObject:UITableViewIndexSearch];
[keyArray addObjectsFromArray:[[self.allCategories allKeys] 
                           sortedArrayUsingSelector:@selector(compare:)]];
self.keys = keyArray;
[keyArray release];
}

.

- (void)handleSearchForTerm:(NSString *)searchTerm {
NSMutableArray *sectionsToRemove = [[NSMutableArray alloc] init];
[self resetSearch];

for (NSString *key in self.keys) {
    NSMutableArray *array = [Categories valueForKey:key];
    NSMutableArray *toRemove = [[NSMutableArray alloc] init];
    for (NSString *name in array) {
        if ([name rangeOfString:searchTerm 
                        options:NSCaseInsensitiveSearch].location 
                                                        == NSNotFound)
            [toRemove addObject:name];
    }

    if ([array count] == [toRemove count])
        [sectionsToRemove addObject:key];

    [array removeObjectsInArray:toRemove];
    [toRemove release];
}
[self.keys removeObjectsInArray:sectionsToRemove];
[sectionsToRemove release];
[table reloadData];
}

Keep getting an error from this code...

NSDictionary *arrayTmp= [[NSDictionary alloc] init];

... loop records

int cid = sqlite3_column_int(statementTMP, 0);
NSString *category = [[NSString alloc] 
   initWithUTF8String:(char *)sqlite3_column_text(statementTMP, 1)];

[arrayTmp setObject:category forKey:[NSString stringWithFormat:@"%i", cid]];

Error caused by line above

* Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[NSCFString count]: unrecognized selector sent to instance 0x4d4c500' * Call stack at first throw *

... end loop

self.allCategories = arrayTmp;
[arrayTmp release];