search for: net_el

Hi all, Windows XP Oracle 10g client OCI8 0.1.16 Ruby 1.8.5 Rails 1.1.6 I''m hitting weird behavior with the Oracle adapter and a find_by_sql call on a multi-table join. The SQL looks like this: SELECT DISTINCT e1.ip_address, loc.street, loc.city, loc.state FROM schema.net_element ne, schema.equipment e1, schema.equipment e2, schema.building b, schema.cust_loc cl, schema.location loc WHERE e2.equipment_id = e1.equipment_id AND e2.some_column like ''SOME_VAL%'' AND e1.equipment_id = ne.net_element_id AND ne.class_name = ''FooBar'' AN...