[R-sig-DB] RMySQL dbSendQuery

[Parlamis Franklin]

Thank you both for your responses.  I understand now.  I need to run  
some R code, followed by some SQL code, followed again by some R  
code, and wanted to do it from a single script.  dbSendQuery has a  
one-statement limit, which I was trying to avoid.  Perhaps i will  
concatenate all my commands into a single semicolon-separated string  
and send that using dbQuery.


On Oct 14, 2005, at 10:21 AM, Herve Pages wrote:

> Parlamis Franklin wrote:
>
>
>> When the following statement:
>>
>>     dbSendQuery(MySQL.Connection, "source ~/MySQLFiles/ 
>> DateTable.sql")
>>
>>
>>
> As Douglas said, "source" is not an SQL statement.
>
> Remember, MySQL is a client/server RDBMS. The client (your R program)
> and the server can be on different machines. So when the server  
> receives
> the following statement "source ~/MySQLFiles/DateTable.sql", how  
> could it
> find the file "~/MySQLFiles/DateTable.sql"?
>
> -- 
> ------------------------
> Hervé Pagès
> E-mail: hpages using fhcrc.org
> Phone: (206) 667-5791
>   Fax: (206) 667-1319
> ------------------------
>
>