activescaffold, sql exception
Posted in Forums : Ask a Rails expert
Authority 12
Posting Rating 0
Sign in to rate this post
|
Hi, i’m using activescaffold for the first time with SQLSERVER 2005, in a trivial example. I had to make a change to the sqlserver adapter to get it to work at all, since it was trying to escape the id aka select \.id. I found a fix for this on the web, but now I get an exception again on sqlserver
DBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
The multi-part identifier "laycans.id" could not be bound.
HRESULT error code:0x80020009
Exception occurred.: SELECT * FROM (SELECT TOP 15 * FROM (SELECT TOP 15 * FROM laycans ORDER BY laycans.[id] ASC) AS tmp1 ORDER BY laycans.[id] DESC) AS tmp2 ORDER BY laycans.[id] ASC
any ideas ? |
Other Recent Topics
Ask a Rails expert : How to work with ror 2.1.1 using Netbeans IDE 6.1
Ask a Rails expert : json gem error
Ask a Rails expert : Problem with break
Ask a Rails expert : activesupport string first method error
Ask a Rails expert : url_for broken ?
Ask a Rails expert : map.routes.rb pls help
Ask a Rails expert : how to h tag in controller
Ask a Rails expert : Problem with Restful routing and partial form
Ask a Rails expert : will_paginate, search and ajax
