similar to: Pagination error on SQLSERVER

Hi I''m new to Rails (and Ruby) and I can''t get it to work properly. Every time I want to do something with my database-connection (e.g. use scaffold) I get this, or something similiar (from development.log): >> Beneath this code there''s some more text << ------- Processing CategoryController#index (for 127.0.0.1 at Tue Apr 26 21:43:45 CEST 2005)

Hello! I''m a beginner of rails. I made a simple test project with rails 1.1.2 and ruby 1.8.2 on Windows XP. DB is SQLServer 7.0. I''m connecting the server thru ODBC. I created a table named "users" with about 10 columns. I inserted 1000 sample records. I created a scaffold for user model and login controller for it using the script. Everything''s fine

Trying to create stuff without resorting to scaffold command. I have a list view in my login_controller.rb file... def list_users @user_pages, @users = paginate :users, :per_page => 14 end I have a command in my list_users.rhtml file which undoubtedly calls this pagination... <% odd_or_even = 0 for user in @users odd_or_even = 1 - odd_or_even %> and instead of being presented a

So I got my rails app to connect to the SQLServer via ODBC, and I can model/scaffold, yada yada.. but when I need to exec a stored proc using sql_server.rb I get undefined local variable or method `connection'' how can that be, if I can connect for everthing else? thanks -- Posted via http://www.ruby-forum.com/.

Hello, maybe that I''m a stupid, but I don''t know how I can working with pagination. In all examples is written (for example) next: def user_list @user_pages, @users = paginate(:users, :order_by => ''name'') end So, it''s OK (as a scaffold) for all set of users. But I need a little other functionality. For example I need paginate only a little bit

How does one do pagination with link_to_remote calls so the pagination can be done with AJAX? For example, this obviously works out of the box with the standard scaffold: <%= link_to ''Next page'', { :page => @image_pages.current.next } if @image_pages.current.next %> to get users to the next page. The tutorial at: http://wiki.rubyonrails.com/rails/pages/How+to

Hello people, I am starting to build an application in Rails using SQLServer. In fact, I''m rebuilding it from Java EE to Rails. I created a new project and managed to connect to the database using ODBC, so I ran a rake db:migrate. Everything worked fine: the database schema was copied to my schema.rb file. Here comes my problem: is there a command that creates ruby classes from the

Hi there, I''m running ROR 2.x on Win32 tried to run gem install activerecord-sqlserver-adapter --source http://gems.rubyonrails.org and get this: D:\>gem install activerecord-sqlserver-adapter -source http://gems.rubyonrails.org Bulk updating Gem source index for: http://gems.rubyonrails.org ERROR: While executing gem ... (Gem::GemNotFoundException) Could not find

Hi! I''ve just started using AR on top of SqlServer 2005 (through ADO: http://www.softiesonrails.com/articles/2006/06/28/activerecord-with-sqlserver-without-rails). Not a Rails site per se, but I''m using AR and ruby to build data aggregation tools. If you have used AR with SqlServer 2005 and met quirks or caveats of some kind, I''d be happy to get some feedback from your

I am trying to do a simple search by product name. The first page returns fine, but when I try to go to any other pages of the search results, I lose the original search parameters from my search form and get NilClass errors. Here is the code in my controller: namesearch = "%" + params[:name].strip + "%" @product_pages, @products = paginate :product,

Hi, I have a table with columns : id,user_id,nickname,create_time. and i create my rails application , with scaffold, it can not display user_id column, others are correct, Why? -- Best Regards, Caiwangqin http://www.uuzone.com Mobile: +8613951787088 Tel: +86025-84818086 ext 233 Fax: +86025-84814993 -------------- next part -------------- An HTML attachment was scrubbed... URL:

I have been trying to find the adtiverecord adaptor for MS SQL server and attempted to install with the command found on the http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer wiki page: gem install activerecord-sqlserver-adapter --source=http:// gems.rubyonrails.org I then got the error message: ERROR: could not find activerecord-sqlserver-adapter locally or in a

So, I''ve used Rails to tie into a legacy system which is on SQL Server 2000 with a required timestamp field, DBTimeStamp. The field is defined in SQL Server as type timestamp, but when rails is pulling it in, it appears it may be casting to a datetime format. So, when I try to read or write to the field, it gives me a parsing error: NoMethodError: private method

Hi, Here im not able to connect with MS-SQLSERVER database with *.R-File. Previously i was able to do in R in different machine and configuration was R Ver-2.11.1 Package Installed : RODBC_1.3-2 And now where im doinig now there the same code im trying to execute but its not connecting. configuration is, R Ver-2.12 Package Installed : RODBC_1.3-2 - here iam trying to install (RODBC_1.3-6) which

Hola, Yo empleo RODBC, previamente he creado el origen de datos ODBC en mi equipo y hago: library(RODBC) odbc_con <- odbcConnect("origenODBC") siniestros <- sqlQuery(odbc_con," SELECT * FROM tal.tal") odbcCloseAll() Con VPN en remoto y demás, sin problemas. Saludos. -------- Mensaje Original -------- Asunto: Re: [R-es] Conexion a

Pagination I am using an old tutorial which is tripping me right up as I have the latest version of rails installed. I''m persisting as I think I''m learning a little bit more about how RoR works. However after installing the scaffolding plug-in to fix an earlier problem I now have a problem with the pagination. I have followed this workaround:

New to rails. Installed rails on my XP desktop, and setup my first app that will use an existing SQLServer database. I am able to connect to SQLServer using odbc with following code. require ''rubygems'' require ''ActiveRecord'' ActiveRecord::Base.establish_connection( :adapter => ''sqlserver'', :mode => ''odbc'', :dsn

I''m using RoR 1.0, Windows 2000, and SQL Server 2000. I am connecting to the database using these directions: http://wiki.rubyonrails.com/rails/pages/HowtoConnectToMicrosoftSQLServer. Using the scaffold generator to generate the default files (ruby script/generate scaffold Location) I start up WebBrick and pull up the page. There are 58 records in the table. I am given the first 10

I''m trying to connect to a SQL Server db. I thought I installed the DBI component per the instructions, but its not working. When trying to start the ruby server, I get the message: Please install the sqlserver adapter: `gem install activerecord- sqlserver-adapter` But when I try to install the repository, I get this error message: could not find activerecord-sqlserver-adapter

Hi, Why can''t I use a variable to specify the :per_page attribute when using the most basic form of pagination? (if I use a hardcode number, it runs) What did I do? Thx. My code: def list_orders page_size = 20 ... order_pages, @orders = paginate(:orders, :per_page => page_size) end My Errors: undefined method `>'' for false:FalseClass RAILS_ROOT: