Working With Rails

Are you definitely getting nil back. With MySQL you should get a MySQL::Results object back that you can iterate over

results = ActiveRecord::Base.connection.execute("select * from customers")
while row = results.fetch_row do
    # process row here
end

Otherwise, have you tried creating a CvdbUser model and fetched the data with a find_by_sql method call?

This would also give you the benefit of returning ActiveRecord objects instead of just arrays of field values.

I tried this code in console:

ActiveRecord::Base.connection.execute(“select * from appPronet.cvdb_users”)
=> nil

And still don’t know why it is not doing as it should :) method connected? returns me true, not false…

Any others suggestions or experiences?

Could you provide the database you use? MySQL? PostgreSQL?
Anyway, Tim is right and you should get a *SQL::Results object back.
Moreover, did you try the same query using CvdbUser class method, like following:

CvdbUser.find_by_sql("select * from cvdb_users")

If that works, maybe you don’t need to precise the database (i even didn’t know one can do that..)

ActiveRecord::Base.connection.execute("select * from cvdb_users")

Anyway, i guess you already defined your ‘apppronet’ database in your config/database.yml file.
And, if you’re in development mode, default rails behaviour is to find the “apppronet-development”

Wish it helps,
Guillaume

If you need pure values, ActiveRecord::Base.connection.select_values(“your SQL here”) might be your friend.

@Guillaume: I’m dealing with MSSQL DB.
Query with find_by_sql directly over model works fine, but don’t over AvtiveRecord::BASE…
I’ll have to think about the way I can call table-valued functions.

Thanks Clemens, that’s perfect way to call scalar-valued functions in rails.

thanks again!

You can also do something like this (just an example):

results = YourController.find_by_sql(“SELECT xxx FROM table_controller WHERE field = 1”)