Guest User

Untitled

a guest
May 22nd, 2012
33
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. Writing mulitple querry
  2. FMResultSet *resultOfDesiredCuisine = [db executeQueryWithFormat:@"select * from dishes where cuisineId IN (select cuisineId from cuisines where Lower(cuisineName) like %@) and
  3. categoryID IN "(select categoryID from categories where Lower(categoryName) like %@)",cuisineName,categoryName];
  4.  
  5. FMResultSet *resultOfDesiredCuisine = [db executeQueryWithFormat:@"SELECT * FROM dishes WHERE cuisineId IN (SELECT cuisineId FROM cuisines WHERE LOWER(cuisineName) like ?) AND
  6. categoryID IN (SElECT categoryID FROM categories WHERE LOWER(categoryName) LIKE ?)", cuisineName, categoryName];
Advertisement
Add Comment
Please, Sign In to add comment