Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
comp.lang.ruby
Mysql::Error Table doesn't exist
Michael Furmaniuk
4/7/2009 3:37:00 PM
I installed the Windows mysql gem, I'm using MySQL on Windows, and have
been able to get the connection to work but am having trouble figuring
out what is happening with my query. What I have is (with non-essential
parts stripped out):
require 'active_record'
# Database connection
begin
dbconfig = YAML::load(File.open('../conf/database.yml'))
ActiveRecord::Base.establish_connection(dbconfig)
rescue
puts $!
end
class TestResults < ActiveRecord::Base
end
io.puts "What Agents do you want to see?\n"
io.print "Agent Name = "
my_agent = io.gets.chomp
io.puts "Looking for #{my_agent}\n"
begin
agents = TestResults.first()
io.puts %{Found #{agents.testname} - #{agents.status}}
rescue
puts $!
end
When I run interactively I can enter my Agent name but all I see then
is:
Mysql::Error: Table 'auto_harness_development.test_results' doesn't
exist: SELECT * FROM `test_results` LIMIT 1
I don't understand why test_results is getting appended to the table
name, or why its being inserted into the select statement as the table
name, is there a configuration parameter I need to set or am I just
misusing the query?
--
Posted via
http://www.ruby-...
.
1 Answer
Michael Furmaniuk
4/8/2009 5:40:00 PM
0
So, I ended up taking another look at this today and realized I hadn't
been paying as much attention to the naming as I would in Rails.
Changing:
> class TestResults < ActiveRecord::Base
to
class AutoHarnesses < ActiveRecord::Base
and
> agents = TestResults.first()
to
agents = AutoHarnesses.first()
I get my query to complete, I didn't realize ActiveRecord here was also
using the same naming standards as it does within Rails, but I should
have expected that since the access methods seem to be the same.
--
Posted via
http://www.ruby-...
.
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
Mysql::Error Table doesn't exist
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password