similar to: compare two tables and find the difference?

I can''t figure out how to get the collection_select to correctly identify and select the appropriate option in the drop down to begin with. i have checked that charge.offense_level contains the correct value to begin with (a number between 1 and 10) but the view still defaults to the first option and not the one contained in the charge.offense_level. what am i doing wrong? any

I have a legacy db with the following simplified structure: Table-A: type_key, code_key, name, ... # PKs are type_key and code_key, there is no id col and I cannot alter this db Table-B: # each row has only the code as a foreign_key, the type_key is hard-coded to "FOOKEY" an_id, code, ... Models: class TableB < AR::Base set_table_name ''table_b''

Hi, I have a client connected to the ''net through 3 ISP''s. Have set up a Linux box to do routing and load sharing for the 3 connections. A fourth interface is connected to the LAN with private IP addresses. Am using iptables to SNAT traffic to the appropriate IP depending on the interface the packet gets routed onto. The setup looks something like this: Interface IP

Dear R experts, I've realized that it might not be possible to define a negative SELCET statement in a SQL call so now I'm looking for the smoothest way to generate a list of what I would like from my large database by first pulling all the names with a query like this "SELECT top 1 * FROM your_table" (thank you Bart Joosen for the idea) and then subtract the variables I am not

I need to select 1 record from each client. This record has the charge with the most severe charge type (lowest charge_type_id). How do I go about this? I have been using a find_by_sql query out of the client.rb that looks like: SELECT c.f_name AS f_name, c.l_name AS l_name, c.gender AS gender, c.race AS race, c.dob AS dob, c.address AS address, c.city AS city, c.state AS

I have TableA with name, description, start time displayed on one page. TableB has name, comment, file path and is displayed on another page. I''m using the SortHelper2 helper to help me sort the columns of these tables, however I''m experiencing a problem whereby if I sort TableA by description and then go ahead and view TableB I get an error message saying SQL Command Failed,

I''m trying to be a good rails developer and fix DRY violations as i find them. However, i''m trying to fix this one, i cant seem to get it to work. I have two tables A and B that have a one-to-one relationship. Table B belongs_to Table A. Table A has_one Table B. I''m creating instances of Table A in different places, depending on the controller. However, for each

Hi, Is it possbile that one active record maps to N tables, actually the relation is 1 to 1, I wonder it is possible. also can a ruby object map to N tables, instead of an active records? Thanks you very much:) Saiho __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Hi All, I have problem with inserting new record into the database. I have a form has 4 fields, and two fields will be inserted into tableA, and other fields will be inserts into tableB. These two tables has relationship tableA(One) and tableB (Many) ...so how could I do that? Socheat Yi Web Programmer/Software Developer Screened Images Multimedia (SIM) *If You Can Imagine It...We Can

Hi, I'm using R 1.9.0 with RMySQL 0.5-4 and MySQL 3.23.55 on a suse 8.2 box. I have a simulation study and (as usual for newbies in simulation, I guess) I have a lot of data that I want to store in MySQL. I want to write an R script that reads data from RData files and writes it to a MySQL database. I read some R documents (R Data Import/Export and DSC papers) but I'm finding

Hello list, I think I''ve found a bug in the way Rails is talking to my Postgres DB when recording HABTM data. My join_table looks like this: id serial primary key, tablea_id integer references tablea(id), tableb_id integer references tableb(id), other_attributes... When Rails writes to join_table, I''d expect it to do something like: INSERT INTO join_table (tablea_id,

Good morning! I do not speak English very well and so I will try to explain the best I can. I have this: > tabela[,1] [1] a a b b a c b a c c c c c Levels: a b c >unique(tabela[,1]) [1] a b c Levels: a b c >var<-unique(tabela[,1])[1] > var [1] a Levels: a b c But if I concatenate like this > cat("VAR: ", var, "\n") I obtain >VAR: 1 and I

Hola a todos Estoy aprendiendo a trabajar con el paquete de RMySQL, y a la vez con bases SQL, así que a lo mejor no es tan complicado. Quiero agregar valores, que genero en R, a una tabla de SQL más o menos la idea es: > ssql<-"INSERT INTO tabla1 (variableA, variableB) VALUES (''valor1'',''valor2'')" > dbSendQuery(conec, ssql) pero

Hello, I am using acts as paranoid which works great. But I have the following problem. I have table a which has a has_many :tableb, :dependent => false relationship with table b. If I delete something in a and then try to edit a field in table b I get an error because it says the data does not exist so it doesn''t allow the update. I understand of course why this happens but I

I am uploading a .csv file for importing into a database; however, this file does not need to be saved on the server. How do I get the file name of the original file? I know about the file_column plugin but I don''t need/want to save the uploaded file on the server, I just need to import it and delete it. Right now the file name get returned as some random temp file name... there has to be

I''m working with three models: - Charge. has_many :budget_plans - BudgetPlan. belongs_to :charges, :rollups - Rollup. has_many :budget_plans This works out perfectly. A budget plan contains the ID of a charge and rollup and then there''s a 3rd attribute for hours. So working with data is no problem. My budget plan scaffold works nicely so I can select a charge, select a

Hi, The problem was the row.names that were sent to the database and created an primary key duplicate. Now it works fine. BTW congratulations for the package. It copied 15300 rows by 11 columns in less than 5 seconds, in my PIII 833 with 1 GB RAM. > system.time(dbWriteTable(con, "TBL_SIMDATA", TBL.SIMDATA, append = TRUE, row.names=F)) [1] 3.87 0.05 4.86 0.01 0.00 Just one

Hi, I get an unexpected error because i havent do any chnages in any javascript files, after installing active scaffold. Before 1-2 days my application is working fine but from yesterday i got the error for RJS as below while i tried for show action. RJS error: TypeError: $("#console__private_messages-messages") is null $("#console__private_messages-messages").html("\n

I need to find out how I can create and save a large dataset to a table based on multiple returned arrays from a Rake task. Here is my example using just two arrays (there are 14 in this particular rake task): update_tsos_offense = TsosOffense.new to_team_id, to_ppcs = update_tsos_offense.calculate_tsos(TotalOffense, "ydspgm", "desc") ro_team_id, ro_ppcs =