Displaying 20 results from an estimated 800 matches similar to: "uninitialized constant"
2008 Apr 23
0
self referential (n-n relationship) belongs many controller
Hi all,
I ve some troubles in my small acpplication (only 2 tables).
I want to follow up tasks but these tasks are linked to others tasks.
So I ve tried to do store the nn relationship in other table called
links
1st table : tasks
columns : id | infos neutral... (as title, description etc ...)
-----------------------------------------------------------------------------------
model :
class
2007 May 19
0
database outputting results twice per page (using pagination + sorthelper)
Each page is getting the same 5 db results listed twice, I cant seem
to figure out why
this is how the page look
page 1:
post 1
post 2
post 3
post 1
post 2
post 3
page 2:
post 4
post 5
post 6
post 4
post 5
post 6
template
------------------------------
<%= render_collection_of_partials "upcoming", @albums_pages %>
view (sorry its big)
------------------------------
<%
2006 Apr 16
11
Best way to sort categories w/ pager
Ahoy,
I made this pager,
" def list
@item_pages = Paginator.new self, Item.count, 10, @params[''page'']
@items = Item.find :all, :conditions => "category_id =
#{params[:condition]}",
:limit => @item_pages.items_per_page,
:offset => @item_pages.current.offset
@categories = Category.find_all
2010 Feb 01
3
merging data frames gives all NAs
Dear kind R helpers,
I have a vector of runway names in rwy ("31R", "31L",... the number is
user selectable)
arrgnd is a data frame with data for all flights and all runways, with a
Runway column.
I am trying to subset arrgnd into a dat frame for each selected runway,
and then combine them back together using the following code:
for (j in 1:nr) { # nr = number of
2010 Aug 27
1
Using relevance when sorting by generated key
Hi all,
I am trying to implement a scheme where documents in an MSet will be
sorted based on relevance as well as geographical distance from a given
(non-fixed) point.
I understand that this can be accomplished by using PostingSource in
order to implement a custom weighting scheme that would combine BM25
weighting and distance. The problem is that I am using perl and
PostingSource is not
2006 Feb 22
2
Using ez_where
Hi All,
I am trying to pass values to ez_where to construct my conditions. I
need
to know how the params need to be formated for ez_where.
My search class looks like this:
def search
@display_ad = DisplayAd.new(params[:display_ad])
cond = Caboose::EZ::Condition.new do
pub_date == ''@display_ad.pub_date''
io_number =~
2006 Jan 30
2
:condition not being applied
I am using acts_as_taggable and everything seems to be working except that
:condition => "tags_resources.portal_id=#{portal_id}"
is not being applied.
@resource_pages = Paginator.new self, Resource.find_tagged_with(:any => tag, :condition => "tags_resources.portal_id=#{portal_id}").length, 25, @params[''page''];
@resources
2009 Jan 29
1
Xapian Ruby bindings do not implement full multi-value-sorting functionality?
Hello,
this is a question that could be answered by collaborators of the Ruby
bindings.
Today I've played around with the Xapian::MultiValueSorter class. I've set
everything up and then I tried following on an instance of Xapian::Enquire:
:
enquire = Xapian::Enquire.new(database)
enquire.query = options[:query]
:
sorter = Xapian::MultiValueSorter.new
sorter.add(0, true)
sorter.add(1,
2011 Sep 13
4
Changing adapters in ActiveRecord does not change the generated sql
If I establish a new connection with a new adapter (ie. switch from mysql to
postgresl) the generated sql is still mysql specific. I tried all sorts of
reset methods on AR::Base but to no avail. There must be something being
memoized on ActiveRecord base that has to do with the adapter and it doesn''t
get cleared when you establish a connection with a new adapter.
I know this
2010 Mar 20
3
How to select a row from one dataframe that is "close" to a row in another dataframe
I have two data frames of flight data, but they have very different
numbers of rows. They come from different sources, so the data are not
identical.
> names(oooi)
[1] "FltOrigDt" "MkdCrrCd"
[3] "MkdFltNbr" "DprtTrpnStnCd"
[5] "ArrTrpnStnCd" "ActualOutLocalTimestamp"
2006 Apr 15
2
ez_where : i''m puzzled
I have the following code:
condition_clause = "%#{@phrase}%"
logger.info "condition is #{condition_clause}"
unless @phrase.nil?
condition = Caboose::EZ::Condition.new :affiliates do
affiliate_name =~ "%#{@phrase}%" # <<< here''s the problem
end
options[:conditions] = condition.to_sql
logger.info "ajax
2010 Jan 16
3
Comparing dates in dataframes
I have two data frames. One (arr) has all arrivals to an airport for a
year, and the other (gw) has the dates and quarter hour of the day when
the weather is good. arr has a Date and quarter hour column.
>names(arr)
[1] "Date" "weekday" "hour" "month" "minute"
[6] "quarter" "ICAO"
2011 May 11
2
Issue with Arel::SelectManager and insert Method
Hello,
Arel::SelectManager (arel 2.0.9) uses following statement to insert a
new record:
@engine.connection.insert im.to_sql, ''AREL'', primary_key_name,
primary_key_value
But in DatabaseStatements insert ist defined as:
insert(sql, name = nil, pk = nil, id_value = nil, sequence_name = nil)
Actually, Arel::SelectManager does not use the sequence name. This
leads to issues
2008 Sep 17
13
Capturing the sql from a statement without executing it?
Hi guys,
Is there an elegant way to capture the sql that would have been
executed by an ActiveRecord statement, without actually executing
it? :)
I''m imagining something like
sql = User.find(1).groups.to_sql
or perhaps
sql = ActiveRecord::Base.capture_sql { User.find(1).groups }
resulting in sql = ''SELECT * FROM groups INNER JOIN memberships....
WHERE users.id =
2006 May 23
3
ez-where headscratch
Hi there,
I''m puzzled by this apparently simple query I can''t manage to reassemble
using ez_where plugin.
cond = Caboose::EZ::Condition.new :my_table do
start_on < Time.now
any {end_on > Time.now; end_on.nil?}
end
I keep getting the following result :
>> cond.to_sql
=> ["my_table.start_on < ? AND (my_table.end_on > ?)", Tue May 23
2010 Feb 01
6
Import fixed-format ascii file with mixed record types
I need to import several ascii files in fixed format with two different record types. The data comes from European Labor Force Surveys, wich is a household survey. The first record type is for people over 16 years, and the second much sorter is for people aged 15 or less (this record has a filler with several blanks to get the same record length).
The files tipically have 160000 records, with 176
2009 Apr 23
1
Failing to print mer object in an RData image
Hi all
I have problems in accessing a mer object called model.01 from a
workspace that was created with R 2.8.1 and saved with save into an
.RData file (on Windows XP or Ubuntu 8.10, don't remember anymore).
Now I want to open it in R 2.9.0 on Ubuntu 8.10. I use
# load workspace
load("name.RData")
which seems to work:
ls() # all objects in there
[1] "all"
2005 Apr 17
3
Minimum distance
G'day, I have a matrix 20000 x 500 populated with all the distances
between a list of airports and a list of towers. What I'm having trouble
doing is finding the closest airport to each tower, Any help would be
greatly appreciated.
Regards,
Michael Williams
[[alternative HTML version deleted]]
2010 Apr 12
2
[PATCH] Access to more Arel predicate types from where condition hash
I could use some eyes on https://rails.lighthouseapp.com/projects/8994/tickets/4368
if anyone has the time.
Summary of the change:
Similar to PredicateBuilder''s existing support for ''table.column'' =>
''value'', this patch enables ''column#method'' => ''value''.
For instance,
2010 Oct 09
1
Loss of precision in read.csv.
Given a csv file from this location
Airports<-"http://www.ourairports.com/data/airports.csv"
download.file(Airports,basename(Airports))
airports <-read.csv("airports.csv",encoding="UTF-8")
> airports[1,]
id ident type name latitude_deg longitude_deg
elevation_ft continent iso_country iso_region municipality scheduled_service
1 6523