OpenACS

gustafn
committed
MAIN:gustafn:20060908214945
on 08 Sep 06
less tracing, fixing empty parameters
/tcl/ims-ent-dotlrn-procs.xql (+5 -5)
64 64       where class_key = :class_key
65 65     </querytext>
66 66   </fullquery>
67 67
68 68   <fullquery name="ims_enterprise::ims_dotlrn::groups::class.map_class">
69 69     <querytext>
70 70       insert into ims_ent_dotlrn_class_map (community_id, class_instance_key)
71 71       values (:class_instance_id, :class_instance_key)
72 72     </querytext>
73 73   </fullquery>
74 74
75 75   <fullquery name="ims_enterprise::ims_dotlrn::get_community_id.get_comm_id">
76 76     <querytext>
77 77       select community_id from ims_ent_dotlrn_class_map
78 78       where class_instance_key = :class_instance_key
79 79     </querytext>
80 80   </fullquery>
81 81
82 82   <fullquery name="ims_enterprise::ims_dotlrn::groups::guess_term.get_best_term">
83 83     <querytext>
84         select term_id
  84       (select term_id
85 85       from dotlrn_terms
86 86       where start_date >= :start_date
87 87       and end_date <= :end_date
88         order by end_date DESC
  88       order by end_date DESC)
89 89       UNION
90         select term_id
  90       (select term_id
91 91       from dotlrn_terms
92 92       where end_date >= now()
93         order by end_date DESC
  93       order by end_date DESC)
94 94       limit 1
95 95     </querytext>
96 96   </fullquery>
97 97
98 98 </queryset>