Displaying 20 results from an estimated 10000 matches similar to: "Checking column in table to see if value exists?"
2010 Jan 22
11
Finding out where a variable is defined
I''m looking at code in a project. I have no clue what is being passed
into the resource parameter:
    def read_authorized?(resource)
      if resource.respond_to? :user_read_authorized?
        resource.user_read_authorized? current_user
      else
        true
      end
    end
Is there any kind of debugging feature I can run to see what gets passed
into resource in this specific
2010 Aug 03
10
Returning last value
Hi.
I have the following controller of the update action:
[code]
def update
    @projeto = Projeto.find(params[:id])
    if (@projeto.update_attributes(params[:projeto]))
    ## Mesmo raciocĂnio utilizado no create.
    @permissaoA = Permissao.find(:first, :conditions => ["usuario_id =
?", @projeto.responsavel.to_i])
    @permissaoAvancado1 = Permissao.find(:first, :conditions
2010 Feb 10
2
undefined method 'state'
I can''t imagine what I''m trying to do is complicated at all in Rails.
Yet, I am now getting this error: undefined method `state'' for
:StudentFailState:Symbol.
student.rb
has_one :student_fail
attr_accessor :student_fail_attribute
#controller
def student_fail
@student = @student.find params[:id]
def update_student_fail
  @student.build_student_fail
2010 Dec 21
5
Called id for nil, which would mistakenly be 4 -- if you really wanted the id of nil, use object_id
Hey all,
I know that this:
Called id for nil, which would mistakenly be 4 -- if you really wanted
the id of nil, use object_id
means that I have an instance variable that has not been initialized.
However, I''m a little confused as to what to do in a signup form for
form_for:
<% content_for :login do %>
   <% form_for @user, :url => { :action => "login" } do
2010 Jun 16
4
firebug jQuery undefined message in rails app
In rails app, I add the following line of code in application.js and I
get jQuery is not defined in firebug console.
In application.html.erb, I have the following:
<script type="text/javascript"
src="../javascripts/application.js"></script>
<script type="text/javascript"
src="../javascripts/jquery-1.4.2.js"></script>
and I installed
2010 Aug 09
2
Auto-increment column scoped to another column
Hi,
I have one field that needs to be incremented automatically, but be
scoped to another column. So it should increment based on the last value
of the previous row with the same value of the scoped column.
I''m not trying to replace ID with another primary key or anything crazy
like that, just trying to auto-increment a database column!
Any idea of how to do this? Rails 3. Thanks!
-- 
2009 Sep 07
11
autoincrement for non-id column
There is a table:
execute (<<-SQL)
  CREATE TABLE "tasks" (
    "id" serial primary key,
    "number" serial,
    "version" integer DEFAULT 0 NOT NULL,
    "latest_version" boolean DEFAULT ''t'' NOT NULL,
    "hidden" boolean DEFAULT ''f'' NOT NULL,
    "type" character varying (1) NOT
2010 Dec 14
4
Change primary_key column name
Hi,
after changing a primary key column name, the auto-increment information
(MySQL) and sequence (Oracle) are lost. What is the correct way to rename
primary keys?
Thanks,
Gustavo
-- 
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
2009 Oct 29
4
Unknown column 'quotes.organisation_id' in 'where clause': SELECT * FROM `quotes` WHERE (`quotes`.organisation_id = 1036)
Hi,
    I have a small app that needs to keep track of quotes, and
organisations. An organisation can either be the unit who finally
receives the goods (the end_user) or and intermediary (customer) (and in
some cases both)
    An Organisation will (hopefully :) ) have many quotes; and a quote
can belong to an organisation, either as a customer or as an end_user or
both.
     So the quotes table
2007 May 21
7
How do I stop a column being updated by model.save?
One of my models has a column that is updated very frequently from a
separate process, so it is important that when a record is saved in
rails, this column should be left alone. In the update method of the
controller I have:
@record = MyModel.find(params[:id])
@record.update_attributes(params[:my_model])
params[:my_model] doesn''t have a reference to the column I''m talking
2006 May 29
6
override automatic update of updated_on column
i know that title sounds confusing, but here is the deal:
the two columns that we are concerned with for this question are the "updated_on" column and the "views" column.  the views column increases everytime a user visits a certain page.  like this:
@object.update_attributes(:views => @object.views + 1)
the problem is that when a user visits the page, it AUTOMATICALLY
2006 Jan 02
1
ActiveRecord, << or push_with_attributes: update if exists?
In the Agile Rails book, on page 232 (PDF, 4th edition) there is an 
example of (within ActiveRecord) marking an article as read by a user at 
the present time. Short example code (from the book) here:
	class User < ActiveRecord::Base
	  has_and_belongs_to_many :articles
	  def read_article(article)
	    articles.push_with_attributes(article, :read_at => Time.now)
	  end
	  # ...
	end
2010 Apr 20
13
why is ActiveRecord tying to select nonex ID column?
I''ve loaded (and updated) thousands of these MeteredUsage records.  In
the middle of a run, I suddenly get:
ActiveRecord::StatementInvalid: Mysql::Error: Unknown column ''id'' in
''where clause'': UPDATE `metered_usages` SET `cost` = 12603.46 WHERE `id`
= NULL
I can''t see anything that''s different about this particular record
compared to
2009 Aug 18
5
Increment counter on download
i am offering my site visitors a download of zip file.  when someone
downloads it, i want to increment a counter and update db.  how do i do
that?
-- 
Posted via http://www.ruby-forum.com/.
2010 Mar 09
3
undefined method join for STRING error
Hey all,
I was converting  a haml file to erb and when finished, I ran the app
and got this error message:
NoMethodError in Students#student_fail
Showing app/views/students/student_fail.erb where line #40 raised:
undefined method `join'' for #<String:0x105a5e0c8>
Extracted source (around line #40):
37:
38:          <%  fields << render(:partial =>
2012 Sep 08
4
dash symbol
In the example below, what is the dash doing between the class
attribute and array:
(field_helpers -
[:label, :check_box, :radio_button, :fields_for, :hidden_field, :file_field]).each
do |selector|
-- 
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
2010 Jun 05
6
How do you update HABTM relationships or create.
Hi,
I have a User model with a HABTM relation to a Role model and vice
versa. So There''s a roles_users table that references :user and :role.
I''m using formtastic, and in the user.edit.html.erb I have a line that
outputs the roles as a multi-select list box. But the box is not
showing the roles that have been assigned to the users.
Another problem is that if I select a few
2005 Dec 19
5
gem update fails with "checking for fcgiapp.h... no"
Hello,
Trying to do gem update on my existing system that''s been working fine 
for a couple of months. This is what I get:
=====================================
bash-2.05b# gem update
Upgrading installed gems...
Attempting remote upgrade of fcgi
Attempting remote installation of ''fcgi''
Building native extensions.  This could take a while...
ERROR:  While executing gem
2010 Jan 30
2
undefined method 'month'
I get an undefined method month:
xml.haml:
  - @results.each do |result|
    %set{:month => "#{result.month}", :value => result.month}
Any suggestions?
-- 
Posted via http://www.ruby-forum.com/.
-- 
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
2011 Sep 11
5
question about a where condition
Hey all,
This example of working code:
@a = @b.where(:a_group_id.ne => nil).collect { |b| b.a_group }
doesn''t make too much sense to me. For one, I am not sure what that
"ne" is doing there. Is this a postgresql thing? Second, it looks like
we are collecting active record objects where the a_group_id is null,
collecting them in an array and then invoking the a_group