search for: testtabl

...ith this simple example: library(RSQLite) drv<-dbDriver("SQLite") con<-dbConnect(drv,"test.db") my.data<-data.frame(countries=c("US","UK","Canada","Australia","NewZealand"),vals=c(52,36,74,10,98)) dbWriteTable(con,"testtable",my.data) q<-dbReadTable(con,"testtable") q countries vals 1 US 52 2 UK 36 3 Canada 74 4 Australia 10 5 NewZealand 98 So, say, I want to change the value for NewZealand to '21' from '98' I've tried something like this: sql...

Hi, I have a binned data that looks like this. (8.048,18.05] (-21.95,-11.95] (-31.95,-21.95] (18.05,28.05] (-41.95,-31.95] 81 76 18 18 12 (-132,-122] (-122,-112] (-112,-102] (-162,-152] (-102,-91.95] 6 6 6 5 5 (-91.95,-81.95] (-192,-182]

Hi all; I have a custom iproute2 table and a few rules to go along with it (CentOS 5) -- I have added the table to /etc/iproute2/rt_tables. if-up and friends doesn't seem to handle this real gracefully. How are those of you out there doing something similar managing this customization? I don't really want to muck with /etc/init.d/network or the if-up scripts to avoid breaking upgrades.

...f a normal distribution. I'd loop this over all the rows in the data frame, and output the summary results to a new data frame. I have a loop that should run a Shapiro-Wilk test over each row, y= data frame for (j in 1:nr) { y.temp<-list(y[j,]) testsw <- lapply(y.temp, shapiro.test) testtable <- t(sapply(testsw, function(x) c(x$statistic, x$p.value))) colnames(testtable) <- c("W", "p.value") } but it is currently throwing out an error: "Error in `rownames<-`(`*tmp*`, value = "1") : attempt to set rownames on object with no dimensions&...

Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base), which has many different columns, among them a character column "X" with "integer-like" data as "0012345". Using sqlFetch, I'd like to assure that column X is read in as a character variable. So what I'm looking for is something...

...} } ``` As I get the following I my logs : ``` … OUTPUT NAT IP: IN … … ``` Today (15/08/2017) I wanted to replace the following iptables rule : ``` iptables -t nat -A OUTPUT -d … -p tcp --dport 80 -m owner \! --uid-owner nobody -j REDIRECT --to-port 12345 ``` I tried : ``` table ip testtable { chain testchain { type nat hook output priority 0; policy accept; ip daddr … tcp dport 80 meta skuid != nobody redirect to 12345 } } ``` But it didn't worked. I tried the tests I did back in may but "OUTPUT NAT IP" doesn't show...

Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base) with 3 columns and 1 row that looks like this: X Y Z 0012345 42 42,1 The columns are of these types: X - character, Y - Long Integer, Z - Decimal. I use RODBC to get these data into R: > library(RODBC) > channel <- odbcConnectAccess...

...python CGI that's behaving weirldy on Whitebox systems that've been switched over to CentOS 4 (ages ago, no other problems to speak of aside from this one). I've broken the problem down to a minimal test case... 1. Create a small database # sqlite3 /tmp/testcase.db 'CREATE TABLE testtable ( date date primary key unique, name varchar(32));' # sqlite3 /tmp/testcase.db 'insert into "testtable" values("2006-10-10", "Will");' # sqlite3 /tmp/testcase.db 'insert into "testtable" values("2006-10-11", "Will");'...

...g it out myself), but my searches on my own have not yielded any hints. I have many fields in my dataset that participants entered as "free lists" - i.e., the field constitutes a varying number of names each separated by a delimiter. The resulting data frame might look something like: testtable<- as.data.frame(cbind(c("Joe,Mary,Jane","Mary"),c("Fred,Joe","Pete,Joe,Mary,Fred"))) In actuality the names are typically multi-word organization names, but you get the idea... What I need to do is to convert these text strings into lists comprised of t...

...ion( :adapter => "mysql", :host => "localhost", # :username => "myuser", :password => "schumi58", :database => "test" ) puts "connection established" ActiveRecord::Schema.define do drop_table(:testTable) create_table(:testTable) do |t| t.column :name, :string end end I am also referring to Active Record''s rdoc but am not able to make out how to use the insert statement in the above code. Can anyone help me in using INSERT statement in my code above? Thanks, Anukul -- Poste...

Hi there I have been successfully using the asterisk command "MYSQL" to read information from a MySql database, but was wondering if there was any way of WRITING data (ie user input data) to the database ???, looking through the parameters of the MYSQL command it seems as though this function isn't available....is there another application for this??? Cheers

Hi all, I just begun with RoR and going through the Agile development w Rails depot example ATM. I did everything according to the book (i believe), and after 3 hours of googling, reading docs, making sure i did everything correctly i can not make the validate_presence_of() to work - at least not as it looks in the book. My Product model looks like: class Product < ActiveRecord::Base

Hi List! May I tap into your combined common sense ? I have a legacy logging app that needs to be modernized. At the moment, Data is going to be stored in 5 tables, one table is going to contain more than 200 million and 2 others about 60 million rows. Mysql will be used, unless someone sees a major advantage in using something else (at the moment data is stored in a raw positioned file format,

...lumn to be read in as character Message-ID: <E18FDA5C64FC5645A25B2B52EB8CC9CE0395BF9558 at EXCHMCA.tirol.local> Content-Type: text/plain; charset="us-ascii" Dear R-users, I am working with R version 2.10.1 and package RODBC Version: 1.3-2 under windows. Say I have a table "testtable" (in an Access data base), which has many different columns, among them a character column "X" with "integer-like" data as "0012345". Using sqlFetch, I'd like to assure that column X is read in as a character variable. So what I'm looking for is something...