Index: openacs-4/packages/lab-report/www/edit-section-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lab-report/www/edit-section-postgresql.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/lab-report/www/edit-section-postgresql.xql	12 May 2006 01:34:34 -0000	1.1
+++ openacs-4/packages/lab-report/www/edit-section-postgresql.xql	21 May 2006 05:29:44 -0000	1.2
@@ -3,7 +3,33 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.4</version></rdbms>
 
+   <fullquery name="lab_details">
+     <querytext>
+       SELECT l.lab_id, l.name AS lab_name, l.instructor_id,
+           to_char(l.start_date, 'YYYY') AS year
+       FROM lrc_lab l, lrc_lab_student_map s
+       WHERE s.lab_id = l.lab_id
+       AND l.lab_id = :lab_id
+       AND s.user_id = :author_id
+     </querytext>
+   </fullquery>
 
+   <fullquery name="template_details">
+     <querytext>
+       SELECT name AS template_name, description AS template_desc
+       FROM lrc_template
+       WHERE template_id = :template_id
+     </querytext>
+   </fullquery>
+
+   <fullquery name="section_details">
+     <querytext>
+       SELECT name AS section_name, description AS section_desc
+       FROM lrc_section
+       WHERE section_id = :section_id
+     </querytext>
+   </fullquery>
+
    <fullquery name="section_update">
      <querytext>
        UPDATE lr_section_content