Querying two variables in NSUserDefaults with stringWithFormat

[sarahhbabyyyy]

Hey Everyone,

So, I've been stuck on this all morning. I am trying to query two variables that I saved in NSUserDefaults and it doesn't seem to work. When I change the variables to regular NSStrings instead of NSUserDefaults, it works... Can I not do the following with NSUserDefaults? Or is there another way? Please help!

NSUserDefaults *defaults = [NSUserDefaults standardUserDefaults];
NSString *brandName = [defaults stringForKey:@"selectedBrand"];
NSString *modelName = [defaults stringForKey:@"selectedModel"];
NSString *sqlStr = [NSString stringWithFormat:@"select * from vehicleInfo where brandName = %@ and modelName = %@", brandName, modelName];

Sarah

[Duncan C]

Originally Posted by sarahhbabyyyy

Hey Everyone,

So, I've been stuck on this all morning. I am trying to query two variables that I saved in NSUserDefaults and it doesn't seem to work. When I change the variables to regular NSStrings instead of NSUserDefaults, it works... Can I not do the following with NSUserDefaults? Or is there another way? Please help!

NSUserDefaults *defaults = [NSUserDefaults standardUserDefaults];
NSString *brandName = [defaults stringForKey:@"selectedBrand"];
NSString *modelName = [defaults stringForKey:@"selectedModel"];
NSString *sqlStr = [NSString stringWithFormat:@"select * from vehicleInfo where brandName = %@ and modelName = %@", brandName, modelName];

Sarah

Your code looks like it should work as written.

What values are you getting for brandName and ModelName? Are those pointers nil? If not nil, do they contain empty strings?

Are you confident that those keys contain valid string data? Are you positive that the keys are correct, including case? It's a good habit to get into to use #defined constants for keys. That way there is no chance to have a mix-up or typo in a key.

Have you tried writing known values to those keys in userDefaults and doing a [userDefaults synchronize] call to force them to be flushed to disk right before the code above?


Regards,

Duncan C
WareTo
Check out our apps in the Apple App store

[sarahhbabyyyy]

Hi Duncan,

Thanks for your response. I am calling the same userDefaults somewhere else in my project and it works fine. I am querying the same thing somewhere else and it seems to be working there.

Let me show you more of my code... I took a variable out of my query and just sticking to one for now...maybe I am doing something wrong:

sqlite3 *database;

// Open the database from the users filessytem
if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {


NSUserDefaults *defaults = [NSUserDefaults standardUserDefaults];
NSString *brandName = [defaults stringForKey:@"selectedBrand"];
NSString *sqlStr = [NSString stringWithFormat:@"select * from vehicleInfo where brandName = '%@'", brandName];

const char *sqlStatement = [sqlStr UTF8String];

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
while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
// Read the data from the result row in column 2
NSString *aName = [NSString stringWithUTF8Stringchar *)sqlite3_column_text(compiledStatement, 2)];


[defaults setObject:aName forKey:@"selectedSpur"];

}
}

//Release the compiled statement from memory
sqlite3_finalize(compiledStatement);

}
sqlite3_close(database);

[sarahhbabyyyy]

Nevermind! I figured out my problem... I was calling the key before it was actually saved into NSUserDefaults... whatta noob.. thanks!