similar to: RMySQL, RODBC, dbReadTable and ISO-8859-1 (Spanish data)

I only want to load a limited number of rows by dbReadTable(). I don't see an option in the help. Is there an option to do so?

> tbs<-dbListTables(con) > > tbs [1] "lowend" "time" "week30" "week33" "week39" "week42" > my.data.copy <- dbReadTable(tbs, "week42") Error in function (classes, fdef, mtable) : unable to find an inherited method for function "dbReadTable", for signature "character",

HI, I got the problem. I use the following query to read table individually, how can I read all tables autimatically rather than typing "week42" "week33" in dbReadTable? library(RSQLite) library(sqldf) drv <- dbDriver("SQLite") con<-dbConnect(drv, "sqlite.db") dbListTables(con) #dbRemoveTable(con, "week39") dbDisconnect(con)

Hi Guys, I''ve got a rails application that uses activeldap to authenticate users. Its been working great for about 6 months now, but a user from mexico started using it recently, but can''t seem to login. I''ve narrowed it down to the fact that his password contains a ñ character in it. This problem is also present in a test user account I''ve setup. ActiveLDAP

Hi. I have the same problem, which described in: http://lists.xensource.com/archives/html/xen-users/2010-07/msg00241.html I''m using Debian Squeeze (2.6.32-5-xen-amd64) in Dom0, Xen 4.0.1-rc6, Windows 2008, 2003 x86_64 in domU After installing drivers from http://www.xen.org/files/XenCloud/Software/0.5/XCP-base-0.5.iso, system stops on progress bar in normal boot, but ok in safe mode. In

Buenas tardes a todos: No sé si alguno de vosotros sabe si con R es posible buscar una palabra en una web (por ejemplo, buscar "Alicante" en www.lasprovincias.es) y que, cada vez que lo encuentre, vaya almacenado las urls en un data.frame gracias de antemano! -- Beatriz Martínez [[alternative HTML version deleted]]

Estaba usando el ESS pero me he dado cuenta que si tiene csv, yo lo bajé de aquí en formato SPSS pero me da el error de falta de memoria http://www.europeansocialsurvey.org/downloadwizard/ 2017-06-27 10:38 GMT-05:00 Freddy Omar López Quintero < freddy.lopez.quintero en gmail.com>: > > 2017-06-27 11:34 GMT-04:00 Antonio Rodriguez Andres < > antoniorodriguezandres70 en

I am using R 2.8 and the latest versions of RMySQL on a Windows XP 64 bit machine. I was wondering if someone could help me figure out how to use dbWriteTable without inserting \r into my table. Consider the following code snippet, which is run after I connect to my database. myDFOut = dbReadTable(conn, "myDF") print(myDFOut) myDFIn = data.frame(x=paste("x", 1:5, sep =

Buenas tardes: Soy Pedro José Martínez, del Departamento de Economía Financiera y Contabilidad de la Universidad de Murcia y tengo una duda sobre R. Mi investigación se basa en calcular la eficiencia de los servicios municipales con DEA (packages deaR), y posteriormente identificar los determinantes de dicho nivel con una regresión truncada (packages truncreg). Para calcular la eficiencia

Dear R users, I need to to the the following. Let a= 1 2 3 4 5 6 and b= -1 -2 -3 be (2x3) matrices. -4 -5 -6 I need to combine the two matrices into a new (2x6) matrix like this: ab = ( 1 -1 2 -2 3 -3 ) 4 -4 5 -5 6 -6 How can this be done in R? ----------------------------------------------------------------- ?????? ???

Anybody knows some graphic reporting/analysing program for shorewall 4.0.7 or i have to do it by accounting? -- Javier Martínez Technical Manager ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

Perfecto! muchas gracias Carlos; la verdad que estuve un buen rato intentándolo, pero aún no comprendo la estructura de lattice, así que modificaba cosas un poco al tuntun. Tengo otra cuestión un poco más controvertida, no sé si este será el foro adecuado para proponerla o supondrá un debate innecesario.... Como os decía, acabo de iniciarme en R, y estoy explorando las opciones de visualización.

There is a little problem in handling logicals in RMySQL: # here is the MySQL connection > con <MySQLConnection:(1816,0)> # here is the data frame > print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE))) x y 1 TRUE FALSE 2 FALSE TRUE # as promised, the two data frame columns are identified as logicals and # the field types are set to tinyint > field.types <-

Hello, Is it possible to create a custom template for XCP? Or edit an existing one? I know that I could create a VM and then exported as a template, but I would prefer to create a template like "Debian Lenny 5.0" that install debian from the network but with 64bits instead of the 32bits used by the template. -- Angel L. Mateo Martínez Sección de Telemática Área de Tecnologías de

Hola, Beatriz: Buscando en ?order derivé en arrange, y al final es como resolví: arrange(my.df, col1, desc(col2)) Con order no conseguía el orden descendente, pues me daba error al intentar hacer order(-my.df$col1) Gracias. Eva ________________________________ De: Beatriz Martínez <mtnezb@gmail.com> CC: r-help-es <r-help-es@r-project.org> Enviado: Martes 16 de julio de 2013

Hello, Can you check following entrys: Old: disk = [''phy:vm_volumes/root.dhcp1,sda1,w'', ''phy:vm_volumes/var.dhcp1,sda2,w'', ''phy:vm_volumes/swap.dhcp1,sda3,w''] New: disk = [''phy:/vm_volumes/root.dhcp1,sda1,w'', ''phy:/vm_volumes/var.dhcp1,sda2,w'',

Hi According to vorbis I spec, there are several configurations. There are 2 formats of floor, 3 formats of residue and 3 look up types of VQ codebook, etc. I think to get all kinds of vorbis file with these configurations but what I have got from network only support some of the formats (Ex. floor1, residue 1 & 2, VQ lookup type0 & 1). I downloaded several freeware vorbis encoder

Hi comunity, i have implemented in my company a small samba server only use for sharing proposes. Mi problem is simple, in the config i set the directives "client min protocol = SMB2" and "client max protocol = SMB3_11". Acording to this 2 directives a client with Windows XP can't connect to my server, but i have 2 clientes using that OS and conncect without problems.

Hí everybody, you have a nice day. I am configuring accounting in shorewall /etc/shorewall/accounting and the traffic between eth0 (local network)1, eth2(local network2) and eth3(local network3) &lt;--&gt; eth1(ip public network), works fine. I make the accounting because y want to control the remote vpn access(pptpd) throught shorewall. Which is the way to control vpn /ip/access in

I am trying to read and write database tables that have a date field in them. I am constructing a data.frame, then using dbWriteTable to create the table and dbReadTable to read it. >datatbl<-data.frame( dates, trialnum, fooddel, ethdel, trialtime, trialtype, deliveries, food, ethanol, fcumrec, dcumrec, rrf, rrd) >ifelse(startdate==filelist,