Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Writing mulitple querry
- FMResultSet *resultOfDesiredCuisine = [db executeQueryWithFormat:@"select * from dishes where cuisineId IN (select cuisineId from cuisines where Lower(cuisineName) like %@) and
- categoryID IN "(select categoryID from categories where Lower(categoryName) like %@)",cuisineName,categoryName];
- FMResultSet *resultOfDesiredCuisine = [db executeQueryWithFormat:@"SELECT * FROM dishes WHERE cuisineId IN (SELECT cuisineId FROM cuisines WHERE LOWER(cuisineName) like ?) AND
- categoryID IN (SElECT categoryID FROM categories WHERE LOWER(categoryName) LIKE ?)", cuisineName, categoryName];
Advertisement
Add Comment
Please, Sign In to add comment