Comments on iPhone SDK Articles: SQLite Tutorial - Saving images in the database

Thanks for these tutorials they are great!! I am ...

2009-04-27T04:13:00.000-04:00

Thanks for these tutorials they are great!!

I am trying to complete this last one but all I get is TERMINATED DUE TO UNCAUGHT EXCEPTION everytime I run the application and click any of the coffee items. Please help!

I have tried downloading your source code and running it but all I get is the same error.

Hi First of all these tutorials are great, I have...

2009-04-27T03:50:00.000-04:00

Hi

First of all these tutorials are great, I have followed all of them and got to this final one. But all I get is TERMINATED DUE TO UNCAUGHT EXCEPTION when I click on any of the coffee items to get to the detail view.

I also downloaded your source code but again got the same error.

Please can you help

Firstly, great articles - thanks so much. I'm not...

2009-04-16T17:41:00.000-04:00

Firstly, great articles - thanks so much.

I'm not sure if I've missed something but in the code listing under "Saving image in the SQLite database", towards the end we "//Reclaim all memory here.". Should we also be releasing the coffeeImage here - is this a memory leak?

This was one of my first learning examples and it ...

2009-04-15T02:59:00.000-04:00

This was one of my first learning examples and it help me a lot. Great job.

Just one question.

How to drop table from Xcode? I need to find way to delete all data and replace them with new one but.

I too was looking for a way to fix the way the ima...

2009-04-02T11:46:00.000-04:00

I too was looking for a way to fix the way the image in displayed in the cell. Right now it shows up all wrong.

You gave an answer Americo Papaleo, but where would you put that code?

CGSize size = CGSizeMake(20, 20);
UIGraphicsBeginImageContext(size);

CGContextRef context = UIGraphicsGetCurrentContext();
CGContextTranslateCTM(context, 0, 20);
CGContextScaleCTM(context, 1.0, -1.0);
CGContextDrawImage(context, CGRectMake(0, 0, 20, 20), image.CGImage);
UIImage *scaledImage = UIGraphicsGetImageFromCurrentImageContext();

UIGraphicsEndImageContext();

Thanks,
Kevin

Please disregard the previous comment. The proble...

2009-04-01T13:19:00.000-04:00

Please disregard the previous comment. The problem was with the iphone Simulator keeping a previous database in its memory from one of the previous SQL examples.

I put in an image of type png into the database fo...

2009-04-01T12:21:00.000-04:00

I put in an image of type png into the database for the Latte coffee name, but when I press the Latte field, I get the following error: Terminating app due to uncaught exception 'NSInternalInconsistencyException', reason: 'Error while creating detail view statement. 'no such column: CoffeeImage''

Not sure why this is happening as the column exists in the SQLite database and there is even a value in that column for that field. Can someone help?

@Kevin You can set the background of a button like...

2009-03-15T12:57:00.000-04:00

@Kevin You can set the background of a button like this
[button setBackgroundImage:image forState:UIControlStateNormal];

This page http://developer.apple.com/iphone/library/documentation/UIKit/Reference/UIButton_Class/UIButton/UIButton.html#//apple_ref/occ/instm/UIButton/setBackgroundImage:forState: might help you.

Happy Programming,
iPhone SDK Articles

@Americo PapaleoYou can try something like thisCGS...

2009-03-15T12:50:00.000-04:00

@Americo Papaleo

You can try something like this

CGSize size = CGSizeMake(20, 20);
UIGraphicsBeginImageContext(size);

CGContextRef context = UIGraphicsGetCurrentContext();
CGContextTranslateCTM(context, 0, 20);
CGContextScaleCTM(context, 1.0, -1.0);
CGContextDrawImage(context, CGRectMake(0, 0, 20, 20), image.CGImage);
UIImage *scaledImage = UIGraphicsGetImageFromCurrentImageContext();

UIGraphicsEndImageContext();

FYI: This is not my solution but it does work.

Hope this helps.

Happy Programming,
iPhone SDK Articles

First of, what an amazing tutorial and an amazing ...

2009-03-03T15:23:00.000-05:00

First of, what an amazing tutorial and an amazing project! I am having a lot of fun playing around with this project and learning so much at the same time.

One thing I am trying to do is this: I have removed the coffeeImage from the table, made the table a little smaller in the view and have created a UIbutton at the top of the View that when pressed, opens up the Image Picker/camera View. So it looks similar to the Contact list. (I'd rather the coffeeImage be at the top in a square rather than at the bottom of the view in a cell.) Anyway, once the UIButton is pressed it launches my camera view. I take a picture, and was hoping that the new coffeeImage would go into the UIButton I created.

So my question is this, how do I set the background image of a UIButton to be my coffeeImage instead of putting it into a table cell like you did?

Thanks for your help.

hey thanks for this. i have bookmarked it at http:...

2009-02-20T04:38:00.000-05:00

hey thanks for this. i have bookmarked it at http://www.iphonekicks.com/database/SQLite_Tutorial_Saving_images_in_the_database

I love the articles ... I was wondering how you w...

2009-02-19T23:45:00.000-05:00

I love the articles ... I was wondering how you would scale the image to fit on the screen better or present the image in a manner like they are in the contact list application ... Thanks

The edit view controller is explained here http://...

2009-02-17T23:42:00.000-05:00

The edit view controller is explained here http://www.iphonesdkarticles.com/2008/11/sqlite-tutorial-updating-data.html

Happy Programming,
iPhone SDK Articles

Did you mean to completely leave out the EditViewC...

2009-02-15T22:12:00.000-05:00

Did you mean to completely leave out the EditViewController class set-up?

It is in the .zip file, but it would make the tutorial easier to follow if it were illustrated.