similar to: how to insert a collection of records into another table

Hi All, I am inserting data from one table to another by using following method @data=RoyaltyReportFiles.find_by_sql("insert into royalty_reports (artist_name, album_name) select artist_name, album_name from temp_royalty_reports where id=328417") it saves the data into royalty_reports table but it gives following error and application crashes. i am using rails 1.2.5 You have a nil

Hi, All, Suppose I have a CSV file, there is data in it. * Column 1 Column2 Column 3 Column 4 Row1 a b c Row2 a2 b2 c2* You know, the column 4 is no data Now, I would like to insert data to Column 4, after save, the CSV file will be: * Column 1

Hi, I''d like to insert/append some default text into a text area after clicking on an image button ''test.png'' in edit.rhtml: <%= link_to image_tag("test.png"), url => { :action => :new_text } %> Action: # article_body is the textarea''s id. def new_text render :update do |page| page.insert_html :bottom, :article_body,

This feels like it should be easy but i can''t work it out: if i have a collection of stories, ordered by (for example) date, then how do i find out the position of the story with id = (eg) 23 in the collection? I guess this is a ruby question rather than a rails-specific question, but maybe there''s a rails way... -- Posted via http://www.ruby-forum.com/.

Dear list, I want to insert a recorde into a SQLite table by dbGetQuery(), but there is a problem when the value contains quotation mark. > dd<-data.frame(txt=c("having both ' and \" in character.","OK")) > library(RSQLite) Loading required package: DBI > con<-dbConnect(dbDriver("SQLite"),":memory:") >

Ok, my problem is that I have a form with a client''s information. Now in the form, I ask the client for his info, which inserts into the table "clients", and then I have another text input where he has to provide a specific detail that i want to be inserted into the table "details". How can I insert this data into 2 different tables? -- Posted via

Hi, I know this would be a simple solution to provide for any one of you. I am new to active record and this is what I have currently done: require ''rubygems'' require ''active_record'' puts "connecting to db...." ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", # :username

https://bugzilla.netfilter.org/show_bug.cgi?id=1123 Bug ID: 1123 Summary: conntrackd will not accept connection records into kernel table from another machine Product: conntrack-tools Version: unspecified Hardware: x86_64 OS: other Status: NEW Severity: major Priority: P5

I''m in progress of making a little folder system with Ruby on Rails. I''ve got a "folders" table. Each "folder" has got an id and a folder_id. The folder_id is supposed to represent the folders'' parent folder. How can I tell Rails? I would like Rails to automaticly delete all subfolders of a folder when I delete the folder it self. Any ideas? --

Hi. Please do bear with me as I am a newbie. I think I understand how to setup the relation using "has_many" with "through". What I need to know is how to insert data into the tables in the controller. For example, I have company details like name, address and country. I also have a category table like audio, video, events and lighting. Once I setup the relations, I need

Hello, I''m getting an "NoMethodError" traversing a named collection. Let me explain I have a named collection called best_friend in a class called user def self.best_friend find :all, :conditions => "designation = ''Best Friend''" end and if i do current_user.best_friend everything works great, I can pull up the user''s name as

Hello, i want to insert a select field into my form. The fields of the select-field should come from a database that is created in a different modell in the same project. I don´t need relations simply the content from one field in the table that should populate the select-field. How can i do this? The selected item from the select-field will then be saved amoung other fields in a second database

hi all, i installed rails 2.1.0 just now before i was working with rails 1.2.6. when i try to check the application enviroment link in the index page of the application it gave me " MissingSourceFile in Rails/infoController#properties no such file to load -- sqlite3RAILS_ROOT: D:/RadRails/Workspace/Varsha " here i am using win XP, no sqlite installed. i have

There is a varbinary column in database table,in sql statement,we can use '' convert(varbinary(10),''hello'') '' to convert string to varbinary ,but in rails,how can I do that or there is a another way to insert a string content into varbinary column. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

Hello, I wrote a small application for a temporary employment company so that they can insert the timestamps and also note the companies for which their employees are currently working. Because it is a web app the application is usable from the field and also from the office locations. The contracts have been created by using a very old and unmaintained software that allowed them to fill a

I have a long list of posts posted on different days and many posts every day. I want them to arrange like following... Date1 ----- post1 post2 Date2 ----- post3 post4 post5 How can I (say) group them to appear all posts of one date under their related headng. Because records have so many different days, it is confusing me.. I need some generic solution. Thanks in advance. -- Posted via

Hey all, I created a seed task: def books! books = Book.where(:type_id => Type.find_by_name(''Fiction'')).order(''id'') books.each do |book| @books = 4.times.map do |i| subbook! "#{book.book_num}-#{i}".to_s, :book_state => BookState[:available].id, :book => book end end puts "log it:

hi @ all How can I clean all records from a table in a mysql database without delete the table in the database? (only use a method in the model) thanks for helping! -- 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,

Ok I''m not sure what I''m doing wrong, but I have a table that holds a bunch of times, however when I don''t fill in the text box that passes it''s input on to the variables, rails defaults to 00:00:00, which is bad, because that''s midnight. I''m pretty sure I''m doing somethign wrong, and I''m even thinking of using the

I have a collection of acts_as_ferret search results that I need to trim based on an attribute. I''ve been trying to iterate through the collection but haven''t been able to make this work. Here is what I have tried unsuccessfully: @people.each {|person| person.clear if person.privacy_type == "private"} Unfortunately Class Person does not respond to clear since it is