Problem with sqlite query when using the wrapper

Question

- (IBAction)EnterButtonPressed:(id)sender {
    Sqlite *sqlite = [[Sqlite alloc] init];

NSArray *paths =NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask, YES);
    NSString *documentsDirectory = [paths objectAtIndex:0];
    NSString *writableDBPath = [documentsDirectory stringByAppendingPathComponent:@"test.sqlite"];
    if (![sqlite open:writableDBPath])
        return;
NSArray *query = [sqlite executeQuery:@"SELECT AccessCode FROM UserAccess"];
NSLog(@"%@",query);

I am getting the output as : { ( AccessCode=abcd; ) }

Where as in I want it as : abcd

I am using the wrapper from : http://th30z.netsons.org/2008/11/objective-c-sqlite-wrapper/

Please help .

Answer 1

The output is correct, the examples clearly show it also:

    NSArray *results = [sqlite executeQuery:@"SELECT * FROM test;"];
for (NSDictionary *dictionary in results) {
  NSLog(@"Row");
  for (NSString *key in [dictionary keyEnumerator])
      NSLog(@" - %@ %@", key, [dictionary objectForKey:key]);
}

You get an Array of NSDictionaries. You could write e.g

NSDictionary *dict = [result at: 0];
NSSTring *itemValue = [dict objectForKey: @"AccessCode"]
NSLog(..., itemValue)

and will get the wished output.