Displaying 2 results from an estimated 2 matches for "ending_date".
2006 Jul 31
1
Adding new rows to a db
...the
following values:
def addNewRow
@timesheet = Timesheet.find(:employee_id => ''1'',
:cost_code_id => ''14'',
:dept => ''007'',
:ending_date => ''2006-07-15'')
if @timesheet == nil
Timesheet.create(:employee_id => ''1'',
:cost_code_id => ''14'',
:dept => ''007'',
:ending_dat...
2007 Oct 25
1
find - group - postgres
...o
run the command in postgres and I am getting the same error...
controller code...
@client_slot_count = ClientSlotsDaily.find(:all,
:conditions => ["created_at > ? AND created_at < ? AND
facility_id = ? AND client_id IS NOT NULL",
starting_date, ending_date, @facility.id],
:group => ''client_id'')
error reported is...
PGError: ERROR: column "client_slots_dailies.id" must appear in the
GROUP BY clause or be used in an aggregate function
: SELECT * FROM client_slots_dailies WHERE (created_at > ''2007-05...