sqlite bind text

[ivanraso]

Hi. I am trying to take a row of my sqldatabase where the data name=X.
SO i have this...

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?¿???¿?

[Nungster]

Try it without this line:

sqlite3_bind_text(compiledStatement, 1, [name UTF8String],-1,SQLITE_TRANSIENT);

[Nungster]

Originally Posted by Nungster

Try it without this line:

sqlite3_bind_text(compiledStatement, 1, [name UTF8String],-1,SQLITE_TRANSIENT);

Another point may be how you are storing the data once it is returned from SQLite. My guess is you need a NSMutableArray to store the row when it comes back from SQLite and not seeing how you are dealing with that limits the amount by which we are able to help.

[ivanraso]

Originally Posted by Nungster

Another point may be how you are storing the data once it is returned from SQLite. My guess is you need a NSMutableArray to store the row when it comes back from SQLite and not seeing how you are dealing with that limits the amount by which we are able to help.

I did it. It was a problem with the database...thank you guys.

[d4devil]

What was the problem? I am also stuck in the same problem from the past three days. I want to insert data in sqlite database, but not getting success.
I am writing these lines of code
-(void) addNewRecordsbyUserNameNSString *)_userName withCountryNameNSString *)_countryName andEmailNSString *)_emailAddress{
@try
{
NSFileManager *fileManager=[NSFileManager defaultManager];
NSString *theDBPath=[[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent: @"Database.sqlite"];
BOOL success=[fileManager fileExistsAtPath:theDBPath];

(sqlite3_open([theDBPath UTF8String], &database))
{
NSString *query = [[NSString alloc ] initWithFormat:@"insert into userinformation Values(%d,'%@','%@','%@')",idName,_emailAddress,_c ountryName,_userName];
const char *sql = [query UTF8String];
sqlite3_stmt *statement;
sqlite3_prepare_v2(database, sql,-1,&statement,NULL)

sqlite3_bind_text(statement, 1, [_userName UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(statement, 2, [_emailAddress UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_text(statement, 3, [_countryName UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_int(statement,4,4); [query release];
sqlite3_finalize(statement)
sqlite3_close(database)
}
@catch (NSException * e)
{
NSLog(@"An exception occured:%a",[e reason]);
}
}

I have no idea where i am putting mistake. Can anybody please help me here. Looking for your positive responses in a very quick time as i am in very much hurry.

[Bertrand21]

Originally Posted by d4devil

What was the problem? I am also stuck in the same problem from the past three days. I want to insert data in sqlite database, but not getting success.
I have no idea where i am putting mistake. Can anybody please help me here. Looking for your positive responses in a very quick time as i am in very much hurry.

First of all, use code tags when you post code...

To answer your question, you are missing the most important part!

 int success = sqlite3_step(statement);