Re: [R] remote database queries

2009-07-18 Thread Cedrick Johnson
Here's my MYSQL setup for retrieving data: library(RMySQL) channel <- dbConnect(MySQL(), user="xx", password="xx", dbname="HistData", host="nomnom.cvgrllc.com") EDM1 = dbGetQuery(channel, paste("select Date, o, h, l, c, v, a from HistBondData Where Symbol = 'EDM1' AND a != 0 ORDER BY Da

Re: [R] remote database queries

2009-07-18 Thread Gabor Grothendieck
That depends on the database, not R. I have done remote database calls using MySQL from R. On Sat, Jul 18, 2009 at 3:04 PM, David Lubbers wrote: > With good and faithful python remote database queries look something > like this: > > url.urlopen("username/pssw...@host",query) > > where query is so

Re: [R] remote database queries

2009-07-18 Thread Duncan Murdoch
On 18/07/2009 3:04 PM, David Lubbers wrote: With good and faithful python remote database queries look something like this: url.urlopen("username/pssw...@host",query) where query is something like "select * from table where " Does R support queries on remote hosts with username and passwor

[R] remote database queries

2009-07-18 Thread David Lubbers
With good and faithful python remote database queries look something like this: url.urlopen("username/pssw...@host",query) where query is something like "select * from table where " Does R support queries on remote hosts with username and password? What does a simple example look like? Tha