Re: [R] Query an Access database based on a date attribute (Tudor Bodea)

2007-11-13 Thread Prof Brian Ripley
On Tue, 13 Nov 2007, Baize, Harold wrote: > Tudor Bodea asked: > >> In this context, I try to get all the records for which market is atl-bos, >> competitor is delta and dd is 2007-11-20 (first record above). To do this I >> used > >>> # channel <- odbcConnectAccess("test.mdb") >>> res <- sqlQuer

Re: [R] Query an Access database based on a date attribute (Tudor Bodea)

2007-11-13 Thread Emmanuel Charpentier
Baize, Harold a écrit : > Tudor Bodea asked: > >> In this context, I try to get all the records for which market is atl-bos, >> competitor is delta and dd is 2007-11-20 (first record above). To do this I >> used > >>> # channel <- odbcConnectAccess("test.mdb") >>> res <- sqlQuery(channel, "selec

Re: [R] Query an Access database based on a date attribute (Tudor Bodea)

2007-11-13 Thread Baize, Harold
Tudor Bodea asked: >In this context, I try to get all the records for which market is atl-bos, >competitor is delta and dd is 2007-11-20 (first record above). To do this I >used >># channel <- odbcConnectAccess("test.mdb") >>res <- sqlQuery(channel, "select * from test_table where market = 'atl-

Re: [R] R: Query an Access database based on a date attribute

2007-11-13 Thread Tudor Bodea
Stefano > -Messaggio originale- > Da: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] conto di Mark Wardle > Inviato: martedì 13 novembre 2007 11.59 > A: Tudor Bodea > Cc: [EMAIL PROTECTED] > Oggetto: Re: [R] Query an Access database based on a date attribute > > &g

[R] R: Query an Access database based on a date attribute

2007-11-13 Thread Guazzetti Stefano
is helps, Stefano -Messaggio originale- Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] conto di Mark Wardle Inviato: martedì 13 novembre 2007 11.59 A: Tudor Bodea Cc: [EMAIL PROTECTED] Oggetto: Re: [R] Query an Access database based on a date attribute On 12/11/2007, Tudor Bodea <[E

Re: [R] Query an Access database based on a date attribute

2007-11-13 Thread Mark Wardle
On 12/11/2007, Tudor Bodea <[EMAIL PROTECTED]> wrote: > Dear useRs, > > I would like to query an Access database through R based on a date attribute > but, unfortunately, I fail to do so. For example, the table test_table of the > test.mdb looks like: > >ID cd market competitor

Re: [R] Query an Access database based on a date attribute

2007-11-12 Thread Prof Brian Ripley
This is a question about SQL, or more precisely, Microsoft's peculiar dialect of SQL. You haven't even mentioned (let alone credited) package RODBC which you appear to be using. In SQL queries you need to quote numeric values if you want them to be treated as character. Why did you quote 'alt

[R] Query an Access database based on a date attribute

2007-11-12 Thread Tudor Bodea
Dear useRs, I would like to query an Access database through R based on a date attribute but, unfortunately, I fail to do so. For example, the table test_table of the test.mdb looks like: ID cd market competitor dd price 1 1 2007-11-20 atl-bos delta 2007-11-20 210 2