Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-10-01 Thread Grant Rettke
On Tue, Sep 30, 2014 at 9:23 PM, Nick Dokos ndo...@gmail.com wrote: Grant Rettke g...@wisdomandwonder.com writes: Yikes what a week sorry about that here is what you would need I shall be defining a function to provide all such details in the future and thanks Nick for addressing: ╭ │

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-10-01 Thread Nick Dokos
Grant Rettke g...@wisdomandwonder.com writes: On Tue, Sep 30, 2014 at 9:23 PM, Nick Dokos ndo...@gmail.com wrote: Grant Rettke g...@wisdomandwonder.com writes: Yikes what a week sorry about that here is what you would need I shall be defining a function to provide all such details in the

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Rainer M Krug
Eric Brown br...@fastmail.fm writes: Dear List: It is possible to embed SQL code as a string to be evaluated in R. I am interested in formatting the SQL code in its own source code block, with its own syntax highlighting and editing mode (C-c '). This sounds very interesting, and I would be

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Grant Rettke
On Tue, Sep 30, 2014 at 3:05 AM, Rainer M Krug rai...@krugs.de wrote: Eric Brown br...@fastmail.fm writes: Like Rainier mentioned you might want to use [noweb] to tangle both for output tangling and execution. My system is set up to tangle for both eg: This ## ✂✂ #+name:

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Charles Berry
Eric Brown brown at fastmail.fm writes: Dear List: It is possible to embed SQL code as a string to be evaluated in R. I am interested in formatting the SQL code in its own source code block, with its own syntax highlighting and editing mode (C-c '). The first time I run the code, I am

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Eric Brown
Thanks Rainer and Grant for your suggestions. A couple of things: 1) My current code does what I want, the second time. Its advantage is that everything is kept inside of one .org file. Also, I am wondering if it is an R/ESS issue. 2) Grant, I tried your code, but there seem to be some missing

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Eric Brown
Charles Berry ccbe...@ucsd.edu writes: Hmmm. Maybe the bug that was fixed by commit 0fd29a5ee7d14c3695b22998196373b9a3637413 about two weeks back? Make sure ob-R.el is up to date and compiled (or that ob-R.elc is deleted). Anyway, your code works as expected for me - first time. ---

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Grant Rettke
On Tue, Sep 30, 2014 at 9:32 AM, Eric Brown br...@fastmail.fm wrote: 2) Grant, I tried your code, but there seem to be some missing headers. Do you have a complete minimal example that exhibits the behavior that you have demonstrated? Sorry for omitting that key point:

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Nick Dokos
Eric Brown br...@fastmail.fm writes: 2) Grant, I tried your code, but there seem to be some missing headers. Do you have a complete minimal example that exhibits the behavior that you have demonstrated? Add :noweb yes. Also Grant seems to have gone non-standard and replaced the noweb markup

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Grant Rettke
On Tue, Sep 30, 2014 at 2:15 PM, Nick Dokos ndo...@gmail.com wrote: Eric Brown br...@fastmail.fm writes: 2) Grant, I tried your code, but there seem to be some missing headers. Do you have a complete minimal example that exhibits the behavior that you have demonstrated? Add :noweb yes. Also

Re: [O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-30 Thread Nick Dokos
Grant Rettke g...@wisdomandwonder.com writes: On Tue, Sep 30, 2014 at 2:15 PM, Nick Dokos ndo...@gmail.com wrote: Eric Brown br...@fastmail.fm writes: 2) Grant, I tried your code, but there seem to be some missing headers. Do you have a complete minimal example that exhibits the behavior

[O] Error Embedding SQL Source from code block into R Source of Another (noweb)

2014-09-29 Thread Eric Brown
Dear List: It is possible to embed SQL code as a string to be evaluated in R. I am interested in formatting the SQL code in its own source code block, with its own syntax highlighting and editing mode (C-c '). The first time I run the code, I am prompted for R starting directory, but I get an