How to pass two queries in FMResultSet

Question

I have written this code :-

[database open];

    NSString *stringQuery = [NSString stringWithFormat:@"SELECT email, firstName, id, lastName, phone FROM contacts WHERE id = '%@'", _stringID];

    NSString *stringQuery2 = [NSString stringWithFormat:@"SELECT id, status FROM members WHERE id = '%@'", _stringID];

    FMResultSet *result = [AppDel.database executeQueryWithFormat:stringQuery, stringQuery2];

    if ([result next])
    {
        labelEmail.text = [result stringForColumn:@"email"];
        labelFirstName.text = [result stringForColumn:@"firstName"];
        labelLastName.text = [result stringForColumn:@"lastName"];
        labelCellPhone.text = [result stringForColumn:@"phone"];

        labelSignInStatus.text = [result stringForColumn:@"status"];
    }

    [result close];

    [database close];

Its gives me the value at labelCellPhone.text when i pass it through labelSignInStatus.text they showing "Warning: I could not find the column named 'status'" & when i pass the query in Sqlite browser they give me correct result.I have also create FMResultSet object again named FMResultSet *result1 & pass query its showing me the same error. Can anybody help me that how can i pass two queries in FMResultSet. Thanks

score 2 · Accepted Answer · answered Aug 03 '14 at 12:27

You can't pass 2 queries to executeQueryWithFormat. That is not what it was meant for. You can pass one query and then some parameters. If you are going to format the sql yourself, then just use executeQuery:(NSString *) sql

It's not totally clear what you are trying to do here, but you probably need to do a SQL join. So your problem is a SQL question, not a FMResult set question I think.

Maybe you need something like this:

NSString *stringQuery = [NSString stringWithFormat:@"SELECT c.email, c.firstName, c.id, m.status c.lastName, c.phone FROM contacts c, members m where c.id=m.id and c.id='%@'", _stringID];

FMResultSet *result = [AppDel.database executeQuery:stringQuery];

So that would return you a row where the contact has the same id as the member. Then the rest of your code should work.

Thanks Fraggle. Can you please let me know how to fetch all row data through FMDatabase because i have used stringForColumn but they return only one value. I want whole result, when i execute the query on sqlite browser it gives 50 names & their corresponding numbers but in app only return 1 value. — Gurpreet, Aug 03 '14 at 15:40

How to pass two queries in FMResultSet

1 Answers1