Displaying 20 results from an estimated 10000 matches similar to: "Ambiguous clause error"
2006 Jun 14
4
Using now() to determine what should be displayed
I''m trying to create a paginated list that will take note of the
"end_date" field in my table. This is what I have:
@post_pages, @posts = paginate(:posts, :per_page => 10, :order_by =>
''end_date'')
in the controller. And for the view:
<h1>Posts ending soon</h1>
<ul><% for post in @posts do %>
<strong>Post Title:
2006 Jun 25
1
Sorting ferret results by column
I have the acts_as_ferret plugin installed. Everything searches great,
but I would like to limit the results (i.e. by ''end_date'') and sort them
(by ''end_date''). ''end_date'' is a valid column in my "posts" table.
Here''s the code I have already:
@posts = Post.find_by_contents(params[:query])
params[:query] comes from a form. I
2006 Jun 25
1
Using AND in :conditions queries
I have what amounts to a simple search engine running through a table
using input from a form. Everything works fine when looking for "title"
or "body" But, when I want to couple that with an AND statement the
search still works fine, but it seems to disregard the AND statements.
Code below:
In the view:
<%= start_form_tag :action=> "show_search" %>
2007 Jul 31
5
Group by clause
Hi
Does acts_as_ferret support a :group clause?
For e.g any rails options like :select or :group etc? or is it that it
supports only few of such options?Like it supports :include
Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://rubyforge.org/pipermail/ferret-talk/attachments/20070731/a74fb666/attachment.html
2011 May 19
1
update_attributes updates data from second instance of nested form but not the first
Got a weird situation with an update put to a controller with a form with
nested attributes.
On the data below, I am updating data for both items (''0'' and ''1'') in
rosters_attributes (in the example below I am updating the ''name'' attribute
to a new value in both cases. What I am stuck on is that ''1'' gets its data
updated,
2006 Jun 08
3
Foreign key confusion
I have 2 models right now: "users" and "posts". When a user creates a
post I would like their id to be recorded under "user_id" in the "posts"
table. Under the "user" model I have:
class User < ActiveRecord::Base
has_many :posts
end
And under the "posts" model I have:
class Post < ActiveRecord::Base
belongs_to :user
2006 Feb 28
6
Activerecord equivalent of the SQL "SUM()" function.
Search doesn''t seem to be working, so forgive me if I''m covering old
ground here, but I''m having a difficult time figuring out how to
implement a "SUM()" function using Active record. Obviously, I could
just create a query, but I''d rather make it part of my active record
object.
Basically I have an object called "Report <
2013 Mar 25
1
validates presence of foreign key fails in nested form
I''m using accepts_nested_attributes as follows:
class Timesheet < ActiveRecord::Base
attr_accessible :status, :user_id, :start_date, :end_date,
:activities_attributes
has_many :activities, dependent: :destroy
has_many :time_entries, through: :activities
accepts_nested_attributes_for :activities, allow_destroy: true
end
class Activity < ActiveRecord::Base
attr_accessible
2006 Dec 27
0
HABTM Checkboxes - Adding/Updating Users to a Project
Hello all,
I''m trying to create a HABTM checkbox action that adds/updates ''users''
to a ''project''.
I have the following laid out.
---------------------
TABLES
---------------------
create_table "assignments", :id => false, :force => true do |t|
t.column "project_id", :integer, :default => 0, :null => false
2006 Dec 11
1
Compute date during before_validation_on_create
Hello,
- the form posted by the user have a date field
- this date is begin_date, I need to compute end_date
- so, added callback before_validation_on_create
- in this method I do :
end_date = begin_date >> 12
- unfortunately, beeing in before_validation the actual self.begin_date
have not been type casted - It''s always a string
- unfortunately again, I can''t put this code
2005 Dec 29
1
Resolving ambiguous columns during a join
I am working with an existing schema and thus limited in how much I can
bend my existing column names. I have a table Users, and a table
ForumUsers, for which I have a "has_one" relationship - a user has_one
forumuser. When I look at my user records I wish to include some
information from forumuser:
@users = User.find :all, :include => :forum_user, :order =>
2009 Aug 13
2
need technique for speeding up R dataframe individual element insertion (no deletion though)
Hi fellas,
I am working on a dataframe cam and it involves comparison within the
2 columns - t1 and t2 on about 20K rows and 14 columns.
###
cap = cam; # this doesn't take long. ~1 secs.
for( i in 1:length(cam$end_date))
{
x1=strptime(cam$end_date[i], "%d/%m/%Y");
x2=strptime(cam$end_date[i+1], "%d/%m/%Y");
t1= cam$vol[i];
t2= cam$vol[i+1];
2006 Dec 08
2
trouble using ActiveRecord classes
I''ve been trying unsuccessfully for the better part of today to write a
worker that can use by ActiveRecord model classes.
The bizarre thing is that worker just stops at the point accessing the
database connection. An exception isn''t raising, it just dies.
My worker class is below, I''ve interspersed log messages throughout to try
to determine where it is dying.
=====
2010 Jun 08
2
type conversion with apply or not
Folks, i thought it should be straightforward but after a few hours poking around, I decided it's best to post my question on this list.
I have a data frame consisting of a (large) number of date columns, which are read in from a csv file as character string. I want to convert them to Date type. Following is an example, where the first column is of integer type, while the rest are type
2013 Jan 29
2
Count entries in postgresql grouped by date
Hi!
I have a table with visits with a visited_at: attribute which is a datetime
field. They seem to be stored as UTC. Now I want to count all visits each
day and return something like:
{
2013-01-01: 8,
2013-01-02: 4,
2013-01-07: 9,
...
}
So, I did it like this which kind of works...:
def self.total_grouped_by_day(start_date, end_date)
visits = where(visited_at:
2024 Oct 30
2
Extracting wind direction and wind speed from wind rose plot
Dear all;
I am searching for a way to extract wind direction and speed from a wind
rose plot. I have a graph and I want to make a dataframe of 5 years with
hourly intervals.
> start_date <- as.POSIXct("2019-01-01 00:00:00")
> end_date <- as.POSIXct("2023-12-31 23:00:00")
> time_sequence <- seq(from = start_date, to = end_date, by = "hour")
> df
2006 Jun 25
3
Sorting results by column
I have the acts_as_ferret plugin installed. Everything searches great,
but I would like to limit the results (i.e. by ''end_date'') and sort them
(by ''end_date''). ''end_date'' is a valid column in my "posts" table.
Here''s the code I have already:
@posts = Post.find_by_contents(params[:query])
params[:query] comes from a
2006 Jun 10
3
Inserting data to another DB table
I have a form under one controller/model called "billing" using the
"bills" table. When this form completes I want it to change the
"has_billing" field for the user under the "users" table from "0" to
"1". I''ve almost got it. I put:
user = User.new
user.update_attribute("has_billing", "1")
under the
2004 Nov 08
2
Matrix Indexing
Hi,
I have the following problem.
In a csv file I have under column A, the date, and column B, the prices.
Thus, for example, the file looks something like this ->
1/31/04 2.5
2/1/04 2.6
...
4/12/04 3.5
Basically, I use the function inputframe = read.csv( )
which reads the csv file into the inputframe.
My question is, how can I make a function that has, as inputs,
2013 Feb 26
4
3 models, joining and nested queries
I have 3 models,
class Host
ref: string
address: string,
name: string
primary_key=''ref''
has_many :rooms, :class_name=>"Room", :foreign_key=>''host_ref''
Class Room
ref :string
host_ref: string
capacity: integer
primary_key=''ref''
has_many