Advertise Mobile SDKs Books Events Forum News Social Networking Support Us
Follow @iphonedevsdk on Twitter

Interface 2, Advanced iOS
Mockup & Code Gen
($9.99)

Make your own iPhone apps
and run them live!
(free)

Pic Frame Dynamo: Photo Editing
($0.99)

Abiliator
($1.99)

Want your application or service advertised on iPhone Dev SDK?

Go Back   iPhone Dev SDK Forum

View Single Post
Old 03-12-2010, 06:08 PM   #1 (permalink)
ivanraso
Registered Member
 
Join Date: Dec 2009
Posts: 142
ivanraso is on a distinguished road
Question sqlite bind text

Hi. I am trying to take a row of my sqldatabase where the data name=X.
SO i have this...
Code:
NSString * name=[NSString stringwithformat:@"Rick"];
const char *sqlStatement = "select * from user where name=?";
		sqlite3_stmt *compiledStatement;
if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
			// Loop through the results and add them to the feeds array
			sqlite3_bind_text(compiledStatement, 1, [name UTF8String],-1,SQLITE_TRANSIENT);
			while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
Anyone knows why it is doesnt working?¿???¿?
ivanraso is offline   Reply With Quote
 

» Advertisements
» Stats
Members: 175,539
Threads: 94,054
Posts: 402,649
Top Poster: BrianSlick (7,981)
Welcome to our newest member, cecilytw61
Powered by vBadvanced CMPS v3.1.0

All times are GMT -5. The time now is 12:04 PM.
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.