Forum OpenACS Q&A: Re: cr_delete_scheduled_files causing errors

Collapse
3: Re: cr_delete_scheduled_files causing errors (response to 2)
Posted by Jarkko Laine on 02/13/03 07:55 PM
Thanks, Dan

In oracle version (acs-content-repository-procs-oracle.xql) it seems to be something in between 😊 : 

select distinct crftd.path storage_area_key
          from cr_files_to_delete crftd
           where not exists (select 1
                             from cr_revisions r
                            where r.filename = crftd.path)
BTW, is your change just in HEAD or also in the 4-6 branch?
Collapse
4: Re: cr_delete_scheduled_files causing errors (response to 3)
Posted by Dan Wickstrom on 02/13/03 09:09 PM
No it's the same mistake on the oracle side.  Oracle doesn't require the 'as' keyword when declaring an alias.  I'll go ahead and fix that one too.