search for: workorder_id

...SQL Server. It''s similar to the false post I had earlier, but this is a real problem. Here''s my code: def find_recipes_for_workorder @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :joins => ''left join workorder on workorder.workorder_id = recipe.workorder_id'', \ :conditions => ["workorder.name = ?", params[:workorder][:name]] render :template => ''recipe/list'' end (paginate_with_sort at bottom of email.) Here''s the top of the error: Processing RecipeController#find_...

...error from Linux via freeTDS/ODBC to SQL Server with cod that runs fine against SQLite and MySQL. Here''s the code: def find_recipes_for_workorder_by_id @recipe_pages, @recipes = paginate_with_sort :recipes, :per_page => 10, \ :conditions => ["recipe.workorder_id = ?", params [:workorder]] render :template => ''recipe/list'' end (I''ve included the custom sorting code at bottom of message.) Here''s the top of the error: DBI::DatabaseError ( (8156) [unixODBC][FreeTDS][SQL Server]The column ''name'...