similar to: Rails/MSSQL error

I''m trying to get basic unicode support working using the "Iteration A1" sample application from the "Agile Web Development With Rails" book. Following the "HowToUseUnicodeStrings" wiki document, I have made the following changes: config/environment.rb: # Include your application configuration below $KCODE = ''u'' require

I''ve got the following setup: category (hm) <-> (bt) activity An activity has an amount, date, location, note, and category. I''m sorting my activities table by category_id (foreign key in activity), but how do I sort it by category_name instead? Basically I just need category_name in the result set. Here''s what I have now: @all = Activity.find(:all, :order

Here''s what I get from wget -S: HTTP request sent, awaiting response... HTTP/1.1 200 OK Date: Wed, 28 Feb 2007 15:52:06 GMT Server: Apache/1.3.37 (Unix) mod_fastcgi/2.4.2 mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.4.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2 .8.28 OpenSSL/0.9.7a #<#<Class: 0x2a96d0b978>:0x2a96d0b928>Content-Type:

Hello. I am converting my Java app to Rails and I''ve hit something that has me a bit baffled. I''ve been fiddling with this for over an hour and trying many different combinations so at this point I''ve lost perspective. It''s probably something simple but I can''t see it anymore. I have a component that looks like this: <% for advertiser_category in

I''m on rails edge and am calling an after filter on my actions. Works except for my ajax calls via link_to_remote. When I inspect headers, I see the ''Content-Type'' is key for an object rather than a string. Shouldn''t it be a string? Anyone know if this is a bug or if I''m dealing with this incorrectly. Thanks, Jamie The code: after_filter

How to set the default language in GetText? The default language of GetText is en,and I want to change it to another language,and also keep the ability to change to any other languages by just click the according href. Currently I use: class ApplicationController < ActionController::Base before_filter :set_charset def set_charset @headers["Content-Type"] = "text/html;

Hi, add_rjs_to_action_view.rb of javascript_generator_templates doesn''t work with setting Content-Type in a controller. (e.g.) http://wiki.rubyonrails.org/rails/pages/HowtoSetDefaultEncoding class ApplicationController < ActionController::Base before_filter :set_charset def set_charset @headers["Content-Type"] = "text/html; charset=utf-8" end end I

Hello, my application controller defines before_filter :set_charset def set_charset @headers["Content-Type"] = "text/html; charset=ISO-8859-1" end Everything is fine and accents are rendered correctly in the browser. However, when I call a controller/action from Ajax (Prototype), the charset is not taken in account and accents are garbage displayed (''?''

I''m trying to implement the to_param method to allow url generation to be in the format of /:category_name/:article_permalink (as discussed on page 299 of Agile Web Development With Rails). I expect that I need to override/implement the to_param method and have it return the category_name for the category model and the article_permalink for my article model, but I haven''t

I have MySQL on a Linux (RH) server and Mac OSX. I did a mysqldump on the Linux box and imported it into the database on the Mac. The following text is in one of the fields: Maui???s Westin Ka???anapali This is supposed to read Maui''s Westin Ka''anapali [note: straight quotes shown here are really apostrophes] In fact, it renders properly when served up from the Linux box

I want to use yum-cron with email notificaton. The upgrade runs, but i get no message. yum-cron aborted with this message: [root at h1 yum]# yum-cron Traceback (most recent call last): File "/usr/sbin/yum-cron", line 711, in <module> main() File "/usr/sbin/yum-cron", line 708, in main base.updatesCheck() File "/usr/sbin/yum-cron", line 631,

Hi I''m trying to use german characters on a ruby on rails application, but for get ? on dropwdown menus. The database, tables and fields are encoded utf8_general_ci. I have this in my application controller: class ApplicationController < ActionController::Base before_filter :set_charset before_filter :configure_charsets def set_charset @headers["Content-Type"] =

Hello, I have rails using a MSSQL db. The set up works fine with low volume, but with 2+ requests/second I keep on getting the following error: DBI::DatabaseError: Execute OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction mode. HRESULT error code:0x80020009 Exception occurred.: SELECT

There is something seriously wrong with DBI support for SQL server. I have tried both DBI::ODBC and DBI:ADO and the following code always fails. ---------- Code require ''dbi'' host= "DEVELOPMENT_DATABASE_SERVER" database="adventureworks2000" username="someusername" password="Somepwd" db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data

Rails is throwing this error C:/Ruby/Depot/app/views/products/index.html.erb:28: syntax error, unexpected tSTRING_BEG, expecting keyword_do or ''{'' or ''('' ...er.privilege == 50 ? {link_to ''Show'', product} : ''a'' );@out... in line <%= current_user.privilege == 50 ? {link_to ''Show'', product} :

Hi All, I am having a problem to access multiple databases with mssql I am running Ruby 1.8.4 and Rails 1.1 on Windows 2000 Advanced Server. I am simply trying to integrate the application I wrote before for Oracle to Mssql. The application works perfectly with Oracle with the installed driver OCI8. The app retrives data based on a search criteria from those databases. I followed the directions

I''m trying to use activerecord outside of rails with a legacy mssql database. Reading from the db works, but when I try to save a new object (i.e. insert) I get the following error. DatabaseError: Execute (ActiveRecord::StatementInvalid) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server Cannot create new connection because in manual or distributed transaction

hey there folks, i have a bit of a sitch here and i would love some help/input on it. i''ve inherited a horrible asp/mssql app that i''m re-writting using rails, but unfortunately i have to keep the asp version up and running. in order to do so i''ve had to write some admin functions, which i''ve done in rails. because the mssql schema wasn''t written

Hi all, I started playing a couple days ago with Rails and it find it very interesting. But I''m a bit stuck with making it work with a concatenated primary key. I want to use my own names for the DB fields and I''m using SQL Server 2005. My tables look roughly like this: CREATE TABLE USERS ( USR_ID VARCHAR(25) NOT NULL PRIMARY KEY, USR_PASS VARCHAR(25) ) CREATE TABLE

"bitsweat" has given AR/SQLServer some love, but it''s still unhappy... http://dev.rubyonrails.org/changeset/6912 ------------------------------------------------------------------------ r6912 | bitsweat | 2007-05-31 10:15:56 -0700 (Thu, 31 May 2007) | 1 line Fix an edge case with find with a list of ids, limit, and offset. Closes #8437.