Active_scaffold con SQLSErver

Angel_Mauricio_Pino · March 4, 2008, 9:05pm

Al intentar mostrara datos me sale :

SQL no reconoce el “”, ademas los alias de las tablas no corresponden
los ultimos referencias a comunas debería ser tmp1 y tmp2. El tema es
como lo arreglo??, me falta instalar algo?, con mysql si funciona.

ActiveRecord::StatementInvalid in ComunasController#index

DBI::DatabaseError: 37000 (170) [Microsoft][ODBC SQL Server
Driver][SQL Server]Línea 1: sintaxis incorrecta cerca de ‘’.: SELECT

FROM (SELECT TOP 15 * FROM (SELECT TOP 15 id FROM comunas ORDER BY
comunas.[id] ASC) AS tmp1 ORDER BY comunas.[[id]] DESC) AS tmp2
ORDER BY comunas.[[id]] ASC

RAILS_ROOT: ./script/…/config/…
Application Trace | Framework Trace | Full Trace

#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:128:in
log' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb:318:inexecute’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/connection_adapters/sqlserver_adapter.rb:502:in
select' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:inselect_all’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1199:in
select_limited_ids_list' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1191:inadd_limited_ids_condition!’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1179:in
construct_finder_sql_with_included_associations' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1167:inselect_all_rows’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1023:in
find_with_associations' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1021:incatch’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/associations.rb:1021:in
find_with_associations' #{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/base.rb:996:infind_every’
#{RAILS_ROOT}/vendor/rails/activerecord/lib/active_record/base.rb:418:in
find' #{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/finder.rb:103:infind_page’
#{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/paginator.rb:66:in
call' #{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/paginator.rb:66:inpage’
#{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/paginator.rb:93:in
call' #{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/paginator.rb:93:initems’
#{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/actions/list.rb:62:in
do_list' #{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/actions/list.rb:33:inlist’
#{RAILS_ROOT}/vendor/plugins/active_scaffold/lib/actions/list.rb:8:in
index' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:1095:insend’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:1095:in
perform_action_without_filters' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:632:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:incall’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:634:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:634:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:634:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:incall’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:incall’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:incall’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:438:incall’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:in
call_filter' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:638:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:449:in
call' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:637:incall_filter’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:619:in
perform_action_without_benchmark' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:inperform_action_without_rescue’
C:/ruby/lib/ruby/1.8/benchmark.rb:293:in measure' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/benchmarking.rb:66:inperform_action_without_rescue’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/rescue.rb:83:in
perform_action' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:430:insend’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:430:in
process_without_filters' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/filters.rb:624:inprocess_without_session_management_support’
#{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/session_management.rb:114:in
process' #{RAILS_ROOT}/vendor/rails/actionpack/lib/action_controller/base.rb:330:inprocess’
#{RAILS_ROOT}/vendor/rails/railties/lib/dispatcher.rb:41:in dispatch' #{RAILS_ROOT}/vendor/rails/railties/lib/webrick_server.rb:113:inhandle_dispatch’
#{RAILS_ROOT}/vendor/rails/railties/lib/webrick_server.rb:79:in
service' C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:inservice’
C:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in run' C:/ruby/lib/ruby/1.8/webrick/server.rb:173:instart_thread’
C:/ruby/lib/ruby/1.8/webrick/server.rb:162:in start' C:/ruby/lib/ruby/1.8/webrick/server.rb:162:instart_thread’
C:/ruby/lib/ruby/1.8/webrick/server.rb:95:in start' C:/ruby/lib/ruby/1.8/webrick/server.rb:92:ineach’
C:/ruby/lib/ruby/1.8/webrick/server.rb:92:in start' C:/ruby/lib/ruby/1.8/webrick/server.rb:23:instart’
C:/ruby/lib/ruby/1.8/webrick/server.rb:82:in start' #{RAILS_ROOT}/vendor/rails/railties/lib/webrick_server.rb:63:indispatch’
#{RAILS_ROOT}/vendor/rails/railties/lib/commands/servers/webrick.rb:59
C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
gem_original_require' C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:inrequire’
#{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
require' #{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:342:innew_constants_in’
#{RAILS_ROOT}/vendor/rails/activesupport/lib/active_support/dependencies.rb:495:in
require' #{RAILS_ROOT}/vendor/rails/railties/lib/commands/server.rb:39 C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:ingem_original_require’
C:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in
`require’
script/server:3

Request

Parameters: None

Show session dump

:usuario: 1
:return_to:
as:comunas:
:list: {}

flash: !map:ActionController::Flash::FlashHash {}

Response
Headers: {“cookie”=>[], “Content-Type”=>“text/html;
charset=iso-8859-1”, “Cache-Control”=>“no-cache”}

–
Angel Mauricio Pino G
[email protected]
Movil: 08-577.92.72