using predicate with SQLite

[ladydev]

I'm using this line:

NSArray *regionItems = [[appDelegate springs] filteredArrayUsingPredicate:[NSPredicate predicateWithFormat:@"region = %@", region]];

in my numberOfRowsInSection and it works beautifully. I have the same method in my cellForRowAtIndexPath and it is sorting the detail view, so the information is not lining up with the correct rows, and its repeating the detail information, probably because its sorting it for each row.

Can anyone tell me what to use instead of filteredArrayUsingPrediate so I'm not filtering/sorting?

[iisword]

Have you tried using a WHERE clause in your sql statement?