Displaying 20 results from an estimated 1000 matches similar to: "SQL WHERE equivalent in rails"
2006 May 31
7
Getting 22 elements
Hello,
I''ve done
===
class HomeController < ApplicationController
def index
@country = Country.find(:all, :include => "cities")
end
end
===
And rhtml is:
===
<% @country.each do |country| %>
<h1><%= country.name %></h1>
<% country.cities.each do |city| %>
- <%= link_to city.name, :action =>
2006 Jun 23
2
polymorphic challenge
Hello All,
I have a little challenge and I am not sure if this is even possible
I am working on a dating/event site and few functionalities are similar
that I want to centralize them.
We have users which can have
- favorite users
- interest list
- blocked users
All these relations are like;
User <-> Relation <-> User
I was thinking I could have a class called Relation (with a
2006 Apr 09
6
Write/Display AR query as Grouped Results?
I''ve got a publications table that contains an author_id foreign key and
a pubrole_id foreign key. What I want to do is query the DB using AR so
that I can get a list of all publications that belong_to a particular
author, and group the results by the pubrole.role_name (Author, Joint
Author, Editor, etc.) so that the results look something like:
Author
book1 info
book2 info
etc.
2006 Mar 22
5
foreach item in column
Hi there,
I have a database with phonenumbers, and I want to make a function
that runs a command for each of these numbers, with the number as an
argument
Something like this in Perl:
system("/bin/command $number");
mysql> select * from numbers where list = "one"
+----+----------+----------+---------------------+-----------+
| id | number | name | email
2006 Apr 27
4
customize validates_uniqueness_of
I need to modify the validates_uniqueness_of function so that it will
check that the string is unique but only in its own category.
For example right now I have
validates_uniqueness_of :title
so let''s say I have the :title "Title 1" already in the database with
the :category of "1"
then if i wanted to enter the :title "Title 1" in the database again BUT
2006 Jul 20
11
3 columns
Hi all,
Not really sure what to put in the title so hope people still open this!
What I want to do is produce something like this
Col1 Col2 Col3
data1 data2 data3
data4 data5 data6
data7 data8 data9
data.. data.. data..
data.. data.. data..
data-n data-n+1 data-n+2
I can get the data back from my db
2006 May 03
2
grouped output
hello,
Suppose I have a table that looks like this:
center name email
Health Jon jon@test.com
Health Bob bob@test.com
Admin Jane jan@test.com
Admin Jill jill@test.com
I would like the output to look like this:
Health
Jon jon@test.com
Bob bob@test.com
Admin
Jane jan@test.com
Jill jill@test.com
when i using cold fusion, this was easy via a tag called cfoutput.
when i was using java, this was
2006 Apr 25
3
limiting options in file_upload
Does anyone know if it''s possible to set constraints to the size & type of file that file_column will accept?
I''d like to limit to image files of less than 2MB.
If this isn''t possible with file_column, is there a graceful way of getting the controller to handle it?
thanks
dorian
--
--
I do things for love or money
2006 Jun 18
10
acts_as_enumerated
Hello All,
Any one using acts_as_enumerated? I need help using (I like that it
caches values in memory)
I am working on a dating website and there are lots of options I want to
store as enumerated like
Status; divorce, single,
Sex: male, female
Eye color; blue, brown, green....
and lots more....
But I do not wanna keep them in seperate tables, and wanna keep them all
together.
Anyone has a
2006 Jan 26
4
Override has_many :order at run-time?
Is it possible to override has_many''s :order attribute at run-time? e.g.
something like:
<% for category in @site.categories(:order=>''name'') %>
...
<% for category in @site.categories(:order=>''rank'') %>
...
thanks
csn
--
Posted via http://www.ruby-forum.com/.
2006 Jan 20
8
validates_confirmation_of not working
is there any special requirement for validates_confirmation_of ? I am
trying to make sure 2 passwords are equal (cleanly the rails way)..
In my view i have two fields with id user[password] and
user[password_confirmation].
in the model i have
validates_confirmation_of :password, :message =>"Passwords do not match "
Am i missing something here ?
thanks
adam
2006 Jun 07
2
Qick Q: Expression in this Controller
I tried putting this inside my controller:
def goodbye
@link = Link_to "goodbye!", :action =>"goodbye"
end
and display it in my views calling the @link variable.
Of course it doesn''t work.
Why?
Thanks
--
Posted via http://www.ruby-forum.com/.
2006 Mar 22
3
Problems with validates_presence_of...anybody?
Hello everybody,
I have been developing small applications in Rails from quite some time.
But lately, I came across a bug which I have not been able to correct.
If anybody could help me with it, would be of great help thankyou.
Actually, the problem is that I have a form in my application with some
set of fields.
Now what "validates_presence_of" should do is that if I submit the form
2006 Apr 01
4
Saving images in shared directory w/ Capistrano/SVN?
Hi all,
I''m using Capistrano and SVN to version control and deploy, but I''m not
sure what to do about my images directory. I use file_column and
RMagick to save images to the disk under a model called "Image", and
they''re saved in public/image/... etc.
Each time I deploy a new version, my image folder doesn''t exist anymore.
I don''t want
2006 Jan 12
17
Application.rb params
I need to check if a parameter is set so that I can build some information
for my application, but No matter how I format my if statement in the file "
Application.rb" it return the following error.
You have a nil object when you didn''t expect it!
You might have expected an instance of Array.
The error occurred while evaluating nil.[]
Here is the line
if params[:day]
So we
2009 Mar 27
1
using pagination to group pages by attribute value
Hi -
I''m trying to group records based on some attribute they or an
association of their''s have. The simplest example I could think of to
drive my point is this:
Assume the following model associations (pardon my butchering of rails)
-
Faculty has_many :courses
Course belongs_to :faculty
I want to paginate courses based on the name of the faculty they belong
to.
The paging
2018 Feb 22
1
preferred way to move an imap folder
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div>
<br>
</div>
<blockquote type="cite">
<div>
On 22 February 2018 at 18:53 "@lbutlr" <
<a href="mailto:kremels@kreme.com">kremels@kreme.com</a>> wrote:
</div>
2006 Mar 29
5
How to skip password validation when updating other fields?
Besides the hashed password, which is saved to db, I have two
password-attributes in my User model:
attr_accessor :password, :password_confirmation
I have validations on these attributes, and I need them to work both on
create and update, since I have pages for changing and resetting the
password.
Now when I want to update just the user''s login name, I guess I have the
next
2008 Jan 01
7
in_vertical_groups_of
Hi all,
Here''s another contribution for anyone interested.
In Railscast episode 28, Ryan Bates showed us in_groups_of which
allows you to group array members such as
>> list = [1, 2, 3, 4, 5, 6, 7]
=> [1, 2, 3, 4, 5, 6, 7]
>> list.in_groups_of(3)
=> [[1, 2, 3], [4, 5, 6], [7, nil, nil]]
This allows you to iterate over the groups and, for example, display
a list
2006 Aug 11
1
Group By
Hi,
I have a table similar structure below.
id name position page
1 name1 1 1
2 name2 2 1
3 name3 3 1
4 name4 1 1
5 name5 1 1
6 name6 1 2
What i want is to select all the items for a given page number grouped
by pos and displayed in a view using a loop like:
display position number, number of records
for