similar to: AR's find_by_* limits return results. How to avoid id?

Hello there, I''m wondering how do they create functions on the fly? find_by_any_column_name ?? I want to do something similar with my models, but I don''t really know how to do it? user_current_nickname user_current_id user_current_role etc.? Regards, Jamal -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this

In the Agile RoR book, page 219 (softcover version) they talk about the fact you can use the methods: find_by_ and find_all_by_ and fill in the last piece with a valid column name. So I have a database table called "parts" and the following columns: id partname partnumber vendor I do the following: (connection to DB already established) class Part < ActiveRecord::Base end

I was hoping that AR''s find_by_* magic methods would help me retrieve multiple items somewhat like the following: names_to_find = [''Larry'', ''Moe'', ''Curly''] found_people = Person.find_by_name(names_to_find) Is there a way to accomplish this using find_by_* (or even find(:all) using some sort of conditions) or must I resort to SQL

Is find_all_by deprecated and/or find_first_by for 2.0.2? If not, what is actually deprecated? just find_all(..) and find_first()? Thanks for clearing this up. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

Hello. I have a UsersController and a Model called User with a "new" method, like this: class User < ActiveRecord::Base def test return 1 #I can do anything and return any data, the problem continues. end end The problem is that I cannot access my "test" function from the controller. It says that the method doesn''t exists. class

In my app, a user logs in [via the login generator] and has access to details of his account, and transactions attached to his account. This is achieved in the standard rail manner by passing the account id or transaction id between the controller and the view. But what is to stop someone hacking the URL or view html to access another account id or transaction id ? eg /account/show/46 becomes

I''m trying to understand how to select only certain rows in my database using RoR. As a test I try to find certain clients by adding this code in my list view... <% clientlist = Client.find_by_client_status_id(1) %> <% if clientlist %> <= This prevents me from getting nil errors. <% for client in clientlist %> <= This seems to try and call

Dear all, I have a doubt, How to fetch records from tables, which are not having ID field as its primary key. If possible, please tell me to way to extract data from those tables. -- with regds, Nahalingam N. Kanakavel. (http://www.nahalingam.bravehost.com/PlanetN/) -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello all I am wondering how rails handles case sensitivity in databases. If I do a Person.find_all_by_name("tim") in mysql I would expect to get tim, TIm, and Tim. Do I only get tim in postgres? How do other people deal with this? Do you resort to find_by_sql for all your postgres queries to get case insensitive results?

obviously, follow code is not working <p> <% if !@group.users.find(session[:user].id) %> <%= link_to "Join This Group", :action => "join", :id => @group %> <% end %> </p> "find" always throw an exception. I want to display the link of "find" fails, what is the right way to do this? Thanks. -- Posted via

I'm not sure how this happened, but llvm-ar q doesn't work, even if llvm-ar.cpp has relevant codes. As the developer policy said "you are allowed to commit patches without approval which you think are obvious", I did. The patch follows, just in case. Index: tools/llvm-ar/llvm-ar.cpp =================================================================== ---

Hi all, I am currently trying to get a bunch of links to to display all the related console records upon button click so e.g. If a user clicks on the Dreamcast link then I would like it to display all records that have Dreamcast stored as their console. I have the following example code in my index class: <%= link_to ''DREAMCAST'', games_path(:console =>

Hello everyone, I have a rails app which uses email as login name. At some point, I have to search the user, in the User model by email. For some reason, the method User.find_by_email(email) returns nil, even though the user is in the database. The same applies for any find_by_* method that searches by any database column. I was able to find the user using the User.find Does anyone have an idea

Hello, I posted this on the rails talk group but received no response. Perhaps someone on this list could weigh in on whether this is expected/desired behavior or a bug that I should file and develop failing tests for (I doubt I have the active record method_missing fu to actually patch it). Test Scenario: I would like to find or initialize a new user and base the find on the users email

I am trying to use the new Rails 2.0 macro : rescue_from class PostsController < ApplicationController rescue_from ActiveRecord::RecordNotFound, :with => :deny_access ... def show @post = Post.find_by_id(params[:id]) raise ActiveRecord::RecordNotFound if @post.nil? #illegal access ..... end def deny_access respond_to do |format| format.html end end but the

hi! how can i find an ID from a table, with another attribute? i mean, i have the table users, with id, and name, and i want to find the id, where the name is. i know only the way with the id.. @something = User.find(params[:id]) which would be the correct syntax? ty!! -- Posted via http://www.ruby-forum.com/.

What could cause this? >> sdfl=PartNumber.find_by_part_number("1111111") => #<PartNumber:0xb78fc744 @attributes={"id"=>"11601", "part_number"=>"1111111"}> >> sdfl=PartNumber.find_or_create_by_part_number("1111111") NoMethodError: undefined method `find_or_create_by_part_number'' for PartNumber:Class

Hi I am having issues with getting my pretty urls to work. routes.rb: map.connect '':user'' , :controller => ''front'' , :action => ''list'' , :filter => ''user'' front_controller.rb: def list @advert_pages, @adverts = paginate :adverts, :per_page => 10 @user =

Hi all, I''m trying to get rails up on mssql for a friend, does anyone have experience? We''re working on a Windows XP box with MSSQL 2000 (no service pak), and both rails (1.1) and MSSQL are on the same box. I''m running into a bug (I think) where activerecord is using this syntax: SELECT TOP 1 * FROM users WHERE (users.user = ''jbgnuumnbu'')

Hello again, I guess this is more of a Ruby question, but here goes anyways... I want to intercept all calls to non existent class methods and then call an existing class method with the non existent name. In code... class MyModel < ActiveRecord::Base def MyModel.method_missing(symbol, *args) MyModel.func(symbol.id2name) end def MyModel.func(func_called) puts "You