similar to: Query an Access database based on a date attribute

It seems that Access needs that you surround the dates with a # symbol. You probably need something like. res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos' and competitor = 'delta' and dd = #2007-11-20#") Hope this helps, Stefano -----Messaggio originale----- Da: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]Per

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-bos' >>and competitor = 'delta' and dd =

Dear useRs: Is there a way to include a raster image (e.g., .gif, .jpg, .bmp) representing a company logo, a school logo, etc. into an R graphic? For example, it would be nice to be able to include the logo of the school into the charts that a student produces for her dissertation. Similarly, while working on a competitive analysis, it would be nice to be able to replace the names of the

Dear useRs, Do you know, by any chance, if it is possible to write a string in the header/footer of a pdf file created during a plot session? To make sure that I know what R script generated a certain chart, I would like to add the path to the working directory into the header/footer of the corresponding pdf file. Thank you. Tudor -- Tudor Dan Bodea Georgia Institute of Technology School of

Dear useRs: Please provide me with your thoughts on an issue related to the design of a production level system. For example, let?s suppose that I need to run the same R script for a finite sequence of items (e.g., in the energy industry, I may need to asses the profitability of all gas stations in the state of Florida). For each of the items, the R script accesses some remote databases, gets

Dear UseRs: I intend to write a package to handle the basic operations a revenue management analyst has to deal with on a regular basis (e.g., demand untruncation, capacity allocation, pricing decisions, etc.). Following the directions posted by Peter Rossi (Making R Packages under Windows: A Tutorial, January 2006) I was able to build an interim package that currently consists of one simple

Dear R users: Is there a way to append selectively to components of a list (if possible, loops are to be avoided)? To illustrate the point, in the example below, I would like to append 99 to vector b of the list l. > l <- list(a=c(1), b=c(2,3), c=c(4,5,6)) > l $a [1] 1 $b [1] 2 3 $c [1] 4 5 6 As you may expect, the result should look like: > l $a [1] 1 $b [1] 2 3 99 $c [1] 4 5

Hi, I have a test_table where the dim is 62220 by 73 (row by col) I would like to partition the rows into 170 equal parts (170 tables where each is of dim 366 by 73), and rearrange them horizontally. The source codes I have: for (i in 1:170) { c = cbind(c,test_table[(367*i+1):(367*(i+1)),2:73]); } Unfortunately, using for loop and cbind for a table of this size

>> >> >> Hi All, >> >> After getting licences for Skype for asterisk a while ago I finally got >> around to setting up a server with two channels and setting up a bcp on >> the skype end. >> >> The idea behind this is the following: >> >> Users can dial into the PBX, get authenticated and only after> >>

Hello, I'm trying install Samba 4 by this link http://wiki.samba.org/index.php/Samba4/HOWTO . The step 2 compile and step 3 install completed, but step 4 provisionhas following error: [root@samba4 setup]# ./provision --realm=sfa.local --domain=sfa --adminpass=5555 --server-role='domain controller'Traceback (most recent call last): File "./provision", line 32, in ?

Hi, table1D() below can be up to 60x faster than base::table() for the 1D case. Here are the detailed speedups compared to base::table(). o With a logical vector of length 5M: 11x faster (or more if 'useNA="always"') o With factor/integer/numeric/character of length 1M and 9 levels (or 9 distinct values for non-factors):

Hi, I am trying to find out the scale efficiency and optimal scale of banks by stochastic frontier analysis given the panel data of bank. I am free to choose any model of stochastic frontier analysis. The only approach I know to work with R is to estimate a translog production function by sfa or other related function in frontier package, and then use the Ray 1998 formula to find the scale

This is driving me nuts. I'm trying to compile an MFC application using WINE. I can specify the location of the ATL includes and configure is quite happy but it chokes when I give it the MFC includes in the same way: ./configure --with-atl-includes=/home/wade/VC98/atl/Include --with-mfc-includes=/home/wade/VC98/mfc/Include Wassup? I'm using Winemaker 0.5.5 And wine

I am trying to send calls from (telx-NY17S) to (telx-nyc) via an IAX2 channel. However the call is being rejected on the (telx-nyc) server. See error below copied from telx-nyc CLI> Apr 22 13:56:57 NOTICE[147465]: chan_iax2.c:5390 socket_read: Rejected connect attempt from 192.168.0.251 I have icluded the following conf files 1. extensions.conf (telx-nyc) 2. iax.conf (telx-nyc) 3.

i found model allway query this sql: SHOW FIELDS FROM test_table if my code needn''t know table structure, how to remove it? -- Posted via http://www.ruby-forum.com/.

By the way, I am currently testing this product from Skype. I would like to be able to receive calls ona Skype name on our pbx. 1) It works beautifully and you don't have to do anything in particular. 2) It's disproportionally expensive which is why I want Skype for Asterisk to work. SfS costs $5 per month per channel just to test the beta! I find that insane, but I wanted to test it.

Hi, after having tested SFA in august, I didn't use it for some times and now I receive the subject error when calling through Skype channel. Has anyone an idea on what can be the problem? Thanks -- Daniel

Hi, I've been building wine from source for years, originally because I needed some custom patches, nowadays out of habit. Just now I'm trying to build 1.3.8, but I get an error during build: make[1]: Entering directory `/home/peter/src/wine/dlls/atl' gcc -m32 -c -I. -I. -I../../include -I../../include -D__WINESRC__ -D_REENTRANT -fPIC -Wall -pipe -fno-strict-aliasing

<head><style>body{font-family: Geneva,Arial,Helvetica,sans-serif;font-size:9pt;background-color: #ffffff;color: black;}</style></head><body id="compText">Several weeks ago, wine made changes that stopped the audio working for me, and I had to stop using NatSpeak. <br>I deleted my wine prefix at some point. <br>In the last day or so, I''ve

I gueess it is not a DNS problem, because either using name or IP, I have always the problem. I guess the problem is that I am using ssh on inetd.conf (sshd -i), so It has to generate a key each time I start a session. What do you think ? -----Mensagem original----- De: Dan Kaminsky [mailto:dan at doxpara.com] Enviada em: segunda-feira, 10 de junho de 2002 20:51 Para: Jorge Cleber Teixeira de