Re: [Orgmode] Help with Babel and using SQL

2011-02-13 Thread yesare
Eric and Dan: Thanks for the feedback. Here is what happened. Regarding var substitution, when I tested it earlier I was running org-mode 7.3 and it did not work. After upgrading to 7.4 the var substitution worked fine. I was also testing it from a xp machine and connecting to a mysql in a linux

Re: [Orgmode] Help with Babel and using SQL

2011-02-13 Thread Eric Schulte
yesare writes: > Thanks. > > I opened up ob-sql.el and read the code to see if I can figure it out. > > I think I have answered my first question. I wrote the following and hit > C-c C-c and I got the result set back. > > #+srcname: sampsql > #+begin_src sql :engine mysql :cmdline -h hostname -u

Re: [Orgmode] Help with Babel and using SQL

2011-02-13 Thread yesare
Thanks. I opened up ob-sql.el and read the code to see if I can figure it out. I think I have answered my first question. I wrote the following and hit C-c C-c and I got the result set back. #+srcname: sampsql #+begin_src sql :engine mysql :cmdline -h hostname -u username -pmypass -D dbname sel

Re: [Orgmode] Help with Babel and using SQL

2011-02-13 Thread Bastien
Hi Yesare, I'm not familiar enough with Babel to give you useful guidance, but others on the list may help you. yesare writes: > I am trying to do two things. >   > > 1. Query a mysql or oracle table and post results in orgtable format > 2. Select data from an existing orgtable in current bu

[Orgmode] Help with Babel and using SQL

2011-02-12 Thread yesare
Hello: I am new to orgmode. So far I have managed to organize and use org by reading documemtation. Now I want to experiment with babel and SQL and I am stuck as I am unable to find any good documentation on this. I also searched the mail archive and I see several code snippets but so far I have no