search for: tableb

...e 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'' set_primary_key :an_id # singular PK belongs_to :code_name, :class_name=>''TableA'', :primary_key=>:pk_code_name, :foreign_key=>:code SELECT = "*, table_a.name AS pk_name" def self.g...

I need to compare a column in TableA to a column in TableB and then select 3 columns from TableA for all the records in TableA that don''t exist in TableB. TableA and TableB are different but do have one field in common that i am comparing. The tables are not related in anyway. right now I have a find_by_sql query located in a model that looks...

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...

...the interface the packet gets routed onto. The setup looks something like this: Interface IP Gateway Table Network --------- -- ------- ----- ------- intA ipA gwA tableA netA intB ipB gwB tableB netB intC ipC gwC tableC netC [intD is the LAN interface] intD ipD (private) no gateway global netD This works fine most of the time, except that once in a while (every 5-10 minutes or so) packets going out on (e.g.) intB suddenly start getting NAT'...

...a really really long syntax. Hope someone know some smart function that I can use to solve my problem in an elegant way. Thanks for reading. Erick ###### begin R code ###### DBquery ? ? <- list(tableA=data.frame(id = numeric(0), atwin = numeric(0), atrout = numeric(0)), ? ? ? ? ? ? ? ? ? ?tableB=data.frame(id = numeric(0), mq ? = numeric(0), z = numeric(0), m = numeric(0)), ? ? ? ? ? ? ? ? ? ?tableC=data.frame(V1 = numeric(0), mfn ? = numeric(0), iiff = numeric(0)), ? ? ? ? ? ? ? ? ? ?tableD=data.frame(id ? ?= numeric(0), msf ? = numeric(0), oom ?= numeric(0))) lookup ? ? <- list(tab...

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 Create It. -------------- next part -------------- An HTML attachment was scrubbed......

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 can''t figure out a solution. I...

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, tableb_id) values (123,456) or maybe INSERT INTO join_table (id, tablea_id, tableb_id) values (nextval(''join_table_seq'...

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