› ›




Advertise here




Advertise here

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Google Sign In with OpenID
Sign In Register

Forums

Please do not post the same thing multiple times. The board software automatically flags certain posts as needing moderator attention. This happens the most often for new users. I'm pretty sure this is made clear at the time you attempt to post. Posting the same thing over and over again just makes that many more posts the moderators have to weed through later. This makes us sad. Don't make us sad. If your post/thread doesn't appear, just wait a while. Don't post it again. If it hasn't shown up by the next day, then you can try again. I normally go through posts in the mornings, and try to check a few times throughout the day, but I'm not here 24/7. There will typically be a significant delay before posts are approved. Just be patient.

Basic SQLite

bwintzbwintz Posts: 3New Users
in iPhone SDK Development
Hello guys, this is my first post here at iPhoneDevSDK.com, I have been using apples forum for development but I thought I should give this a go and if anyone can help me.

I am trying to display all my data from a row. (Column titled 'name', with lots of names under it)

It is only displaying the last entered data from the database.

Here is the code;

- (void)viewDidLoad {
	[super viewDidLoad];
	
	NSString *myDB = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@\"tutorial.sql\"];
	
	database = [[Sqlite alloc] init];
	[database open:myDB];
	
	NSArray *results = [database executeQuery:@\"SELECT * FROM names;\"];
	
	for (NSDictionary *row in results) {

		rowSelect = [row valueForKey:@\"name\"];	
	
	}
	[textView setText:rowSelect];
	
}



Thank you!
Post edited by bwintz on
Flag • Off Topic Insightful Disagree Dislike Like Awesome

Replies

  • msencenbmsencenb Posts: 292Registered Users 
    for (NSDictionary *row in results) {

    		rowSelect = [row valueForKey:@\"name\"];	
    	
    	}
    	[textView setText:rowSelect];


    You are looping through all the results but just setting rowSelect equal to the row value. So the last row from the query will be stored in rowSelect. You will have to do some string concatenation within the loop to get all the results. Does this make sense?
    Want to get feedback from your users? Check out the beta:

    iOSUserFeedback.com
    Flag • Off Topic Insightful Disagree Dislike Like Awesome
Sign In or Register to comment.