Android SQL problem

Question

I have this sql statement

SELECT *
  FROM RecipeInstructions
 ORDER BY INSTRUCTION_NUMBER ASC
 WHERE RECIPE_ID_FK=1

execute it using rawquery - have exception... Syntax error near WHERE... Why?

Sparky · Accepted Answer · 2011-08-26 16:05:37Z

3

WHERE needs to come before ORDER BY

SELECT * FROM RecipeInstructions
WHERE RECIPE_ID_FK=1
ORDER BY INSTRUCTION_NUMBER ASC

answered Aug 26, 2011 at 16:05

Sparky

15.1k2 gold badges34 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adam V · Accepted Answer · 2011-08-26 16:05:39Z

1

Just a guess, but shouldn't the WHERE be before the ORDER BY?

answered Aug 26, 2011 at 16:05

Adam V

6,3613 gold badges42 silver badges52 bronze badges

Cedekasme · Accepted Answer · 2011-08-26 16:07:16Z

0

You should try this instead:

SELECT * FROM RecipeInstructions WHERE RECIPE_ID_FK=1 ORDER BY INSTRUCTION_NUMBER ASC

answered Aug 26, 2011 at 16:07

Cedekasme

2,0371 gold badge16 silver badges16 bronze badges