Re: Lengthy questions from a newbie (and a new problem)

FROM : Ryan Britton
DATE : Thu Jun 22 01:39:53 2006

On Jun 21, 2006, at 4:26 PM, Benjamin Einstein wrote:

>
> Does anyone outthere have experience with MCPKit (formerly known as 
> SMySQL)? I'm running into quite a strange problem. Connecting to 
> the database and running queries seems to work very well unless you 
> want to use a string created at runtime. Here's where we get stuck:
>
> theResult = [theConnection queryString:(@"SELECT password FROM 
> users WHERE username = '%@'", username)];


I'm not sure if the -queryString: method can take a format list, but 
this is definitely not the to do it if it can.  Try:

theResult = [theConnection queryString:[NSString 
stringWithFormat:@"SELECT password FROM users WHERE username = '%@'", 
username]];