similar to: Using SQL to get a whole record when using aggregate functions

Displaying 20 results from an estimated 2000 matches similar to: "Using SQL to get a whole record when using aggregate functions"

2006 Jan 02
2
HTML Fragment not Loading in Firefox; Fine Elsewhere
Ok, this has got me going a bit crazy. I have an HTML fragment being returned for the result to an AJAX query. It works fine in Safari or from curl (and even in IE/Mac), but utterly fails to load in Firefox, even if I point directly to the URL, skipping all that AJAX stuff in between. (The server logs show a 200 response, regardless of which browser is being used.) I''ve verified
2006 Jan 02
2
Getting Index When Using render :partial
I''m using a web service to retrieve an array of results to a search and a render :partial to display those results to the user, while at the same time putting the results into the session. Is there a way for my _book.rhtml file to have access to the index of the result currently being displayed, like each_with_index makes available to its block? This would allow me to have the
2006 Jan 02
3
Re: Getting Index When Using render :partial (Benjamin Stiglitz)
Thanks for the suggestion, Ben. This seems an excellent approach to the problem, except that I''d been under the impression that one could only call render once. If you call it multiple times as the each_with_index loop iterates, are the results just combined automatically? How does that work? Thanks! Sean ----- Sean McMains AIM: SeanMcTex http://www.mcmains.net/ruminations On
2011 Dec 03
1
Reading multiple text files and then combining into a dataframe
I have a multiple text files, separated by a single space, that I need to combine into a single data.frame. Below is the track I'm on using list.files to capture the names of the files and then lapply with read.table. But I run into problems making a usable dataframe out of the data. #Creating example data in similar format to data I have sub <- rep(1,10) trial <- seq(1,10,1) size
2006 Jun 02
2
State of the Art in Login?
Hi folks, I''ve got an older project I''ve used LoginGenerator for. It works pretty well, but lacks password resetting, etc. Now I''ve got a new project for a client that''s going to need login capabilities as well. I''ve been looking at the Salted Login Generator and the Login Engine, and have taken quick stabs at running through the installation
2011 Aug 05
1
matrix into vector with vertex names
Using Igraph, I create shortest paths, then convert the matrix into three column vectors - "vertex1", "vertex2", "shortestpath" - as the code below shows. #code for generating shortest path matrix and creating a 3 columns from an igraph graph object "y" y_s<-shortest.paths(y, weights = NULL) y_s <- melt(y_s)[melt(upper.tri(y_s))$value,] #Step 2: this
2007 Aug 06
0
[LLVMdev] Spillers
Hi, David. Spill intervals must be precolored because they can't be spilled once more. They are the shortest intervals precisely over each def/use of the original interval. That is why they also have their weights set to #INF. Imagine that on a second iteration allocation algorithm figures out that some spilled interval can't be assigned a physical register. Allocator can't spill it
2017 Jun 20
2
Problem with shortestPath in igraph and qgraph
hello, I have a graph and i use qgraph package to calculate centrality parameters. Now I want to know the maximum value of shortest path for each vertex with discarding the Inf value in short pathes. For this I use the ShortestPathLengths of centrality function in qgraph. but when I want to get the maximum the result is wrong. here is my code: cen<-centrality(Q)
2009 Oct 20
1
kendall.global
Hi every body: I need some help with kendall.global. The example in the manual seems not working well, and cannot used with my data, always the same error. data(mite) > mite.hel <- decostand(mite, "hel") > > # Reproduce the results shown in Table 2 of Legendre (2005), a single group > mite.small <- mite.hel[c(4,9,14,22,31,34,45,53,61,69),c(13:15,23)] >
2008 Mar 20
1
minimum distances
Hi, I have a question about computing shortest Euclidean distances between two data frames of spatial points... I have 2 dataframes (not yet converted to spatial class) >Sewers<-data.frame(x=c(10,20,35,50),y=c(100,150,200,300)) >transect <- data.frame(x=seq(from=0, to=50, by=1),y=seq(from=100, to=150, by=1)) I would like to be able to compute the shortest distance from the
2008 Aug 24
3
Igraph library: How to calculate APSP (shortest path matrix) matrix for a subset list of nodes.
Dear R Users, I have a network of 25000 total nodes and a list of 500 node which is a subset of all nodes. Now I want to calculate the APSP (all pair shortest path) matrix only for these 500 nodes. I would appreciate any help. Thanks in advance Dinesh -- Dinesh Kumar Barupal Research Associate Metabolomics Fiehn Lab UCD Genome Center 451 East Health Science Drive GBSF Builidng University of
2017 Jun 21
0
Problem with shortestPath in igraph and qgraph
Hard to follow data analysis without data. Try making your example reproducible [1][2][3] and post in plain text (a setting in your emailer). Read the Posting Guide mentioned in the footer to avoid other posting pitfalls. [1] http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example [2] http://adv-r.had.co.nz/Reproducibility.html [3]
2007 Aug 06
4
[LLVMdev] Spillers
On Monday 06 August 2007 12:15, Anton Vayvod wrote: > Spill intervals must be precolored because they can't be spilled once more. > They are the shortest intervals precisely over each def/use of the original > interval. That is why they also have their weights set to #INF. Yes, that's true. But I wonder if we shouldn't be smarter about which register we pick to color it.
2003 Sep 26
3
An interesting call path observation..
This is not really a problem just something I noticed in my testing.. When two or more Asterisk servers are connected by IAX2 trunks it does not make use of any "shortest path" type system.. (maybe this is still planned somwhere down the line, but may come in handy to those who have multi asterisk installations) Here is the setup.. UA1--- Asterisk1----[IAX2 Trunk]---Asterisk2---UA2
2007 Sep 06
1
computing distance in miles or km between 2 street addresses
Hi R-ers: I need to compute the distance between 2 street addresses in either km or miles. I do not care if the distance is a "shortest driving route" or if it is "as the crow flies." Does anybody know how to do this? Can it be done in R? I have thousands of addresses, so I think that Mapquest is out of the question! Please rely to: philipsmith at alumni.albany.edu Thank
2009 Mar 20
1
CCA - manual selection
Hello, I am trying to obtain f-values for response (independent) variables from a CCA performed in vegan package, to see which ones of them have significative influence in my dependent variables (like the manual selection in canoco), but I can't find any function (or package) that do such a thing. The dependents variables are species data, and the independents are ambiental data. Than you.
2006 Apr 30
4
Migration, BigInts, and string lengths
Howdy Y''all, I was thrilled to recently discover migrations, as that framework addresses a common problem in an elegant way. I have, however, gotten tripped up a bit as I''ve worked with them. The first problem I encountered was that, though I was using a BigInt data type in a field in my dev database, my unit tests were failing because when I copied the schema from the dev
2006 May 22
6
which kind of deployment has the best performance
In the following deployment of web app on ONE pc-based server,running linux,which can support the most amount of concurrent users as well as the shortest latency? 1 apache+mongrel 2 apache+mongrel_cluster 3 lighthttpd+mongrel 4 lighthttpd+mongrel_cluster 5 lighthttpd+fastcgi Thanks charlie -- Posted via http://www.ruby-forum.com/.
2004 Jul 11
2
How to bring an Splus object into R
>From the `R Data Import/Export' manual, shipped with R, as well as available from the official R web site (last three paragraphs of Section 3.1, describing functions in the `foreign' package): Function read.S which can read binary objects produced by S-PLUS 3.x, 4.x or 2000 on (32-bit) Unix or Windows (and can read them on a di erent OS). This is able to read many but not all S
2011 Aug 20
4
I have a problem with R!!
Dear all i?m working with a program i?ve made in R (using functions that others created) to run my program i need a sample. if i generate the sample using for example, rnorm(n, mu, sigma) i have no problem but if i obtain a sample from a column in excel and i copy it, the program says that there is a mistake: it says "Error en `[.data.frame`(data, indices) : undefined columns