similar to: Checking column in table to see if value exists?

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