similar to: Muliple SQL statements / Return percentage of rows

Displaying 20 results from an estimated 9000 matches similar to: "Muliple SQL statements / Return percentage of rows"

2009 May 15
2
Help with loops
Hi I am trying to create a loop which averages replicates in my data. The original data has many rows. and consists of 40 column zz[,2:41] plus row headings in zz[,1] I am trying to average each set of values (i.e. zz[1,2:3] averaged and placed in average_value[1,2] and so on. below is my script but it seems to be stuck in an endless loop Any suggestions?? for (i in 1:length(average_value[,1])) {
2009 May 15
1
Fw: Help with loops(corrected question)
--- On Fri, 15/5/09, Amit Patel <amitrhelp at yahoo.co.uk> wrote: > From: Amit Patel <amitrhelp at yahoo.co.uk> > Subject: Help with loops > To: r-help at r-project.org > Date: Friday, 15 May, 2009, 12:17 PM > Hi > I am trying to create a loop which averages replicates in > my data. > The original data has many rows. and consists of 40 column > zz[,2:41]
2006 May 10
0
Passing Muliple Parameters with remote_function
<select name="media" id="media" onchange="<%= remote_function( :url => { :action => :show_performer_categories, :rate_group_id => @rate_group }, :with => "''media_id=''+this.value''" ) %>"> I''m guessing that''s wrong since WebRick does nothign when I
2011 Aug 25
0
plotting muliple CI ellipses for lm estimates
Hi, I have read your post about plotting multiple CI ellipses and I would like too, but I don?t know how. I would like to plot an ellipse for each group and I have slope and intercepts, but I don?t know what to put in the arguments shape and radius. CAn you help me please?
1999 May 25
1
Muliple partial matches with pmatch
I am using R0.64.1 under Windows 95. The help for `pmatch' states that: If `duplicates.ok' is false multiple matches will result in the value of `nomatch' being returned, and if it is true, the index of the first matching value will be returned. The help for pmatch gives the following examples: pmatch("m", c("mean",
2008 Apr 13
1
plotting muliple CI ellipses for EB estimates
I have empirical Bayes estimates for slopes and intercepts for a number of subjects and I would like to plot the slopes and intercepts with confidence ellipses. These ellipses would be based on the confidence intervals for the slope and intercepts (forming the major and minor axis of each ellipse), and the correlation in the slope and intercepts. The ellipse function in the car library
2013 Nov 05
1
How can I use muliple cores of CPU in Windows or OS X?
Dear all, I have about 50 pages of R codes and ran it in both OS X and Windows. It takes at least haft a day to have the results. The running time is not very different in both Systems. I found that R does not use all cores of CPU by default. Can anybody help me to use all cores of CPU in my programming from the beginning or through programming in both OS X and Windows? Many thanks your
2004 Dec 20
1
muliple plots with pairs (matrix of scatter plots)
I am trying to make a graph with 4 scatter matrixes plots and couldn't do it. While trying to find a solution for this I also came across the idea of giving different values to the same argument for each of the lower and upper function but couldn't do it. (Examplified below with the col argument). The first problem of plotting 4 scatter matrixes in a graph is a problem of real
2011 Jun 22
2
Panic: doveadm quota get -A
Hi, I'm new to the list and I'm using dovecot since 2 months. Still in progress to migrating from Stalker (Communigate Pro) to Dovecot. Today I upgraded from Dovecot 2.0.13-0~auto+27 (used form the Mirror xi.rename-it.nl - stable-auto) to 2:2.0.13-0~auto+48. List of installed packages: ii dovecot-common 2:2.0.13-0~auto+48 secure mail server that supports
2010 Jun 21
2
Panic: file doveadm-print-table.c: line 56 assertion failed
Hi Timo, `doveadm -f table mailbox status -u bar all inbox\*` aborts with: Panic: file doveadm-print-table.c: line 56 (doveadm_calc_header_length): assertion failed: ((value_count % hdr_count) == 0) Backtrace is attached. Regards, Pascal -- The trapper recommends today: c01dcofe.1017215 at localdomain.org -------------- next part -------------- An embedded and charset-unspecified text was
2008 Sep 22
1
Ccreating methods on the fly / counting distinct field values
Hi, I''m pretty new to ruby and rails, so apologies if this has been covered before (I couldn''t find a thread on it). I want to retrieve a count of records held in the DB for every distinct value of an attribute. E.g. given a class Address with a postcode field, I would like to retrieve an array of ValueCount objects. The ValueCount object would hold the value retrieved from
2006 Feb 22
2
loggin of sql statements
Is there a way to have rails log the sql statement that it runs. It would be much easier for me to debug my code if I could actually see the sql that active record is using. Charlie recentrambles.com -> use Time not DateTime -------------- next part -------------- An HTML attachment was scrubbed... URL:
2010 Dec 11
1
Can be Xapian used to perform standard SQL statements?
Hello, I'm developing an HTTP application server dedicated to IR. The server side languaje is Javascript throught the Webkit Javascript engine exposing several C++ libraries conforming the commonjs specs. My question is, can Xapian be used to perform standard SQL statements like inserts or updates? I undestand that Xapian does it when you perform a query or save a document but I haven't
2010 Oct 03
1
Package for converting R datasets into SQL Server (create table and insert statements)?
Hi, R contains many good datasets which would be valuable in other platforms as well. My intention is to use R datasets on SQL Server as a sample tables. Is there a package that would do automatic conversion from the dataset "schema" into a SQL Server CREATE TABLE statement (and INSERT INTO statements)? For example. > str(cars) 'data.frame': 50 obs. of 2 variables: $
2008 Sep 02
2
SSL fields as variables for SQL statements ...
Hi, I was wondering if there is any possibility to access the status if a user has provided a certificate, that has been accepted or not via variables. And further if there is any way to get the value of SSL certificate fields by use variables. I'd like to use those variables in sql statements. I then could assign a single certificate to a user, and make up passdb sql statements, that
2007 Aug 15
1
Geodata SQL statements with multiple results in the controller
Hi Everyone- In my project I need to take a zip code and get all the schools within the selected mile radius of that zip code. In addition I will need to check to see if the user selected any other items to add to the search. My problem is the geo code will return multiple results and I need to get that result into the final sql string. The flow is this: Get the zip code and mile radius the
2017 Oct 19
0
[Bug 1193] New: Incorrect malloc for SQL statements and missing strings length check
https://bugzilla.netfilter.org/show_bug.cgi?id=1193 Bug ID: 1193 Summary: Incorrect malloc for SQL statements and missing strings length check Product: ulogd Version: SVN (please provide timestamp) Hardware: All OS: All Status: NEW Severity: major Priority: P5
2010 Mar 24
2
translating SQL statements into data.table operations
I've recently stumbled across data.table, Matthew Dowle's package. I'm impressed by the speed of the package in handling operations with large data.frames, but am a bit overwhelmed with the syntax. I'd like to express the SQL statement below using data.table operations rather than sqldf (which was incredibly slow for a small subset of my financial data) or import/export with a
2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
Hi everyone, I am desperately looking for a method to interpolate strings within an SQL statement as follows: I get a lot of rows out of a database (in my example POSITION_to_ZIPCODE Database with holds records for German ZIP Code <--> Gauss-Krueger Coordinate System ) and want this to be selected and computed individually row by row as follows: library(RODBC) channel <-
2004 Dec 13
3
Percentages in contingency tables *warning trivial question*
I hesitate to post this question in the light of recent threads, indeed I have hesitated for several weeks, however I have come to a full stop and really need some help if I am going to progress. I am a new user of R for medical statistics. I have attempted to read all the relevant documents, but would welcome any suggestions as to what I have missed. I am trying to contruct "table 1"