The documentation here is useful http://drupal.org/developing/api/database

SELECT queries still work in the old style (Static queries), but placeholders are formatted differently, see http://drupal.org/node/310072

Carl Wiedemann
Website design and development consulting
carl.wiedemann@gmail.com | skype: c4rlww