Hi All!
I just discovered sqldf and im very enthousiastic, as I am a big fan of
R and I often get frustrated using Access for datamanagement.
I tried running some queries from Access in R, and it works very well.
However, I have problems with some queries.
If I run this SQL query:
> sqldf("SELE
"Marvelde, Luc te" writes:
> If I run this SQL query:
>> sqldf("SELECT
> + dbo_tbl_Terrein.RingCentraleNaam,
> + dbo_tbl_Broedsels.BroedselID
> + FROM ((dbo_tbl_BroedselLocatie
> + INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID =
> dbo_tbl_Broedsels.BroedselID)
> + INNER JOIN
2009/11/20 Tom Lane :
> "Marvelde, Luc te" writes:
>> If I run this SQL query:
>
>>> sqldf("SELECT
>> + dbo_tbl_Terrein.RingCentraleNaam,
>> + dbo_tbl_Broedsels.BroedselID
>> + FROM ((dbo_tbl_BroedselLocatie
>> + INNER JOIN dbo_tbl_Broedsels ON dbo_tbl_BroedselLocatie.BroedselID =
>> dbo_tbl_Broed
Hello
2009/11/20 Marvelde, Luc te :
> Hi All!
>
> I just discovered sqldf and im very enthousiastic, as I am a big fan of R
> and I often get frustrated using Access for datamanagement.
>
> I tried running some queries from Access in R, and it works very well.
> However, I have problems with some
2009/11/20 Pavel Stehule :
> Hello
>
> 2009/11/20 Marvelde, Luc te :
>> Hi All!
>>
>> I just discovered sqldf and im very enthousiastic, as I am a big fan of R
>> and I often get frustrated using Access for datamanagement.
>>
>> I tried running some queries from Access in R, and it works very well.
Nothing is wrong with the data... Everything is there in the dataframe. All the
names are case sensitive, but the way it is spelled is correct So that cant
be the problem
Luc
-Original Message-
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: vrijdag 20 november 2009 15:
I think you (or I) might misunderstand TL's comment. The sql is
probably being sent by some late-in-the-client-side-game driver with
names quoted with double-quote marks, but the database does not have the
column names etc in mixed case. Can you connect directly to the
postgres server (psql -h d
On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote:
> 2009/11/20 Tom Lane :
> > "Marvelde, Luc te" writes:
> >> If I run this SQL query:
> >>> sqldf("SELECT
> >>
> >> + dbo_tbl_Terrein.RingCentraleNaam,
> >> + dbo_tbl_Broedsels.BroedselID
> >> + FROM ((dbo_tbl_BroedselLocatie
> >> + INNER J
Luc,
You need to contact Gabor Grothendieck (cc'd) about this issue. He is
the package author. I'm sure he will be happy to help.
-Whit
On Fri, Nov 20, 2009 at 11:23 AM, Adrian Klaver wrote:
> On Friday 20 November 2009 6:43:53 am Pavel Stehule wrote:
>> 2009/11/20 Tom Lane :
>> > "Marvelde,
