How do I...

  • get records from table
  • get records from given table where <conditions> (how to specify equals, not equals <, >, <=, >=, in/not in etc)
  • get records from table where order by
  • how to use the iterators, and when
  • calling stored procedures...sometimes its quicker/necessary to have SPs
  • OO queries - background, how to build one, when is good to use one, when isn't.
  • How to write your own queries in a gateway, where to write them etc.
  • How to deal with subqueries i.e. can reactor do them, or is it something you need to write a method for in a gateway etc.