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
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
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-
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
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
5 matches
Mail list logo
