OpenACS

jeffd
committed
MAIN:jeffd:20030517123518
on 17 May 03
merge of 4.6.3b1 to HEAD
/lib/tasks-chunk-oracle.xql (+1 -1)
47 47                 et.task_id as revision_id,
48 48                 nvl(round(cr.content_length/1024,0),0) as content_length,
49 49                 et.late_submit_p,
50 50                 crmt.label as pretty_mime_type
51 51         from cr_revisions cr,
52 52                  evaluation_tasksi et,
53 53                  cr_items cri,
54 54                  cr_mime_types crmt
55 55         where cr.revision_id = et.revision_id
56 56           and grade_item_id = :grade_item_id
57 57           and cri.live_revision = et.task_id
58 58           and et.mime_type = crmt.mime_type
59 59     $assignments_orderby
60 60         
61 61       </querytext>
62 62 </fullquery>
63 63
64 64 <fullquery name="compare_due_date">     
65 65       <querytext>
66 66
67           select 1 from dual where :due_date > now()
  67         select 1 from dual where :due_date > sysdate
68 68         
69 69       </querytext>
70 70 </fullquery>
71 71
72 72 <fullquery name="get_group_id">     
73 73       <querytext>
74 74
75 75         select nvl((select etg2.group_id from evaluation_task_groups etg2,
76 76                                                       evaluation_tasks et2,
77 77                                                       acs_rels map
78 78                                                       where map.object_id_one = etg2.group_id
79 79                                                         and map.object_id_two = :user_id
80 80                                                         and etg2.task_item_id = et2.task_item_id
81 81                                                         and et2.task_id = :task_id),0)
82 82                from evaluation_tasks et3
83 83               where et3.task_id = :task_id
84 84
85 85 --              select evaluation__party_id(:user_id,:task_id)
86 86         
87 87       </querytext>