Displaying 5 results from an estimated 5 matches for "lingyun".
Did you mean:
lingyu
2002 Sep 04
1
Passing dynamic sql statement to RODBC functions
...y(RODBC)
>channel<-odbcConnect(...)
>data1<-2.5
>data2<-5.0
I want to construct the INSERT sql statement using variables "data1" and
"data2" and pass this statement to odbcQuery() . Can I do this? what's the
syntax to construct this sql statement?
Thanks
Lingyun
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at sta...
2002 Sep 05
0
AW: Passing dynamic sql statement to RODBC functions
...tatement <- paste("SELECT * FROM somewhere WHERE something=", data1,
";", sep="")
>library(RODBC)
>channel <- odbcConnect(...)
>sqlQuery(channel, query = sql.statement)
>odbcClose(channel)
-Heinrich.
> -----Urspr?ngliche Nachricht-----
> Von: Lingyun Shi [mailto:Lingyun.Shi at fimat.com]
> Gesendet: Mittwoch, 04. September 2002 23:41
> An: r-help at stat.math.ethz.ch
> Betreff: [R] Passing dynamic sql statement to RODBC functions
>
>
>
> Hi,
>
> Does anyone know how to pass dynamic sql statement to RODBC function...
2002 Sep 19
1
How to call stored procedure from RODBC?
Hi,
Does anyone know how to call stored procedure from RODBC? Thanks.
Lingyun
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat...
2002 Sep 19
1
ssh and popen-- broken pipe
Hi,
My application uses popen to execute UNIX commands. After I replace rsh
with ssh, it stopped working. I have made a test C code to reproduce the
problem as attached in this email. In the test program, I called popen for
ssh command and then pclose right away. I got the following error:
kirk 588$ a.out
Write failed flushing stdout buffer.
write stdout: Broken pipe
Any idea what is
2002 Aug 23
1
R/SJava/ROracle installation problem
Hi,
I had problem during SJava and ROracle installation. I use "R CMD INSTALL
-c SJava_0.65-0.tar.gz" command to install SJava pakage. After
installation, I start R session and type library(SJava), error happened as:
> library(SJava)
Error in dyn.load(x, as.logical(local), as.logical(now)) :
unable to load shared library