Rails - Nov 2006 - AR object sees columns in table twice???!!!???

AR 1.14.4
SQL Server 2000 (ODBC)

I have a model named Target that looks like this:

class Target < ActiveRecord::Base
  set_table_name :FAXNET
  set_primary_key :UniqueID

...
end

In ruby script/console, if I do
Target.column_names.each do |col|
  puts col
end

I see a list of the column names, immediately followed by another list 
of the column names - they''re duplicated!!!  Assume columns A, B, C.  I
see

A
B
C
A
B
C

If I run annotate_models against this object, my annotate_models shows 
that there are two sets of columns!

This doesn''t happen with any of my other models, and I''ve
verified
several times that the table looks correct.

Has anyone ever seen this?

Thanks,
Wes

-- 
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, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Aha!

The table was defined in my database twice with two different owners.

The query to pull the column names doesn''t filter by owner
(TABLE_SCHEMA
column in the INFORMATION_SCHEMA.COLUMNS pseudo-table).

Wes

-- 
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, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---