Forum OpenACS Development: Re: Schedule proc

Collapse
3: Re: Schedule proc (response to 1)
Posted by Brian Fenton on
Hi Carlos,

What happens when you run the proc in the developer shell?

Are you using a xql file? You seem to have a different query appearing in the error than the one you give in the proc definition:

select recent_ratings_id from recent_ratings
vs
select * from recent_ratings

(As a matter of style, I prefer not to use "select *" in queries, but instead to always name the columns I want. You might get a few surprises with "select *")

Brian