image in table cell row

[dcjones]

Hi all,

I have a table which load a list of countries from an SQLite table. The table holds the country name and also a reference to the country flag. I would like to display the country flag for each country but I am not too sure how I should approach this.

The code I am using is:

To initialize the table data I am using:

-(void)initializeTableData
{
	
	arrayOfCharacters = [[NSMutableArray alloc]init];
	
	objectsForCharacters = [[NSMutableDictionary alloc]init];
	
	sqlite3 *db = [iTravelv113AppDelegate getNewDBConnection];
	for(char c='A';c<='Z';c++)
	{
		NSMutableString *query;
		
		query = [NSMutableString stringWithFormat:@"select countryName, countryFlag from countryList where countryName LIKE '%c%%'",c];
		
		const char *sql =  [query UTF8String];
		sqlite3_stmt *statement = nil;
		
		if(sqlite3_prepare_v2(db, sql, -1, &statement, NULL)!=SQLITE_OK)
			
			NSAssert1(0,@"error preparing statement: '%s'", sqlite3_errmsg(db));
		else
			
		{
			NSMutableArray *arrayOfNames = [[NSMutableArray alloc]init];
			while(sqlite3_step(statement)==SQLITE_ROW)
				[arrayOfNames addObject:[NSString stringWithFormat:@"%s",(char*)sqlite3_column_text(statement, 0)]];
			
			if([arrayOfNames count] >0)
			{
				[arrayOfCharacters addObject:[NSString stringWithFormat:@"%c",c]];
				
				[objectsForCharacters setObject:arrayOfNames forKey:[NSString stringWithFormat:@"%c",c]];
			}
			[arrayOfNames release];
		}
		
		
		
		
		
		sqlite3_finalize(statement);
	}
	
}

To create the table row and cell I am using:

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
	
	
	static NSString *MyIdentifier = @"MyIdentifier";
	
	UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:MyIdentifier];
	if (cell == nil) {
		cell = [[[UITableViewCell alloc] initWithFrame:CGRectZero reuseIdentifier:MyIdentifier] autorelease];
	}
	
	// Set up the cell  
	
	cell.textLabel.text = [[objectsForCharacters objectForKey:[arrayOfCharacters objectAtIndex:indexPath.section]] objectAtIndex:indexPath.row];
	[[cell textLabel] setTextColor: [UIColor colorWithRed:139.0/255.0 green:0.0/255.0 blue:0.0/255.0 alpha:1.0]]; 
	
	NSLog(@"Char:%@",[arrayOfCharacters description]); 
	
	UIImage *image = [UIImage imageNamed:@"Anguilla.gif"];
	cell.imageView.image = image;

	
	
	return cell;
	
}

How can I code the part marked in red to display the image relating to the country.

[smithdale87]

You could include all of the images in your app, and put the name of the image file correspondign to each country in the database, e.g "Anguila.jpg", "USA.jpg", etc

Then, your cellForRowAtIndex:

...
UIImage *image = [UIImage imageNamed: theImageFileName ];
	cell.imageView.image = image;

....

where theImageFileName would be the value selected from the database that is the name of the image file.

[dcjones]

Hi smithdale87,

Many thanks for your reply.

The issue I have is the data array I have which holds the country names, I don't seem to be able to include the field for the countryFlag. the code below produces a list of countries grouped by the first letter of the country, along with an A-Z list for the side jump to list.

How can I include the countryFlag field into the "objectsForCharacters" array.

Any help would be great.

-(void)initializeTableData
{
	
	arrayOfCharacters = [[NSMutableArray alloc]init];
	
	objectsForCharacters = [[NSMutableDictionary alloc]init];
	
	sqlite3 *db = [iTravelv113AppDelegate getNewDBConnection];
	for(char c='A';c<='Z';c++)
	{
		NSMutableString *query;
		
		query = [NSMutableString stringWithFormat:@"select countryName, countryFlag from countryList where countryName LIKE '%c%%'",c];
		
		const char *sql =  [query UTF8String];
		sqlite3_stmt *statement = nil;
		
		if(sqlite3_prepare_v2(db, sql, -1, &statement, NULL)!=SQLITE_OK)
			
			NSAssert1(0,@"error preparing statement: '%s'", sqlite3_errmsg(db));
		else
			
		{
			NSMutableArray *arrayOfNames = [[NSMutableArray alloc]init];
			while(sqlite3_step(statement)==SQLITE_ROW)
				[arrayOfNames addObject:[NSString stringWithFormat:@"%s",(char*)sqlite3_column_text(statement, 0)]];
			
			if([arrayOfNames count] >0)
			{
				[arrayOfCharacters addObject:[NSString stringWithFormat:@"%c",c]];
				
				[objectsForCharacters setObject:arrayOfNames forKey:[NSString stringWithFormat:@"%c",c]];
			}
			[arrayOfNames release];
		}
		
		
		
		
		
		sqlite3_finalize(statement);
	}
	
}