RE: Why doesn't this work!

Okay. So I might see the issue.

Looking in the development.log file I see:

e[4;35;1mTechStandard Load (0.015000)e[0m e[0mSELECT * FROM
tech_standards WHERE subpoint <> 0e[0m

Then I see:

e[4;36;1mTechStandard Columns (0.000000)e[0m e[0;1mSHOW FIELDS FROM
tech_standardse[0m

Is that the problem?

The SHOW FIELDS is just Rails getting the names of the columns, try
that in your MySQL client and you’ll see.

Your log is displaying in ANSI colors, which is why it looks a little
off. You can disable that with:

ActiveRecord::Base.colorize_logging = false

But why don’t you cut and paste that select statement into a MySQL
client and see what you get back? Are you sure this command works as
you’d like?

On 2/17/06, Buntin, Seth - KATE [email protected] wrote:

tech_standardse[0m
you sure of your syntax?

http://lists.rubyonrails.org/mailman/listinfo/rails
Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

  • Nic