joelwe

Untitled

Mar 28th, 2013
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 0.39 KB | None | 0 0
  1. local test =
  2. {
  3. 1229,
  4. 1230,
  5. 731,
  6. 738,
  7. 1231,
  8. 735,
  9. 734,
  10. 2171,
  11. 736,
  12. 750,
  13. 751,
  14. 4135,
  15. 3840,
  16. 4134,
  17. 2205,
  18. 1225,
  19. 1233,
  20. 1232,
  21. 1234,
  22. 2197,
  23. 1228,
  24. 3841,
  25. 1226,
  26. 1227
  27. }
  28.  
  29. local path = system.pathForFile( "kalori.sqlite", system.ResourceDirectory )
  30. local db = sqlite3.open( path )
  31. local hk = {}
  32.  
  33. for i = 1, #test do
  34.     db:exec[[UPDATE Food SET Maincat=2 WHERE Id='test[i]';]]
  35. end
Advertisement
Add Comment
Please, Sign In to add comment