I guess I've been out of the loop for a while. I used to have this at the end of my org-mode SQL files:
#+PROPERTY: engine mysql
#+PROPERTY: dbhost xx.xx.xx.xx
#+PROPERTY: dbuser xxxxxx
#+PROPERTY: dbpassword xxxxxxxxx
#+PROPERTY: database xxxxxxxxxxxxx
But since I recently updated org-mode, these don't have any effect anymore. In ob-sql I can see they're not getting passed to org-babel-execute:sql.
I tried a different form that I saw in the doc:
#+PROPERTY: header-args:sql :engine mysql
#+PROPERTY: header-args:sql :dbhost xxxxxxx
#+PROPERTY: header-args:sql :dbuser xxxxxxx
#+PROPERTY: header-args:sql :dbpassword xxxxxx
#+PROPERTY: header-args:sql :database xxxxxxxxxxxx
but that doesn't work either. Can anyone tell me the proper new-style form for passing header args to all sql code blocks?
thanks!
--
Gary