I have a stored proceedure in my postgresql db 8.4.4
CREATE OR REPLACE FUNCTION approvetime(jobid int) RETURNS void AS $$
DECLARE
jobid int;
BEGIN
UPDATE t_e_time SET c_is_accepted = TRUE WHERE c_job_id = jobid;
END;
$$ LANGUAGE plpgsql;
I created the stored proceedure AcceptETimeForJob with the External Name as the
name of the function (approvetime) in EOModeler with an argument of jobid. At
least this is what I thought I should do.
I created a NSDictionary
keyDictionary.setObjectForKey(Integer.parseInt(jobListArray.objectAtIndex(i).primaryKey()),
"jobid");
then I issued (at least I thought)
EOUtilities.rawRowsForStoredProcedureNamed(theProject().editingContext(),
"AcceptETimeForJob", keyDictionary);
the only thing I see in the pg logs is:
asacksadmin 127.0.0.1(65462)LOG: 00000: execute <unnamed>: select * from
approvetime ($1) as result
asacksadmin 127.0.0.1(65462)DETAIL: parameters: $1 = '10072'
what am I doing wrong? I have been trying every permutation of this and that
and my head is starting to hurt.
Ted
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
