Displaying 2 results from an estimated 2 matches for "actual_end_d".
Did you mean:
actual_end
2006 Jan 17
4
find_by_sql column ordering defect?
...nt = "select id, " + columns.join('', '') + " from projects"
@objs = Project.find_by_sql(sqlstatement)
the breakpointer tells me that:
irb(#<ProjectsController:0x2aaaacb3aa80>):001:0> sqlstatement
=> "select name, begin_date, projected_end_date, actual_end_date from
projects"
which is the correct order for the sqlstatement.
I then extecute the @objs = Project.find_by_sql(sqlstatement) statement.
The ordering of the columns has been altered - thus messing up my
headers and the order of the columns:
@objs
=> [#<Project:0x2aaaacab1dc0 @att...
2006 Mar 09
4
sort-weirdness - active record issue?
I''m selecting data into a controller and sorting it. The code (in the
controller) looks like this:
def index
@assignments = []
tasks = Task.find(:all, :conditions => ["person_id = ? and
actual_end_date is null", session[:user].id.to_s ])
issues = Issue.find(:all, :conditions => ["person_id = ? and status
<> ''closed''" , session[:user].id.to_s] )
@assignments.concat(tasks)
@assignments.concat(issues)
@assignments= @assign...