Displaying 20 results from an estimated 7000 matches similar to: "Form not inserting data into database"
2006 Apr 02
1
One to Many Relationship Issues
Hi,
I am having issues with a one to many relationship(it never works :-)).
Jokes aside, I am getting an error:
Mysql::Error: #23000Cannot add or update a child row: a foreign key
constraint fails: INSERT INTO adverts (`image_url`, `price`, `title`,
`website_url`, `description`, `user_id`) VALUES(''bb'', 22.0, ''aa'',
2006 Jul 06
1
Problem implementing password and password confirmation
Hi,
I''m trying to implement password confirmation, based on the Agile
example, but just can''t make any progress.
User DB has these fields:
=========================
t.column :name, :string, :limit => 40
t.column :hashed_password, :string
t.column :salt, :string
User model has:
===============
attr_accessor :password_confirmation
2006 May 09
2
User.new doesn´t capture all of the parameters
Hi,
I have a page where I can add new users to the database, but it only
sees whats in the name and passord field.
add_user.rhtml:
<%= form_tag %>
<%= form_tag :action => ''add_user'' %>
<td>User name:</td>
<td><%= text_field("user", "name") %></td>
</tr>
<tr>
<td>Password:</td>
2006 May 22
2
Inserting data in a table with a varchar key field
Hi all,
I have some problems inserting data into a legacy table. the key field
of this table is a field named CIN which is a varchar(15).
when I try insert into this table using a form (generated by the
scaffold generator) I get this Error :
_____________________________________________________________________
undefined method `CIN_before_type_cast'' for #<Candidat:0x370d8c8> |
2006 Jan 24
3
AJAX Preview & Edit Page Problem
I''m new to RoR and have started building my first application.
I''m building an account sign-up controller and I have two questions:
1. What is the best way to pass form params between methods in my
sign-up controller? The solution I''m using seems too hacky and there''s
got to be a something more elegant. I''m instantiating User.new to
capture the
2006 Jul 21
1
Passing a variable between methods
Hi,
I am trying to add search functionality to may application. I am
struggeling to pass my query to the controller and then show all my
search results in another view. How would I do this?
Model:
class Advert < ActiveRecord::Base
belongs_to :user
def self.search(query)
if !query.to_s.strip.empty?
tokens = query.split.collect {|c| "%#{c.downcase}%"}
2005 Dec 17
1
lost in an ActiveRecord::StatementInvalid
I have an error I don''t know how to debug. I am adding the login
suport in Depot (the example in the RoR book) and
LoginController#add_user throws ActiveRecord::StatementInvalid in an
innocent /login/add_user GET request.
The trace goes down to a call to SQLiteAdapter#table_structure, and
the source code suggests what''s happening is that "PRAGMA
2006 Jun 05
2
When adding a record in console, a parameter comes in as null even when I set it
In console, I am trying to create a User but the :account_id does not come
in. Console just gives me back :account_id => nil. Obviously I''m trying to
set it though. Silly console...
But, I can set the account_id column in my controller like so:
@user = User.new(params[:user])
@user.account_id = account.id
@user.save
Here''s what I give to the controller:
User.create :name
2006 Mar 04
4
Two quick newbie questions
2 quick questions regarding authentication ...
1) the flash[:notice] on successful login looks completely wrong to me.
How should it be done?
def index
if request.post?
@user = User.new(params[:user])
authentic_user = @user.attempt_login
if authentic_user
session[:user_id] = authentic_user.id
flash[:notice] =
''Login successful! Welcome
2006 Mar 14
1
I''m missing something obvious to a taglib programmer ...
I am trying to create, display and edit a referenced object''s text field
on the same view as my root object. I have just about come to the
conclusion that whoever invented of taglibs should be shot.
quiz.preamble_presentation references a Presentation object instance.
The Presentation object contains a property called text, among others.
The generated form will display the ID of the
2006 Jun 16
2
Problem with User Login from Agile Web Development
I am trying to use an expanded version of the User Login from the Agile
Web Development with Rails book. It takes the user name and password
but then says "Invalid user/password combination". Looking at the log
everything seems to be fine until it sends the query to MySQL. The
query shows that the name is '''' instead of the name that was passed to
the self.login
2006 Jan 19
1
[Newbie] undefined method `useremail'' error
Hi all,
I''m just starting out... the solution to this must be really trivial but
can''t figure out what''s wrong. I''m using Webrick + Rails 1.0
The error is:
undefined method `useremail'' error
What am I missing?
Thanks,
Lorenzo
class User < ActiveRecord::Base
set_table_name "\"tblUser\""
set_primary_key
2006 Mar 22
3
Parent-Child Tables Help
can someone help me with this
i have a table
cars
(
id int
model_id int
make_id int
color_id int
description text
constraint fk_cars_carmake foreign key(make_id) references
carmakes(id),
constraint fk_cars_carmodel foreign key(model_id) references
carmodels(id),
constraint fk_cars_color foreign key(color_id) references colors(id)
)
carmakes
(
id int
carmake varchar
)
carmodels
(
id
2006 Feb 15
8
Agile book - getting confusing error
Working through the beginning phase from the Agile book on
''Administration''
undefined method `hashed_password='' for #<User:0xb7911324>
...
/usr/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/base.rb:1498:in `method_missing''
#{RAILS_ROOT}/app/models/user.rb:12:in `before_create''
2008 Sep 10
0
wrong number of arguments
I am a newbie at rails and can''t figure out the following problem. Can
anyone help?
I am running the following:
Ruby version 1.8.6 (powerpc-darwin9.4.0)
RubyGems version 1.2.0
Rails version 2.1.0
Active Record version 2.1.0
Action Pack version 2.1.0
Active Resource version 2.1.0
Action Mailer version 2.1.0
Active Support version 2.1.0
I created three models using the:
2006 Jan 11
0
error_messages_for >> Cannot convert Array into String
Hi all
I have the following Model:
Member(id, username, first_name, last_name, hashed_password,
password_salt)
Now I want to allow users to register for an account using the following
form:
---
<%= form_tag %>
<%= error_messages_for ''member'' %>
<p><%= _(''Username'') %>: <%= text_field(''member'',
2006 Mar 21
3
Newbie - ActiveRecord relationships
So I''ve worked through Agile Web Development with Rails and I''m now
trying my first little app to get into the swing of things. Its a task
tracking app where people can create tasks and assign them to others,
and also log time against the tasks.
I''m having trouble working out the model relationships. This is what
I''ve got so far, but its not right as
2006 Apr 10
3
Problems with multiple ActiveRecords and Validations
Hi all,
I am a RoR newbie and have the following scenario set up:
There are 2 ActiveRecords involved, the first one being "User", the
second one being "Visibility".
The corresponding users table holds address informations regarding a
User. The visibilities table holds visibility settings for the
individual columns of the users table (i.e. firstname, lastname, country
2007 Aug 05
0
Newbie - Question on Parent child updating
All,
I''ve just started Rails and Ruby a week or so ago. Please forgive me
for my ignorance. I started writing a small test application to test
some of my new knowledge and have hit a wall. Would like some best
practices.
I have 3 tables, as below...
CREATE TABLE `carts` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`quantity` int(11) NOT NULL,
PRIMARY
2010 Jan 26
2
accepts_nested_attributes_for :has_many :through => 'bug?'
Hey guys & ladies!
I''ve got the following relationship which i''m trying to get
accepts_nested_attributes to work with. But when i submit my form, it
looks as if its expecting a Company object, rather than an array of
companies. which really doesn''t make sense considering its a
has_many :relationship.
So what i''m after, is a way to